public TransporterGroup Update(TransporterGroup TG, string userid) { var sqlQuery = string.Format(@"UPDATE TRANSPORTERGROUP SET IDTRANSPORTERGROUP = '{0}', TRANSPORTERGROUPNAME = '{1}', UPDATEBY = {2}, UPDATEDATE = '{3}' WHERE SID = {4}", TG.IDTRANSPORTERGROUP, TG.TRANSPORTERGROUPNAME, Convert.ToInt32(userid), DateTime.Now, TG.SID); this._db.Execute(sqlQuery, TG); return(TG); }
public TransporterGroup Add(TransporterGroup TG, string userid) { var sqlQuery = @"INSERT INTO TransporterGroup (IDTRANSPORTERGROUP, TRANSPORTERGROUPNAME, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES ('" + TG.IDTRANSPORTERGROUP + @"', '" + TG.TRANSPORTERGROUPNAME + "', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)"; var SID = _db.Query <int>(sqlQuery, TG).Single(); TG.SID = SID; return(TG); }
public JsonResult Edit(TransporterGroup transportergroup, string userid) { try { if (ModelState.IsValid) { ITG.Update(transportergroup, Session["userid"].ToString()); } } catch { return(Json("error")); } return(Json("success")); }