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