public static Reconcile FindByReconcileID(string _VaidationID)
{
NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);
var dbReconciles = from u in newAppsCnn.Acc_Reconcilation where u.ReconcileAccountId == _VaidationID select u;
if (dbReconciles.Count() > 0)
{
Acc_Reconcilation dbAcc_Reconcilation = dbReconciles.First();
Reconcile reconcile = new Reconcile();
reconcile.FromDbReconcilation(dbAcc_Reconcilation);
return reconcile;
}
else
{
Reconcile reconcile = new Reconcile();
var clsAccount = Account.FindByAccountID(_VaidationID);
reconcile.ReconcileAccountId = _VaidationID;
reconcile.ReconcileAccountName = clsAccount.Name;
reconcile.ReconcileAccountName_Ar = clsAccount.AccountName_Eng;
reconcile.ReconcileAccountName_En = clsAccount.AccountName_Ar;
reconcile.LoadVoucher();
return reconcile;
}
}
