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; } }