public BlockUsage Add(BlockUsage BU)
{
var sqlQuery = @"INSERT INTO BLOCKUSAGE (BLOCKMASTER, USAGE, HECTARAGE, COMPANYSITE, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES
(" + BU.BLOCKMASTER + @", " + BU.USAGE + ", '" + BU.HECTARAGE + "', '" + BU.COMPANYSITE + @"', " + BU.INPUTBY + ", '" + BU.INPUTDATE + @"', " + BU.UPDATEBY + ", '" + BU.UPDATEDATE + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)";
var SID = _db.Query<int>(sqlQuery, BU).Single();
BU.SID = SID;
return BU;
}
public BlockUsage Update(BlockUsage BU)
{
var sqlQuery =
"UPDATE BLOCKUSAGE " +
"SET USAGE = '" + BU.USAGE + "', " +
" HECTARAGE = '" + BU.HECTARAGE + "', " +
" UPDATEBY = '" + Convert.ToInt32(BU.UPDATEBY) + "', " +
" UPDATEDATE = '" + BU.UPDATEDATE + "' " +
"WHERE SID = " + BU.SID + "";
this._db.Execute(sqlQuery, BU);
return BU;
}
public JsonResult Edit(BlockUsage blockusage)
{
try
{
if (ModelState.IsValid)
{
blockusage.UPDATEBY = int.Parse(Session["userid"].ToString());
blockusage.UPDATEDATE = DateTime.Now;
BU.Update(blockusage);
}
}
catch
{
return(Json("error"));
}
return(Json("success"));
}
public JsonResult Create(BlockUsage blockusage)
{
try
{
if (ModelState.IsValid)
{
blockusage.COMPANYSITE = int.Parse(Session["companysite"].ToString());
blockusage.INPUTBY = int.Parse(Session["userid"].ToString());
blockusage.INPUTDATE = DateTime.Now;
blockusage.UPDATEBY = int.Parse(Session["userid"].ToString());
blockusage.UPDATEDATE = DateTime.Now;
BU.Add(blockusage);
}
}
catch (Exception ex)
{
return(Json("error"));
}
return(Json("success"));
}
