예제 #1
0
        public List <LoanLedger> UpdateLoanLedger(string RefNum, double LoanAmt)
        {
            try
            {
                // var resp = (from a in uvDb.LoanLedgers where a.RefNumber == RefNum select a).ToList();
                var resp        = SelectLoanLedger(RefNum, LoanAmt);
                var Firstrecord = resp.First();
                if (Firstrecord != null)
                {
                    Firstrecord.Credit         = LoanAmt;
                    Firstrecord.PaymentFlag_FK = 1;
                    uvDb.SaveChanges();
                }

                var query = "UPDATE LoanLedger SET PaymentFlag_FK = 2 WHERE RefNumber = '" + RefNum + "' AND Credit = 0";
                using (var context = new UvlotEntities())
                {
                    context.Database.ExecuteSqlCommand(query);
                }


                if (resp == null)
                {
                    return(null);
                }
                return(resp.ToList());
            }
            catch (Exception ex)
            {
                WebLog.Log(ex.Message.ToString());
                return(null);
            }
        }
예제 #2
0
 public int UpdateLoanLedgers(string RefNum)
 {
     try
     {
         var original = (from a in uvDb.LoansLedgers where a.RefNumber == RefNum select a).FirstOrDefault();
         if (original != null)
         {
             var query = "UPDATE LoansLedger SET IsVisible = 0 WHERE RefNumber = '" + RefNum + "' AND Credit = 0";
             using (var context = new UvlotEntities())
             {
                 context.Database.ExecuteSqlCommand(query);
             }
             //  original.IsVisible = 0;
             // uvDb.SaveChanges();
         }
         return(original.ID);
     }
     catch (Exception ex)
     {
         WebLog.Log(ex.Message.ToString());
         return(0);
     }
 }