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