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