예제 #1
0
        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);
        }
예제 #2
0
        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);
        }