public FixedAssetLocation Add(FixedAssetLocation FAL, string userid)
{
var sqlQuery = @"INSERT INTO FIXEDASSETLOCATION (IDFIXEDASSETLOCATION, FIXEDASSETLOCATIONNAME, DESCRIPTION, COSTCENTER, ISACTIVE, COMPANYSITE, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES
('" + FAL.IDFIXEDASSETLOCATION + @"', '" + FAL.FIXEDASSETLOCATIONNAME + "', '" + FAL.DESCRIPTION + @"', '" + FAL.COSTCENTER + @"', '" + FAL.ISACTIVE + @"', '" + FAL.COMPANYSITE + @"'," + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)";
var SID = _db.Query <int>(sqlQuery, FAL).Single();
FAL.SID = SID;
return(FAL);
}
public FixedAssetLocation Update(FixedAssetLocation FAL, string userid)
{
var sqlQuery =
string.Format(@"UPDATE FIXEDASSETLOCATION SET IDFIXEDASSETLOCATION = '{0}', FIXEDASSETLOCATIONNAME = '{1}', DESCRIPTION = '{2}', COSCENTER = '{3}', ISACTIVE = '{4}', COMPANYSITE = '{5}', UPDATEBY = {6}, UPDATEDATE = '{7}' WHERE SID = {8}",
FAL.IDFIXEDASSETLOCATION, FAL.FIXEDASSETLOCATIONNAME, FAL.DESCRIPTION, FAL.COSTCENTER, FAL.ISACTIVE, FAL.COMPANYSITE, Convert.ToInt32(userid), DateTime.Now, FAL.SID);
this._db.Execute(sqlQuery, FAL);
return(FAL);
}
public JsonResult Create(FixedAssetLocation FixedAssetLocation, string userid)
{
try
{
if (ModelState.IsValid)
{
FixedAssetLocation.COMPANYSITE = int.Parse(Session["companysite"].ToString());
FAL.Add(FixedAssetLocation, Session["userid"].ToString());
}
}
catch
{
return(Json("error"));
}
return(Json("success"));
}
