// GET: api/CropStage/5 public List <CropStageViewModel> Get(string distBbsId) { CropStageViewModel result = new CropStageViewModel(); CropDailyStage oc = new CropDailyStage(); List <CropStageViewModel> data = new List <CropStageViewModel>(); using (CropStage db = new CropStage()) { oc.CropStageList = db.CropDailyStages.Where(c => c.DistBbsId == distBbsId).ToList(); data = oc.CropStageList.AsEnumerable().Select(c => new CropStageViewModel { Id = c.ID, Region = this.GetAreaCode(c.DistBbsId), District = c.DistBbsId, stg_rcv = c.Recovry, stg_tlr = c.Tillering, stg_pni = c.P_I, stg_btg = c.Booting, stg_flr = c.Flowering, stg_sdf = c.SoftDough, stg_hdf = c.HardDough, stg_rpn = c.Ripening, stg_hrv = c.Harvesting, Season = c.SeasonCode, FiscalCode = c.FiscalCode, DateCreated = c.DateCreated, MeasureDate = c.MeasureDate }).ToList(); } return(data); }
// POST: api/CropStage public void Post([FromBody] CropStageViewModel value) { CropDailyStage cds = new CropDailyStage(); cds.DistBbsId = value.District; cds.Recovry = value.stg_rcv; cds.Tillering = value.stg_tlr; cds.P_I = value.stg_pni; cds.Booting = value.stg_btg; cds.Flowering = value.stg_flr; cds.SoftDough = value.stg_sdf; cds.HardDough = value.stg_hdf; cds.Ripening = value.stg_rpn; cds.Harvesting = value.stg_hrv; cds.SeasonID = this.GetSeasonId(value.Season); cds.SeasonCode = value.Season; cds.FiscalCode = value.FiscalCode; cds.FiscalYearID = this.GetFiscalId(value.FiscalCode); cds.DistrictID = this.GetDistId(value.District); cds.DateCreated = DateTime.Now; cds.MeasureDate = value.MeasureDate; using (CropStage db = new CropStage()) { db.CropDailyStages.Add(cds); db.SaveChanges(); } }
// PUT: api/CropStage/5 public void Put(int id, [FromBody] CropStageViewModel value) { CropStage db = new CropStage(); CropDailyStage cds = new CropDailyStage(); cds.ID = id; cds.DistBbsId = value.District; cds.Recovry = value.stg_rcv; cds.Tillering = value.stg_tlr; cds.P_I = value.stg_pni; cds.Booting = value.stg_btg; cds.Flowering = value.stg_flr; cds.SoftDough = value.stg_sdf; cds.HardDough = value.stg_hdf; cds.Ripening = value.stg_rpn; cds.Harvesting = value.stg_hrv; cds.SeasonID = this.GetSeasonId(value.Season); cds.SeasonCode = value.Season; cds.FiscalCode = value.FiscalCode; cds.FiscalYearID = this.GetFiscalId(value.FiscalCode); cds.DistrictID = this.GetDistId(value.District); //var crop = db.CropDailyStages.Where(x => x.ID == id).FirstOrDefault(); db.CropDailyStages.Attach(cds); db.Entry(cds).State = EntityState.Modified; var bl = db.SaveChanges() > 0; }
public CropStageViewModelPub Get(int record_from, int record_to) { CropStageViewModelPub returnData = new CropStageViewModelPub(); if (record_to - record_from > 100) { return(returnData); } CropStage db = new CropStage(); CropStageViewModel result = new CropStageViewModel(); CropDailyStage oc = new CropDailyStage(); List <CropStageViewModel> data = new List <CropStageViewModel>(); var croplist = db.CropDailyStages.OrderBy(x => x.ID).Skip(record_from).Take(record_to).ToList(); returnData.TotalRecords = db.CropDailyStages.Count(); data = croplist.AsEnumerable().Select(c => new CropStageViewModel { Id = c.ID, Region = this.GetAreaCode(c.DistBbsId), District = c.DistBbsId, stg_rcv = c.Recovry, stg_tlr = c.Tillering, stg_pni = c.P_I, stg_btg = c.Booting, stg_flr = c.Flowering, stg_sdf = c.SoftDough, stg_hdf = c.HardDough, stg_rpn = c.Ripening, stg_hrv = c.Harvesting, Season = c.SeasonCode, FiscalCode = c.FiscalCode, DateCreated = c.DateCreated, MeasureDate = c.MeasureDate }).ToList(); returnData.CropStageViewModels = data; returnData.NextUrl = "http://localhost:53904/api/cropstage?record_from=" + record_to.ToString() + "&record_to=" + (record_to + 100).ToString(); return(returnData); }