User-369506445 posted
I create a sample for you, please follow it step by step
<g class="gr_ gr_34 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" id="34" data-gr-id="34">First</g> create a Web API project
then create a Model <g class="gr_ gr_107 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="107" data-gr-id="107">basedon</g> your table
public class PraptraEntity
{
public int pid { get; set; }
public DateTime r_date { get; set; }
public string r_month { get; set; }
public int DistrictId { get; set; }
public DateTime createddate { get; set; }
public int status { get; set; }
public decimal cell_02 { get; set; }
public decimal cell_03 { get; set; }
public decimal cell_04 { get; set; }
public decimal cell_05 { get; set; }
public decimal cell_06 { get; set; }
public decimal cell_07 { get; set; }
public decimal cell_08 { get; set; }
public decimal cell_09 { get; set; }
public decimal cell_10 { get; set; }
public decimal cell_11 { get; set; }
public string cell_12 { get; set; }
}
then create <g class="gr_ gr_40 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Grammar multiReplace" id="40" data-gr-id="40">a <g class="gr_ gr_39 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling ins-del multiReplace"
id="39" data-gr-id="39">api</g></g> controller called PraptraController
public class PraptraController : ApiController
{
//suppose your model is below
List<PraptraEntity> Model = new List<PraptraEntity>() {
new PraptraEntity()
{
pid = 1,
r_date = DateTime.Now,
r_month ="05",
createddate=DateTime.Now ,
DistrictId = 1 ,
status = 0
}
};
// GET: api/Praptra
public IEnumerable<PraptraEntity> Get(string month)
{
var result = Model.Where(x => x.r_month == month).ToList();
return result;
}
}
public class PraptraEntity
{
public int pid { get; set; }
public DateTime r_date { get; set; }
public string r_month { get; set; }
public int DistrictId { get; set; }
public DateTime createddate { get; set; }
public int status { get; set; }
public decimal cell_02 { get; set; }
public decimal cell_03 { get; set; }
public decimal cell_04 { get; set; }
public decimal cell_05 { get; set; }
public decimal cell_06 { get; set; }
public decimal cell_07 { get; set; }
public decimal cell_08 { get; set; }
public decimal cell_09 { get; set; }
public decimal cell_10 { get; set; }
public decimal cell_11 { get; set; }
public string cell_12 { get; set; }
}
now run your project and enter the below <g class="gr_ gr_300 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="300" data-gr-id="300">addres</g> on <g class="gr_ gr_315 gr-alert gr_gramm gr_inline_cards gr_run_anim
Grammar only-ins doubleReplace replaceWithoutSep" id="315" data-gr-id="315">browser</g>
http://localhost:51984/api/Praptra?month=05
just change localhost:51984 to your address
