public tblFleetAcntLink SelectAcntLink() { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblFleetAcntLink AcntLink = (from UP in db.tblFleetAcntLinks select UP).FirstOrDefault(); return(AcntLink); } }
public Int64 Update(Int64 VatPur, Int64 CSTPur, Int64 Vat, Int64 CST, Int64 Disc, Int64 Other, Int64 Cash, Int64 VATSale, Int64 CSTSale, Int64 TollAcc) { Int64 intValue = 0; Int32 intCompIdno = 1; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblFleetAcntLink objAcntLink = (from mast in db.tblFleetAcntLinks select mast).FirstOrDefault(); if (objAcntLink != null) { objAcntLink.VPur_Idno = VatPur; objAcntLink.CPur_Idno = CSTPur; objAcntLink.Vat_Idno = Vat; objAcntLink.CST_Idno = CST; objAcntLink.Disc_Idno = Disc; objAcntLink.Other_Idno = Other; objAcntLink.Cash_Idno = Cash; objAcntLink.VSale_Idno = VATSale; objAcntLink.CSale_Idno = CSTSale; objAcntLink.TollAcc_Idno = TollAcc; objAcntLink.Date_modified = System.DateTime.Now; { db.SaveChanges(); intValue = objAcntLink.AcntLink_Idno; } } } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }