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