private DataSet LoadGridData()
{
IBudgetConfigDetail objBudgetConfigList = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
dsBudgetConfigList = objBudgetConfigList.GetBudgetConfigDetails(Convert.ToInt32(GblIQCare.objHashtbl["DonorID"]), Convert.ToInt32(GblIQCare.objHashtbl["ProgramID"]), Convert.ToInt32(GblIQCare.objHashtbl["ProgramYearID"]), CONST_CODEID);
return(dsBudgetConfigList);
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
DialogResult dialogResult;
dialogResult = IQCareWindowMsgBox.ShowWindow("Are you sure you would like to delete this budget?", "?", "", this);
if (dialogResult == DialogResult.Yes)
{
foreach (DataGridViewRow dgvr in dgwBudgetConfig.Rows)
{
if (dgvr.Cells["DeleteFlag"].Value != null)
{
IBudgetConfigDetail objItemlist = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
int retrows = objItemlist.DeleteBudgetConfigDetails(Convert.ToInt32(dgvr.Cells["BudgetConfigID"].Value), Convert.ToInt32(dgvr.Cells["DeleteFlag"].Value), GblIQCare.AppUserId);
}
}
IQCareWindowMsgBox.ShowWindow("Budget Configuration sucessfully Deleted.", "", "", this);
Init_Form();
}
}
catch (Exception err)
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = err.Message.ToString();
IQCareWindowMsgBox.ShowWindowConfirm("#C1", theBuilder, this);
}
}
private void ddlDonorPayer_SelectedIndexChanged(object sender, EventArgs e)
{
BindFunctions objBindControls = new BindFunctions();
int donorVal = 0;
if (ddlDonorPayer.SelectedValue != null)
{
if (ddlDonorPayer.SelectedIndex != 0)
{
donorVal = Convert.ToInt32(ddlDonorPayer.SelectedValue);
}
}
IBudgetConfigDetail objProgramlistByDonor = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
dsProgramListByDonor = objProgramlistByDonor.GetProgramListByDonor(donorVal);
ddlProgram.DataSource = null;
ddlProgram.Items.Clear();
objBindControls.Win_BindCombo(ddlProgram, dsProgramListByDonor.Tables[1], "ProgramName", "Id");
if (ddlDonorPayer.SelectedIndex == 0)
{
ddlProgram.DataSource = null;
ddlProgram.Items.Clear();
objBindControls.Win_BindCombo(ddlProgram, dsProgramList.Tables[0], "ProgramName", "Id");
}
}
private DataSet LoadGridData()
{
IBudgetConfigDetail objBudgetConfigList = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
DataSet dsBudgetConfigList = objBudgetConfigList.GetBudgetConfigTotal(CONST_CODEID);
return(dsBudgetConfigList);
}
private void Init_Form()
{
IBudgetConfigDetail objCostAllocationlist = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
dsCostAllocationList = objCostAllocationlist.GetCostAllocation(CONST_CODEID);
DataRow row = dsCostAllocationList.Tables[0].NewRow();
row["Name"] = "Total Budget";
row["Id"] = "0";
dsCostAllocationList.Tables[0].Rows.InsertAt(row, 0);
BindDropdown();
dsGetDefaultDate = objCostAllocationlist.GetHolisticBudgetViewDefaultYear();
if ((dsGetDefaultDate.Tables[0].Rows[0]["ProgramYear"].ToString() != "") || (dsGetDefaultDate.Tables[0].Rows[0]["ProgramYear"] != DBNull.Value))
{
ddlCalendarYear.SelectedValue = dsGetDefaultDate.Tables[0].Rows[0]["ProgramYear"].ToString();
}
else
{
ddlCalendarYear.SelectedValue = DateTime.Now.Year.ToString();
}
//SelectedComboVal();
}
private DataSet LoadGridData(int costCategoryVal, int calendarYearVal)
{
IBudgetConfigDetail objHolisticBudgetViewList = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
dsHolisticBudgetViewList = objHolisticBudgetViewList.GetHolisticBudgetView(costCategoryVal, calendarYearVal);
return(dsHolisticBudgetViewList);
}
private void Init_Form()
{
string XmlFile = GblIQCare.GetXMLPath() + "Currency.xml";
DataSet theDSCurrencyXML = new DataSet();
theDSCurrencyXML.ReadXml(XmlFile);
IBudgetConfigDetail objProgramlistByDonor = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
dsProgramListByDonor = objProgramlistByDonor.GetProgramListByDonor(Convert.ToInt32(GblIQCare.objHashtbl["DonorID"]));
//if (dsProgramListByDonor.Tables[0].Select("Id = '" + GblIQCare.objHashtbl["ProgramID"] + "'").SingleOrDefault() != null)
if (dsProgramListByDonor.Tables[0].Select("Id = '" + GblIQCare.objHashtbl["ProgramID"] + "'").Length > 0)
{
//DataRow []dr=dsProgramListByDonor.Tables[0].Select("Id = '" + GblIQCare.objHashtbl["ProgramID"] + "'");
//foreach(DataRow drdt in dr)
//{
//}
FundEndDt = Convert.ToDateTime(dsProgramListByDonor.Tables[0].Select("Id = '" + GblIQCare.objHashtbl["ProgramID"] + "' and FundingEndDate=max(FundingEndDate)").SingleOrDefault().ItemArray[10]);
FundEndDt = Convert.ToDateTime(FundEndDt.Month + "-" + System.DateTime.DaysInMonth(FundEndDt.Year, FundEndDt.Month) + "-" + FundEndDt.Year);
int month = Convert.ToInt32(dsProgramListByDonor.Tables[0].Select("Id = '" + GblIQCare.objHashtbl["ProgramID"] + "' and FundingStartDate=min(FundingStartDate)").SingleOrDefault().ItemArray[4]);
ProgramStartDt = Convert.ToDateTime(month + "-" + System.DateTime.DaysInMonth(Convert.ToInt32(GblIQCare.objHashtbl["ProgramYear"]), month) + "-" + GblIQCare.objHashtbl["ProgramYear"]);
}
string CurrencyCode = theDSCurrencyXML.Tables[0].Select("Id = '" + GblIQCare.AppCountryId + "'").SingleOrDefault().ItemArray[1].ToString().Split('(').LastOrDefault().Replace(")", "");
lblCurrency.Text = "Currency: " + CurrencyCode;
txtDonor.Text = GblIQCare.objHashtbl["DonorName"].ToString();
txtProgram.Text = GblIQCare.objHashtbl["ProgramName"].ToString();
txtProgramYear.Text = GblIQCare.objHashtbl["ProgramYear"].ToString();
LoadGrid(LoadGridData().Tables[1]);
}
/// <summary>
/// load the data for the given year form the DataAccess class
/// </summary>
/// <param name="year"></param>
/// <returns></returns>
private DataTable LoadData(int year)
{
IBudgetConfigDetail ObjDataAccess = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
DataTable dtVisits = ObjDataAccess.GetPatientVisitConfigForYear(year, GblIQCare.AppUserId);
dtVisits.AcceptChanges(); // helps detecting changes later
return(dtVisits);
}
private void Init_Form()
{
IBudgetConfigDetail objDonorlist = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
dsDonorList = objDonorlist.GetDonorList();
IBudgetConfigDetail objProgramlist = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
dsProgramList = objProgramlist.GetProgramList();
LoadGrid(LoadGridData().Tables[0]);
}
/// <summary>
/// save the currently selected data
/// only save the rows that have changed
/// inform the user about the updates
///
/// </summary>
private void Save()
{
// get all the bound data
DataTable dt = dgwVisits.DataSource as DataTable;
// we only want to send the updated rows to the DB
DataTable changes = dt.GetChanges();
if (changes != null)
{
// save to the DB
IBudgetConfigDetail ObjDataAccess = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
ObjDataAccess.SavePatientVisitConfigForYear(changes, currentYear, GblIQCare.AppUserId);
}
// inform the user and re-load the data
IQCareWindowMsgBox.ShowWindow("SCMSave", this);
LoadData(currentYear);
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
DTItemlist = (DataTable)dgwBudgetConfig.DataSource;
DataSet SaveBudgetDataSet = new DataSet();
SaveBudgetDataSet.Tables.Add(dsBudgetConfigList.Tables[0].Copy());
SaveBudgetDataSet.Tables.Add(DTItemlist.Copy());
IBudgetConfigDetail objItemlist = (IBudgetConfigDetail)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBudgetConfigDetail,BusinessProcess.SCM");
int retrows = objItemlist.SaveBudgetConfigDetails(DTItemlist, dsBudgetConfigList.Tables[0], GblIQCare.AppUserId, GblIQCare.objHashtbl);
IQCareWindowMsgBox.ShowWindow("ProgramSave", this);
//Init_Form();
}
catch (Exception err)
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = err.Message.ToString();
IQCareWindowMsgBox.ShowWindowConfirm("#C1", theBuilder, this);
}
}
