public ActionResult Create(FieldMaster Field, string userid) { if (ModelState.IsValid) { if (Field.ISACTIVE) { Field.ISACTIVEDATE = DateTime.Now; } Field.COMPANYSITE = int.Parse(Session["companysite"].ToString()); FM.Add(Field, Session["userid"].ToString()); TempData["successmessage"] = "Saved successfully"; return(RedirectToAction("Create")); } else { Field.GetSelectListBlockMaster = GetSelectListBlockMaster(); Field.GetSelectListCrop = GetSelectListCrop(); Field.GetSelectListPlantingMaterial = GetSelectListPlantingMaterial(); Field.GetSelectListPlantingDistance = GetSelectListPlantingDistance(); Field.GetSelectListFieldStatus = GetSelectListFieldStatus(); Field.GetSelectListOwnership2 = GetSelectListOwnership2(); Field.GetSelectListProgeny = GetSelectListProgeny(); return(View(Field)); } }
/// <summary> /// Create Common Master /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task <Message <FieldMaster> > SaveCommonMasterDetails(FieldMaster model) { var requestUrl = CreateRequestUri(string.Format(System.Globalization.CultureInfo.InvariantCulture, "internal/masters")); return(await PostAsync <FieldMaster>(requestUrl, model)); }
public FieldMaster Add(FieldMaster FM, string userid) { var sqlQuery = @"INSERT INTO FIELDMASTER (IDFIELDMASTER, FIELDMASTERNAME, BLOCKMASTER, CROPTYPE, PROGENY, PLANTINGMATERIAL, HECTPLANTED, PLANTINGPOINTNUM, PLANTINGDISTANCE, TOTALSTAND, PLANTINGDATE, STANDPERHECT, EMPTYHOLE, FIELDSTATUS, HARVCOMMDATE, HECTHARV, OWNERSHIP, CARRYDISTANCE, ISACTIVE, ISACTIVEDATE, COMPANYSITE, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES ('" + FM.IDFIELDMASTER + @"', '" + FM.FIELDMASTERNAME + @"', '" + FM.BLOCKMASTER + @"', '" + FM.CROPTYPE + @"', '" + FM.PROGENY + @"', '" + FM.PLANTINGMATERIAL + @"', '" + FM.HECTPLANTED + @"', '" + FM.PLANTINGPOINTNUM + @"', '" + FM.PLANTINGDISTANCE + @"', '" + FM.TOTALSTAND + @"', '" + FM.PLANTINGDATE + @"', '" + FM.STANDPERHECT + @"', '" + FM.EMPTYHOLE + @"', '" + FM.FIELDSTATUS + @"', '" + FM.HARVCOMMDATE + @"', '" + FM.HECTHARV + @"', '" + FM.OWNERSHIP + @"', '" + FM.CARRYDISTANCE + @"', '" + FM.ISACTIVE + @"', '" + FM.ISACTIVEDATE + @"', '" + FM.COMPANYSITE + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)"; var SID = _db.Query <int>(sqlQuery, FM).Single(); FM.SID = SID; return(FM); }
public FieldMaster Update(FieldMaster FM, string userid) { var sqlQuery = string.Format(@"UPDATE FIELDMASTER SET FIELDMASTERNAME = '{0}', BLOCKMASTER = '{1}', CROPTYPE = '{2}',PROGENY = '{3}', PLANTINGMATERIAL = '{4}', HECTPLANTED = '{5}', PLANTINGPOINTNUM = '{6}', PLANTINGDISTANCE = '{7}', TOTALSTAND = '{8}', PLANTINGDATE = '{9}', STANDPERHECT = '{10}', EMPTYHOLE = {11}, FIELDSTATUS = {12}, HARVCOMMDATE = '{13}', HECTHARV = '{14}', [OWNERSHIP] = '{15}', CARRYDISTANCE = '{16}', ISACTIVE = '{17}', ISACTIVEDATE = '{18}', COMPANYSITE = '{19}', UPDATEBY = {20}, UPDATEDATE = '{21}' WHERE SID = {22}", FM.FIELDMASTERNAME, FM.BLOCKMASTER, FM.CROPTYPE, FM.PROGENY, FM.PLANTINGMATERIAL, FM.HECTPLANTED, FM.PLANTINGPOINTNUM, FM.PLANTINGDISTANCE, FM.TOTALSTAND, FM.PLANTINGDATE, FM.STANDPERHECT, FM.EMPTYHOLE, FM.FIELDSTATUS, FM.HARVCOMMDATE, FM.HECTHARV, FM.OWNERSHIP, FM.CARRYDISTANCE, FM.ISACTIVE, FM.ISACTIVEDATE, FM.COMPANYSITE, Convert.ToInt32(userid), DateTime.Now, FM.SID); this._db.Execute(sqlQuery, FM); return(FM); }
// // GET: /Field/Create public ActionResult Create() { var model = new FieldMaster(); model.ISACTIVE = true; model.GetSelectListBlockMaster = GetSelectListBlockMaster(); model.GetSelectListCrop = GetSelectListCrop(); model.GetSelectListPlantingMaterial = GetSelectListPlantingMaterial(); model.GetSelectListPlantingDistance = GetSelectListPlantingDistance(); model.GetSelectListFieldStatus = GetSelectListFieldStatus(); model.GetSelectListOwnership2 = GetSelectListOwnership2(); model.GetSelectListProgeny = GetSelectListProgeny(); return(View(model)); }
public async Task <ActionResult> SaveCommonMaster([FromBody] MasterViewModel master) { FieldMaster model = new FieldMaster() { Name = master.Name, GroupCode = master.GroupCode, Status = master.Status, CreateDate = master.CreateDate, Description = master.Description }; _context.FieldMasters.Add(model); await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(MastersByIdAsync), new { id = model.Id }, model)); }
public async Task <IActionResult> CreateMaster([Bind(include: "GroupCode,Name,Status,Description")] FieldMasterViewModel model) { if (ModelState.IsValid) { FieldMaster fmaster = new FieldMaster() { GroupCode = model.GroupCode.ToUpper(), Name = model.Name, Status = model.Status, CreateDate = CommonMethod.GetCurrentDate(), Description = model.Description }; var response = await ApiClientFactory.Instance.SaveCommonMasterDetails(fmaster); if (response.StatusCode == 201) { return(RedirectToAction("FieldMaster")); } } return(View("../Internal/CommonMaster", model)); }
public async Task <IActionResult> GetFieldMaster(int?skip, int?top, string columns, string FIELD_ID_EC, DateTime?FIELD_V_START_DATE, string DBSOURCE_ID) { try { int s = (skip == null) ? 0 : skip.GetValueOrDefault(); int t = (top == null) ? 1000 : top.GetValueOrDefault(); if (s < 0) { return(BadRequest("Skip can't be a negative number")); } if (t < 1) { return(BadRequest("Top can't be less then 1")); } if (columns != null) { columns = columns.Replace(" ", ""); } /* This section is used to check the existence of columns suplied in the request, * and in the event of no columns being supplied finds a list of each column of the given model. */ FieldMaster obj = new FieldMaster(); var cols = obj.GetType().GetProperties().Select(e => e.Name.ToUpper()).ToArray(); if (columns == null) { columns = string.Join(",", cols); } else { string[] colSplit = columns.Split(','); foreach (string col in colSplit) { if (!cols.Contains(col.Trim().ToUpper())) { return(BadRequest(col + " is not a valid column")); } } } /* This section takes care of the db request. * Here Linq.Dynamic.Core is used to dynamically select specific columns. */ var result = _db.FieldMaster .Where(e => (e.FIELD_ID_EC == FIELD_ID_EC || FIELD_ID_EC == null) && (e.FIELD_V_START_DATE >= FIELD_V_START_DATE || FIELD_V_START_DATE == null) && (e.DBSOURCE_ID == DBSOURCE_ID || DBSOURCE_ID == null) ) .Skip(s) .Take(t) .Select("new(" + columns + ")"); var response = await result.ToDynamicListAsync(); return(Ok(response)); } catch (Exception e) { _logger.LogError($"Something went wrong in GetFieldMaster: {e.Message}. Stacktrace: {e.StackTrace}"); return(StatusCode(500)); } }