private void dgrdBudget_SelectionChanged(object sender, EventArgs e) { if (dgrdBudget.SelectedRows.Count != 0) { SelectedBudgetID = Convert.ToInt32(dgrdBudget.SelectedRows[0].Cells[0].Value); _Budget = BudgetList.Find(a => a.BudgetId == SelectedBudgetID); if (_Budget != null) { ShowGUI(_Budget); LoadBudgetDetailsDataGrid(Budget.GetBudgetDetails(SelectedBudgetID, _Budget.BudgetYearId)); } } }
private void ShowGUI(Budget _Budget) { if (!string.IsNullOrEmpty(_Budget.BudgetName_Ara)) { txtArabicName.Text = _Budget.BudgetName_Ara; } if (!string.IsNullOrEmpty(_Budget.BudgetName_Eng)) { txtEnglishName.Text = _Budget.BudgetName_Eng; } cbxYear.SelectedValue = _Budget.BudgetYearId; chkIsDisabled.Checked = _Budget.IsDisable; }
private void frmBudgets_Save(object sender, ref bool _status) { Budget budget = new Budget(); GetDataFromGUI(); DataSaveResult saveResult = budget.Save(_Budget); if (saveResult.SaveStatus == false) { _status = false; } else { BudgetList = Budget.GetAllBugets(); LoadBudgetsDataGrid(BudgetList); } dgrdBudget.Enabled = true; dgrdBudget.Rows[SelectedRow].Selected = true; dgrdBudget_SelectionChanged(dgrdBudget, new EventArgs()); }
private void GetDataFromGUI() { _Budget = new Budget(); _Budget.BudgetId = SelectedBudgetID; _Budget.BudgetName_Ara = txtArabicName.Text; _Budget.BudgetName_Eng = txtEnglishName.Text; _Budget.BudgetYearId = Convert.ToInt32(cbxYear.SelectedValue); _Budget.IsDisable = chkIsDisabled.Checked; BudgetDetailsList = new List<Budget>(); foreach (DataGridViewRow row in dgrdBudgetDetails.Rows) { Budget Details = new Budget() { BudgetDtlId = Convert.ToInt32(row.Cells["clmBudgetDetailID"].Value), BudgetYear = Convert.ToInt32(row.Cells["clmBudgetYear"].Value), BudgetAccountId = Convert.ToString(row.Cells["clmBugetAccount"].Value), BudgetCostCenterId = Convert.ToInt32(row.Cells["clmBugetCostCenter"].Value), BudgetLocationId = Convert.ToString(row.Cells["clmBugetLocation"].Value), BdgtDepitAmount = Convert.ToDecimal(row.Cells["clmBdgtDepitAmount"].Value), BdgtCreditAmount = Convert.ToDecimal(row.Cells["clmBdgtCreditAmount"].Value), BdgttBalance = Convert.ToDecimal(row.Cells["clmBdgttBalance"].Value), BdgtFrom = Convert.ToDateTime(row.Cells["clmBdgtFrom"].Value), BdgtTo = Convert.ToDateTime(row.Cells["clmBdgtTo"].Value) }; BudgetDetailsList.Add(Details); } _Budget.BudgetDetails = BudgetDetailsList; }
private Acc_BudgetsDtl BuildDBRecordForDetails(Acc_BudgetsDtl _Acc_BudgetsDtl, Budget _Budget, Acc_Budgets _Acc_Budgets) { _Acc_BudgetsDtl.BudgetDtlId = _Budget.BudgetDtlId; _Acc_BudgetsDtl.BudgetId = _Acc_Budgets.BudgetId; _Acc_BudgetsDtl.BudgetYearId = _Acc_Budgets.BudgetYearId; _Acc_BudgetsDtl.BudgetYear = _Budget.BudgetYear; _Acc_BudgetsDtl.BudgetAccountId = _Budget.BudgetAccountId; _Acc_BudgetsDtl.BudgetCostCenterId = _Budget.BudgetCostCenterId; _Acc_BudgetsDtl.BudgetLocationId = _Budget.BudgetLocationId; _Acc_BudgetsDtl.BdgtDepitAmount = _Budget.BdgtDepitAmount; _Acc_BudgetsDtl.BdgtCreditAmount = _Budget.BdgtCreditAmount; _Acc_BudgetsDtl.BdgttBalance = _Budget.BdgttBalance; _Acc_BudgetsDtl.BdgtFrom = _Budget.BdgtFrom; _Acc_BudgetsDtl.BdgtTo = _Budget.BdgtTo; return _Acc_BudgetsDtl; }
private void frmBudgets_Delete(object sender, ref bool _status) { _Budget = new Budget(); if (SelectedBudgetID == -1) { _status = false; return; } DataDeleteResult result = _Budget.Delete(SelectedBudgetID); _status = result.DeleteStatus; if (result.DeleteStatus == false) { MessageBox.Show(result.ErrorMessage); } else { BudgetList = Budget.GetAllBugets(); LoadBudgetsDataGrid(BudgetList); dgrdBudget.Rows[0].Selected = true; } }
private Acc_Budgets BuildDBRecord(Acc_Budgets _Acc_Budgets, Budget _Budget) { if (_Budget.BudgetId != -1) { _Acc_Budgets.BudgetId = _Budget.BudgetId; } _Acc_Budgets.BudgetName_Ara = _Budget.BudgetName_Ara; _Acc_Budgets.BudgetName_Eng = _Budget.BudgetName_Eng; _Acc_Budgets.BudgetYearId = _Budget.BudgetYearId; _Acc_Budgets.IsDisable = _Budget.IsDisable; return _Acc_Budgets; }
public DataSaveResult Save(Budget _Budget) { try { Acc_Budgets Acc_Budgets; NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); Acc_Budgets = newAppsCnn.Acc_Budgets.Where(a => a.BudgetId == _Budget.BudgetId && a.BudgetYearId == _Budget.BudgetYearId).FirstOrDefault(); if (Acc_Budgets != null) { BuildDBRecord(Acc_Budgets, _Budget); } else { Acc_Budgets = new Acc_Budgets(); Acc_Budgets = BuildDBRecord(Acc_Budgets, _Budget); newAppsCnn.Acc_Budgets.Add(Acc_Budgets); } newAppsCnn.SaveChanges(); var BudgetDetails = newAppsCnn.Acc_BudgetsDtl.Where(a => a.BudgetDtlId == _Budget.BudgetDtlId && a.BudgetId == _Budget.BudgetId && a.BudgetYearId == _Budget.BudgetYearId).ToList(); if (BudgetDetails.Count !=0) { foreach (Acc_BudgetsDtl _Acc_BudgetsDtl in BudgetDetails) { foreach (Budget bdgt in _Budget.BudgetDetails) { if (_Acc_BudgetsDtl.BudgetDtlId == bdgt.BudgetDtlId) { BuildDBRecordForDetails(_Acc_BudgetsDtl, bdgt,Acc_Budgets); newAppsCnn.SaveChanges(); } } } } else { foreach (Budget bdgt in _Budget.BudgetDetails) { Acc_BudgetsDtl _Acc_BudgetsDtl = new Acc_BudgetsDtl(); _Acc_BudgetsDtl = BuildDBRecordForDetails(_Acc_BudgetsDtl, bdgt, Acc_Budgets); newAppsCnn.Acc_BudgetsDtl.Add(_Acc_BudgetsDtl); newAppsCnn.SaveChanges(); } } // Audit.AddDataAudit(Audit.AuditActionTypes.AddNew, "Acc_VouchersType", this); return new DataSaveResult() { SaveStatus = true }; } catch (Exception ex) { return new DataSaveResult() { SaveStatus = false }; } }
public static List<Budget> GetBudgetDetails(int BudgetID, int BudgetYearID) { List<Budget> BudgetDetailsList = new List<Budget>(); NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var BudgetDetail = from BudgetsDtl in newAppsCnn.Acc_BudgetsDtl join Acc in newAppsCnn.Acc_Accounts on BudgetsDtl.BudgetAccountId equals Acc.AccountID join CostCnter in newAppsCnn.Acc_CostCenter on BudgetsDtl.BudgetCostCenterId equals CostCnter.CostCenterId join loc in newAppsCnn.Gnrl_Loctions on BudgetsDtl.BudgetLocationId equals loc.LocationId where BudgetsDtl.BudgetId == BudgetID && BudgetsDtl.BudgetYearId == BudgetYearID select new { BudgetDtlId = BudgetsDtl.BudgetDtlId, BudgetYear = BudgetsDtl.BudgetYear, BudgetAccountId = BudgetsDtl.BudgetAccountId, AccountName_Ar = Acc.AccountName_Ar, AccountName_En = Acc.AccountName_Eng, BudgetCostCenterId = BudgetsDtl.BudgetCostCenterId, CostCenterName_Ara = CostCnter.CostCenterName_Ara, CostCenterName_Eng = CostCnter.CostCenterName_Eng, BudgetLocationId = BudgetsDtl.BudgetLocationId, LocationName_Ara = loc.LocationName_Ara, LocationName_Eng = loc.LocationName_Eng, BdgtDepitAmount = BudgetsDtl.BdgtDepitAmount, BdgtCreditAmount = BudgetsDtl.BdgtCreditAmount, BdgttBalance = BudgetsDtl.BdgttBalance, BdgtFrom = BudgetsDtl.BdgtFrom, BdgtTo = BudgetsDtl.BdgtTo }; foreach (var Detail in BudgetDetail) { Budget Budgt = new Budget(); Budgt.BudgetDtlId = Detail.BudgetDtlId; Budgt.BudgetYear = Detail.BudgetYear; Budgt.BudgetAccountId = Detail.BudgetAccountId; Budgt.AccountName_Ar = Detail.AccountName_Ar; Budgt.AccountName_Ar = Detail.AccountName_Ar; Budgt.BudgetCostCenterId = Detail.BudgetCostCenterId; Budgt.CostCenterName_Ara = Detail.CostCenterName_Ara; Budgt.CostCenterName_Eng = Detail.CostCenterName_Eng; Budgt.BudgetLocationId = Detail.BudgetLocationId; Budgt.LocationName_Ara = Detail.LocationName_Ara; Budgt.LocationName_Eng = Detail.LocationName_Eng; Budgt.BdgtDepitAmount = Detail.BdgtDepitAmount; Budgt.BdgtCreditAmount = Detail.BdgtCreditAmount; Budgt.BdgttBalance = Detail.BdgttBalance; Budgt.BdgtFrom = Detail.BdgtFrom; Budgt.BdgtTo = Detail.BdgtTo; BudgetDetailsList.Add(Budgt); } return BudgetDetailsList; }
public static List<Budget> GetAllLocations() { List<Budget> BudgetLocaionList = new List<Budget>(); NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var _BudgetLocation = from location in newAppsCnn.Gnrl_Loctions select location; foreach (var budgetlocation in _BudgetLocation) { Budget BugetLocaion = new Budget(); BugetLocaion.LocationName_Ara = budgetlocation.LocationName_Ara; BugetLocaion.LocationName_Eng = budgetlocation.LocationName_Eng; BugetLocaion.BudgetLocationId = budgetlocation.LocationId; BudgetLocaionList.Add(BugetLocaion); } return BudgetLocaionList; }
public static List<Budget> GetAllBugets() { List<Budget> BudgetTypeList = new List<Budget>(); NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var budgets = from bdgt in newAppsCnn.Acc_Budgets join financial in newAppsCnn.Gnrl_FinancialYear on bdgt.BudgetYearId equals financial.YearId select new { BudgetId = bdgt.BudgetId, BudgetName_Ara = bdgt.BudgetName_Ara, BudgetName_Eng = bdgt.BudgetName_Eng, BudgetYearId = bdgt.BudgetYearId, IsDisable = bdgt.IsDisable, YearName = financial.YearName }; foreach (var Budgettype in budgets) { Budget BudgetType = new Budget(); BudgetType.BudgetId = Budgettype.BudgetId; BudgetType.BudgetName_Ara = Budgettype.BudgetName_Ara; BudgetType.BudgetName_Eng = Budgettype.BudgetName_Eng; BudgetType.BudgetYearId = Budgettype.BudgetYearId; BudgetType.IsDisable = Budgettype.IsDisable; BudgetType.BudgetYearName = Budgettype.YearName; BudgetTypeList.Add(BudgetType); } return BudgetTypeList; }