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