public object AddAsset(string AssetName, int AssetTypeID, string Image, string InvoiceDoc, int AssetValue, string PurchasedOn, string Status) { var DC = new DataClassesDataContext(); tblAsset AssetObj = new tblAsset(); AssetObj.AssetName = AssetName; AssetObj.AssetTypeID = AssetTypeID; AssetObj.Image = Image; AssetObj.InvoiceDoc = InvoiceDoc; AssetObj.AssetValue = AssetValue; AssetObj.PurchasedOn = Convert.ToDateTime(PurchasedOn); AssetObj.Status = Status; AssetObj.IsActive = true; DC.tblAssets.InsertOnSubmit(AssetObj); DC.SubmitChanges(); return(true); }
public object EditAsset(int AssetID, string AssetName, int AssetTypeID, string Image, string InvoiceDoc, int AssetValue, string PurchasedOn, string Status, bool IsActive) { var DC = new DataClassesDataContext(); tblAsset AssetObj = (from ob in DC.tblAssets where ob.AssetID == AssetID select ob).Single(); AssetObj.AssetName = AssetName; AssetObj.AssetTypeID = AssetTypeID; AssetObj.Image = Image; AssetObj.InvoiceDoc = InvoiceDoc; AssetObj.AssetValue = AssetValue; AssetObj.PurchasedOn = Convert.ToDateTime(PurchasedOn); AssetObj.Status = Status; AssetObj.IsActive = IsActive; DC.SubmitChanges(); return(true); }