Example #1
0
 public tblFleetAcntLink SelectAcntLink()
 {
     using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
     {
         tblFleetAcntLink AcntLink = (from UP in db.tblFleetAcntLinks select UP).FirstOrDefault();
         return(AcntLink);
     }
 }
Example #2
0
        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);
        }