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