public static List<Group> GetAllGroups() { List<Group> result = new List<Group>(); NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbGroups = from g in newAppsCnn.Sec_Groups select g; foreach (var dbGroup in dbGroups) { Group group = new Group(); group.FromDbGroup(dbGroup); result.Add(group); } return result; }
public static List<Accounttype> GetAllAccounttype() { List<Accounttype> result = new List<Accounttype>(); NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbAccounttypes = from g in newAppsCnn.Acc_Accountype select g; foreach (var dbAccounttype in dbAccounttypes) { Accounttype accounttype = new Accounttype(); accounttype.FromDbAccounttype(dbAccounttype); result.Add(accounttype); } return result; }
public static List<AccountCategory> GetAllAccountCategory() { List<AccountCategory> result = new List<AccountCategory>(); NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbAccountCategorys = from g in newAppsCnn.Acc_AccountCategory select g; foreach (var dbAccountCategory in dbAccountCategorys) { AccountCategory accountcategory = new AccountCategory(); accountcategory.FromDbAccountCategory(dbAccountCategory); result.Add(accountcategory); } return result; }
public static List<FormFunction> GetFormFunctions() { List<FormFunction> result = new List<FormFunction>(); NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbFormFunctions = from f in newAppsCnn.Sec_FormFunctions select f; foreach (var dbFormFunction in dbFormFunctions) { FormFunction formFunction = new FormFunction(); formFunction.FromDbFormFunction(dbFormFunction); result.Add(formFunction); } return result; }
public static AccountCategory FindByAccountCategoryID(int _VaidationID) { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbAccountCategorys = from u in newAppsCnn.Acc_AccountCategory where u.CategoryId == _VaidationID select u; if (dbAccountCategorys.Count() > 0) { Acc_AccountCategory dbAccountCategory = dbAccountCategorys.First(); AccountCategory accountcategory = new AccountCategory(); accountcategory.FromDbAccountCategory(dbAccountCategory); accountcategory.IsNew = false; return accountcategory; } else return null; }
public static Accounttype FindByAccounttypeID(int _VaidationID) { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbAccounttypes = from u in newAppsCnn.Acc_Accountype where u.TypeID == _VaidationID select u; if (dbAccounttypes.Count() > 0) { Acc_Accountype dbAccounttype = dbAccounttypes.First(); Accounttype accounttype = new Accounttype(); accounttype.FromDbAccounttype(dbAccounttype); accounttype.IsNew = false; return accounttype; } else return null; }
public static CostCenter FindByCostCenterId(int? _VaidationID) { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbCostCenters = from u in newAppsCnn.Acc_CostCenter where u.CostCenterId == _VaidationID select u; if (dbCostCenters.Count() > 0) { Acc_CostCenter dbCostCenter = dbCostCenters.First(); CostCenter account = new CostCenter(); account.FromDbCostCenter(dbCostCenter); account.IsNew = false; account.IsCopy = false; return account; } else return null; }
public static List<ChequeBook> GetAllAccounts() { List<ChequeBook> ChequeBookList = new List<ChequeBook>(); NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var _BankAccounts = from Cheque in newAppsCnn.Acc_Accounts.Where(a => a.AccountCategoryId == 1) select Cheque; foreach (var account in _BankAccounts) { ChequeBook bankaccount = new ChequeBook(); bankaccount.AccountName_Ar = account.AccountName_Ar; bankaccount.AccountName_En = account.AccountName_Eng; bankaccount.AccountId = account.AccountID; ChequeBookList.Add(bankaccount); } return ChequeBookList; }
public static AssetCatogry FindByAstCatId(int? _VaidationID) { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbAssetCatogrys = from u in newAppsCnn.Ast_AssetCatogry where u.AstCatId == _VaidationID select u; if (dbAssetCatogrys.Count() > 0) { Ast_AssetCatogry dbAssetCatogry = dbAssetCatogrys.First(); AssetCatogry account = new AssetCatogry(); account.FromDbAssetCatogry(dbAssetCatogry); account.IsNew = false; account.IsCopy = false; return account; } else return null; }
public static List<FinancialYear> GetAllFinancialYears() { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); List<FinancialYear> FinancialYearsList = new List<FinancialYear>(); var financialyear = newAppsCnn.Gnrl_FinancialYear.ToList(); foreach (var financial in financialyear) { FinancialYear year = new FinancialYear(); year.YearID = financial.YearId; year.YearName = financial.YearName; year.YearBegin = financial.YearBegin; year.YearEnd = financial.YearEnd; year.IsDefaultYear = financial.IsDefaultYear; year.IsClosedYear = financial.IsClosedYear; year.prefix = financial.prefix; FinancialYearsList.Add(year); } return FinancialYearsList; }
public static User CheckUser(string _userName, string _password) { try { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbUsers = from u in newAppsCnn.Sec_Users where u.UserLogin == _userName && u.Password == _password select u; if (dbUsers.Count() > 0) { Sec_Users dbUser = dbUsers.First(); User user = new User(); user.FromDbUser(dbUser); user.LoadUserMenu(dbUser); return user; } else return null; } catch (Exception ex) { throw ex; } }
private void LoadUserMenuForAdminUser(Sec_Users _dbUser) { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbMenuItems = from m in newAppsCnn.Sec_MainMenu select m; foreach (var dbMenuItem in dbMenuItems) { MenuItem menuItem = new MenuItem(); menuItem.FromDbMenuItem(dbMenuItem); this.UserMenuItems.Add(menuItem); } }
public static List<Account> GetAllAccountTree() { List<Account> result = new List<Account>(); NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbAccounts = from g in newAppsCnn.Acc_Accounts where g.AccountID != null || g.AccountID != "" select g; foreach (var dbAccount in dbAccounts) { Account account = new Account(); account.FromDbAccount(dbAccount); result.Add(account); } return result; }
public DataSaveResult Save() { Sec_Users dbUser; try { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbUsers = from u in newAppsCnn.Sec_Users where u.UserID == this.UserID select u; if (dbUsers.Count() > 0) { dbUser = dbUsers.First(); this.ToDbUser(dbUser); this.SaveDbUserGroups(dbUser, newAppsCnn); } else { dbUser = new Sec_Users(); this.ToDbUser(dbUser); this.SaveDbUserGroups(dbUser, newAppsCnn); newAppsCnn.Sec_Users.Add(dbUser); } newAppsCnn.SaveChanges(); Audit.AddDataAudit(Audit.AuditActionTypes.AddNew, "Sec_Users", this); this.FromDbUser(dbUser); return new DataSaveResult() { SaveStatus = true }; } catch (Exception ex) { return new DataSaveResult() { SaveStatus = false, ErrorMessage = ex.Message }; } }
public void SaveDbUserGroups(Sec_Users _dbUser, NewAppsCnn newAppsCnn) { // Add New User Groups foreach (var group in this.Groups) { var dbUserGroups = _dbUser.Sec_Groups.Where(g => g.GroupID == group.GroupID); if (dbUserGroups.Count() == 0) { var dbGroup = newAppsCnn.Sec_Groups.First(g => g.GroupID == group.GroupID); _dbUser.Sec_Groups.Add(dbGroup); } } // Delete User Groups foreach (var dbGroup in _dbUser.Sec_Groups.ToList()) { var group = this.Groups.Find(g => g.GroupID == dbGroup.GroupID); if (group == null) _dbUser.Sec_Groups.Remove(dbGroup); } }
public static User GetPrev(User _user) { if (_user == null) return GetFirst(); NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbUsers = from u in newAppsCnn.Sec_Users where u.UserID < _user.UserID orderby u.UserID descending select u; if (dbUsers.Count() > 0) { var dbUser = dbUsers.FirstOrDefault(); User user = new User(); user.FromDbUser(dbUser); user.LoadDbUserGroups(dbUser); return user; } else return null; }
public DataDeleteResult Delete() { Sec_Users dbUser; try { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbUsers = from u in newAppsCnn.Sec_Users where u.UserID == this.UserID select u; if (dbUsers.Count() > 0) { dbUser = dbUsers.First(); newAppsCnn.Sec_Users.Remove(dbUser); newAppsCnn.SaveChanges(); } return new DataDeleteResult() { DeleteStatus = true }; } catch (Exception ex) { return new DataDeleteResult() { DeleteStatus = false, ErrorMessage = ex.Message }; } }
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; }
public NewAppsCnn(string _connectionString) { Database.Connection.ConnectionString = _connectionString; NewAppsCnn newAppsCnn = new NewAppsCnn(); }
public DataDeleteResult Delete() { this.IsCopy = false; Acc_CostCenter dbCostCenter; try { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbCostCenters = from u in newAppsCnn.Acc_CostCenter where u.CostCenterId == this.CostCenterId select u; if (dbCostCenters.Count() > 0) { dbCostCenter = dbCostCenters.First(); var dbAccountChilds = from u in newAppsCnn.Acc_CostCenter where u.ParentId == this.CostCenterId select u; if (dbAccountChilds.Count() == 0 && DontHaveTransaction())//Transaction Condition { newAppsCnn.Acc_CostCenter.Remove(dbCostCenter); newAppsCnn.SaveChanges(); } else { return new DataDeleteResult() { DeleteStatus = false, ErrorMessage = "This Item has childs" }; } } return new DataDeleteResult() { DeleteStatus = true }; } catch (Exception ex) { return new DataDeleteResult() { DeleteStatus = false, ErrorMessage = ex.Message }; } }
public static Account FindByAccountID(string _VaidationID) { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbAccounts = from u in newAppsCnn.Acc_Accounts where u.AccountID == _VaidationID select u; if (dbAccounts.Count() > 0) { Acc_Accounts dbAccount = dbAccounts.First(); Account account = new Account(); account.FromDbAccount(dbAccount); account.IsNew = false; account.IsCopy = false; return account; } else return null; }
public DataDeleteResult Delete() { this.IsCopy = false; Ast_AssetCatogry dbAssetCatogry; try { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbAssetCatogrys = from u in newAppsCnn.Ast_AssetCatogry where u.AstCatId == this.AstCatId select u; if (dbAssetCatogrys.Count() > 0) { dbAssetCatogry = dbAssetCatogrys.First(); newAppsCnn.Ast_AssetCatogry.Remove(dbAssetCatogry); newAppsCnn.SaveChanges(); } return new DataDeleteResult() { DeleteStatus = true }; } catch (Exception ex) { return new DataDeleteResult() { DeleteStatus = false, ErrorMessage = ex.Message }; } }
public DataSaveResult Save() { this.IsCopy = false; Ast_AssetCatogry dbAssetCatogry; try { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbAssetCatogrys = from u in newAppsCnn.Ast_AssetCatogry where u.AstCatId == this.AstCatId select u; if (dbAssetCatogrys.Count() > 0) { dbAssetCatogry = dbAssetCatogrys.First(); this.ToDbAssetCatogry(dbAssetCatogry); } else { dbAssetCatogry = new Ast_AssetCatogry(); this.ToDbAssetCatogry(dbAssetCatogry); newAppsCnn.Ast_AssetCatogry.Add(dbAssetCatogry); } newAppsCnn.SaveChanges(); Audit.AddDataAudit(Audit.AuditActionTypes.AddNew, "Ast_AssetCatogry", this); this.FromDbAssetCatogry(dbAssetCatogry); return new DataSaveResult() { SaveStatus = true }; } catch (Exception ex) { return new DataSaveResult() { SaveStatus = false,ErrorMessage=ex.Message }; } }
public static string getNewId(string ParentId, bool IsSubAccount) { string AccountId = ""; NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbAccounts = from g in newAppsCnn.Acc_Accounts where g.AccountID != null || g.AccountID != "" select g; if (ParentId == null || ParentId == "") { var PChild = (from ac in dbAccounts where ac.ParentId == "" || ac.ParentId == null select ac).ToList(); AccountId = string.Format("{0}", PChild.Count + 1); } else if (IsSubAccount) { char[] array = new char[6]; var PrntVal = FindByAccountID(ParentId); var PChild = (from ac in dbAccounts where ac.ParentId == ParentId && ac.IsSubAccount == IsSubAccount select ac).ToList(); int ArrCount = 0; string NwId = (PChild.Count + 1).ToString(); for (int idx = array.Length - 1; idx > -1; idx--) { if (ArrCount < NwId.Length) { array[idx] = NwId[ArrCount]; ArrCount++; } else { array[idx] = '0'; } } AccountId = string.Format("{0}{1}", ParentId, (new string(array))); } else { char[] array = new char[2]; var PrntVal = FindByAccountID(ParentId); var PChild = (from ac in dbAccounts where ac.ParentId == ParentId select ac).ToList(); int ArrCount = 0; string NwId=(PChild.Count + 1).ToString(); for (int idx = array.Length - 1; idx > -1; idx--) { if (ArrCount < NwId.Length) { array[idx] = NwId[ArrCount]; ArrCount++; } else { array[idx] = '0'; } } AccountId = string.Format("{0}{1}", ParentId, (new string(array))); } return AccountId; }
public static List<AssetCatogry> GetAllAssetCatogryTree() { List<AssetCatogry> result = new List<AssetCatogry>(); NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbAssetCatogrys = from g in newAppsCnn.Ast_AssetCatogry select g; foreach (var dbAssetCatogry in dbAssetCatogrys) { AssetCatogry account = new AssetCatogry(); account.FromDbAssetCatogry(dbAssetCatogry); result.Add(account); } return result; }
public DataSaveResult Save() { this.IsCopy = false; Acc_Accounts dbAccount; try { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbAccounts = from u in newAppsCnn.Acc_Accounts where u.AccountID == this.AccountID select u; if (dbAccounts.Count() > 0) { dbAccount = dbAccounts.First(); if (this.AccountTypeId != dbAccount.AccountTypeId && (dbAccount.ParentId==null||dbAccount.ParentId=="")) { var dbAccountChilds = from u in newAppsCnn.Acc_Accounts where u.ParentId == this.AccountID select u; foreach (var itm in dbAccountChilds) { itm.AccountTypeId = this.AccountTypeId; } } this.ToDbAccount(dbAccount); dbAccount.AccountLevel = getNodeLevel(0, dbAccount.ParentId); } else { dbAccount = new Acc_Accounts(); this.ToDbAccount(dbAccount); dbAccount.AccountLevel = getNodeLevel(0, dbAccount.ParentId); newAppsCnn.Acc_Accounts.Add(dbAccount); } newAppsCnn.SaveChanges(); Audit.AddDataAudit(Audit.AuditActionTypes.AddNew, "Acc_Accounts", this); this.FromDbAccount(dbAccount); return new DataSaveResult() { SaveStatus = true }; } catch (Exception ex) { return new DataSaveResult() { SaveStatus = false,ErrorMessage=ex.Message }; } }
public DataSaveResult Save() { this.IsCopy = false; Acc_CostCenter dbCostCenter; try { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbCostCenters = from u in newAppsCnn.Acc_CostCenter where u.CostCenterId == this.CostCenterId select u; if (dbCostCenters.Count() > 0) { dbCostCenter = dbCostCenters.First(); this.ToDbCostCenter(dbCostCenter); } else { dbCostCenter = new Acc_CostCenter(); this.ToDbCostCenter(dbCostCenter); newAppsCnn.Acc_CostCenter.Add(dbCostCenter); } newAppsCnn.SaveChanges(); Audit.AddDataAudit(Audit.AuditActionTypes.AddNew, "Acc_CostCenter", this); this.FromDbCostCenter(dbCostCenter); return new DataSaveResult() { SaveStatus = true}; } catch (Exception ex) { return new DataSaveResult() { SaveStatus = false ,ErrorMessage= ex.Message }; } }
public static User FindByUserID(int _userID) { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbUsers = from u in newAppsCnn.Sec_Users where u.UserID == _userID select u; if (dbUsers.Count() > 0) { Sec_Users dbUser = dbUsers.First(); User user = new User(); user.FromDbUser(dbUser); user.LoadDbUserGroups(dbUser); return user; } else return null; }
public static List<CostCenter> GetAllCmbCostCenter() { List<CostCenter> result = new List<CostCenter>(); NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbCostCenters = from g in newAppsCnn.Acc_CostCenter where g.IsDisable==false select g; foreach (var dbCostCenter in dbCostCenters) { CostCenter account = new CostCenter(); account.FromDbCostCenter(dbCostCenter); result.Add(account); } return result; }
public static User GetFirst() { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbUser = newAppsCnn.Sec_Users.FirstOrDefault(); if (dbUser != null) { User user = new User(); user.FromDbUser(dbUser); user.LoadDbUserGroups(dbUser); return user; } else return null; }