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));
}
}
