コード例 #1
0
ファイル: Reconcile.cs プロジェクト: sherif-hfm/ItsBackOffice
 public DataSaveResult Save()
 {
     Acc_Reconcilation dbReconcilation;
     try
     {
         NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);
         var dbReconcilations = from u in newAppsCnn.Acc_Reconcilation where u.ReconcileId == this.ReconcileId select u;
         if (dbReconcilations.Count() > 0)
         {
             dbReconcilation = dbReconcilations.First();
             this.ToDbReconcilation(dbReconcilation);
             List<Acc_ReconcilationDtl> DltLst = (from u in newAppsCnn.Acc_ReconcilationDtl where u.ReconcileId == this.ReconcileId select u).ToList();
             foreach (var itm in DltLst)
             {
                 newAppsCnn.Acc_ReconcilationDtl.Remove(itm);
                 newAppsCnn.SaveChanges();
             }
             foreach (var itm in this.ReconcilationDtlLst)
             {
                 Acc_ReconcilationDtl Obj = new Acc_ReconcilationDtl()
                 {
                     ReconcileId = dbReconcilation.ReconcileId,
                     VoucherId = itm.VoucherId,
                     VoucherNo = (from u in newAppsCnn.Acc_Voucher where u.VoucherId == itm.VoucherId select u).ToList().FirstOrDefault().VoucherRefno,
                     ReconcileDtlid = (from u in newAppsCnn.Acc_ReconcilationDtl select u.ReconcileDtlid).ToList().LastOrDefault() == null ? 1 : (1 + (from u in newAppsCnn.Acc_ReconcilationDtl select u.ReconcileDtlid).ToList().LastOrDefault())
                 };
                 newAppsCnn.Acc_ReconcilationDtl.Add(Obj);
                 newAppsCnn.SaveChanges();
             }
         }
         else
         {
             dbReconcilation = new Acc_Reconcilation();
             this.ToDbReconcilation(dbReconcilation);
             newAppsCnn.Acc_Reconcilation.Add(dbReconcilation);
             newAppsCnn.SaveChanges();
             foreach (var itm in this.ReconcilationDtlLst)
             {
                 Acc_ReconcilationDtl Obj = new Acc_ReconcilationDtl() {
                     ReconcileId = dbReconcilation.ReconcileId,
                     VoucherId=itm.VoucherId,
                     VoucherNo = (from u in newAppsCnn.Acc_Voucher where u.VoucherId == itm.VoucherId select u).ToList().FirstOrDefault().VoucherRefno,
                     ReconcileDtlid = (from u in newAppsCnn.Acc_ReconcilationDtl select u.ReconcileDtlid).ToList().LastOrDefault() == null ? 1 : (from u in newAppsCnn.Acc_ReconcilationDtl select u.ReconcileDtlid).ToList().LastOrDefault()
                 };
                 newAppsCnn.Acc_ReconcilationDtl.Add(Obj);
                 newAppsCnn.SaveChanges();
             }
         }
         newAppsCnn.SaveChanges();
         Audit.AddDataAudit(Audit.AuditActionTypes.AddNew, "Acc_Reconcilation", this);
         this.FromDbReconcilation(dbReconcilation);
         return new DataSaveResult() { SaveStatus = true };
     }
     catch (Exception ex)
     {
         return new DataSaveResult() { SaveStatus = false, ErrorMessage = ex.Message };
     }
 }
コード例 #2
0
ファイル: Reconcile.cs プロジェクト: sherif-hfm/ItsBackOffice
 public void ToDbReconcilation(Acc_Reconcilation _dbReconcilation)
 {
     NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);
     var RId = 1 + ((from u in newAppsCnn.Acc_Reconcilation select u.ReconcileId).ToList().LastOrDefault() == null ? 1 : (int.Parse((from u in newAppsCnn.Acc_Reconcilation select u.ReconcileId).ToList().LastOrDefault())));
     _dbReconcilation.ReconcileId = this.ReconcileId ?? RId.ToString();
     _dbReconcilation.ReconcileAccountId = this.ReconcileAccountId;
     _dbReconcilation.ReconcileYear = AppInfo.CurrentYear.YearId;
     _dbReconcilation.CurrentStatemantAmount = this.CurrentStatemantAmount;
     _dbReconcilation.CurrentStatementDate = this.CurrentStatementDate;
     _dbReconcilation.ReconciledLastBal = this.ReconciledLastBal;
     _dbReconcilation.ReconciledLastDate = this.ReconciledLastDate;
     _dbReconcilation.ReconcilationValue = this.ReconcilationValue;
     _dbReconcilation.AccountBalance = this.AccountBalance;
     _dbReconcilation.DiffreneceInBook = this.DiffreneceInBook;
 }
コード例 #3
0
ファイル: Reconcile.cs プロジェクト: sherif-hfm/ItsBackOffice
 public void FromDbReconcilation(Acc_Reconcilation _dbReconcilation)
 {
     this.ReconcileId = _dbReconcilation.ReconcileId;
     this.ReconcileAccountId = _dbReconcilation.ReconcileAccountId;
     this.ReconcileYear = _dbReconcilation.ReconcileYear;
     this.CurrentStatemantAmount = _dbReconcilation.CurrentStatemantAmount;
     this.CurrentStatementDate = _dbReconcilation.CurrentStatementDate;
     this.ReconciledLastBal = _dbReconcilation.ReconciledLastBal;
     this.ReconciledLastDate = _dbReconcilation.ReconciledLastDate;
     this.ReconcilationValue = _dbReconcilation.ReconcilationValue;
     this.AccountBalance = _dbReconcilation.AccountBalance;
     this.DiffreneceInBook = _dbReconcilation.DiffreneceInBook;
     LoadVoucher();
 }