private void MonthlyDeductionSummaryRPTFRM_Load(object sender, EventArgs e) { cmbYear.DataSource = myYear.ListAllVisibleYears(); cmbYear.DisplayMember = "YearCode"; cmbYear.ValueMember = "YearCode"; cmbYear.Text = DateTime.Now.Year.ToString(); cmbYear_SelectedIndexChanged(null, null); cmbSupplier.DataSource = mySupplier.ListActiveSuppliers(); cmbSupplier.DisplayMember = "SupplierName"; cmbSupplier.ValueMember = "SupplierCode"; cmbDeductionGroup.SelectedIndexChanged -= new EventHandler(cmbDeductionGroup_SelectedIndexChanged); cmbDeductionGroup.DataSource = DeductGroupMaster.LoadComboboxGroupCode(); cmbDeductionGroup.DisplayMember = "GroupName"; cmbDeductionGroup.ValueMember = "GroupCode"; cmbDeductionGroup.SelectedIndexChanged += new EventHandler(cmbDeductionGroup_SelectedIndexChanged); cmbRoute.DataSource = myRoute.ListRouteDetails(); cmbRoute.DisplayMember = "RouteName"; cmbRoute.ValueMember = "RouteCode"; cmbSupplier.Enabled = false; cmbDeductionGroup.Enabled = false; cmbDeductionCode.Enabled = false; cmbRoute.Enabled = false; cmbDeductionGroup_SelectedIndexChanged(null, null); }
private void DailyAnalysisReport_Load(object sender, EventArgs e) { cmbSupplier.DataSource = mySupplier.ListActiveSuppliers(); cmbSupplier.DisplayMember = "SupplierName"; cmbSupplier.ValueMember = "SupplierCode"; cmbSupplier.Enabled = false; cmbRoute.DataSource = myRoute.ListRouteDetails(); cmbRoute.DisplayMember = "RouteName"; cmbRoute.ValueMember = "RouteCode"; }
private void FertilizerIssueRegister_Load(object sender, EventArgs e) { cmbYear.DataSource = myYear.ListAllVisibleYears(); cmbYear.DisplayMember = "YearCode"; cmbYear.ValueMember = "YearCode"; cmbYear.Text = DateTime.Now.Year.ToString(); cmbYear_SelectedIndexChanged(null, null); cmbSupplier.DataSource = mySupplier.ListActiveSuppliers(); cmbSupplier.DisplayMember = "SupplierName"; cmbSupplier.ValueMember = "SupplierCode"; cmbFertilizer.DataSource = myDeduction.ViewAllDeductionByGroup("FET"); cmbFertilizer.DisplayMember = "DeductionName"; cmbFertilizer.ValueMember = "DeductionCode"; cmbMonth.SelectedValue = DateTime.Now.Month; }
// end Sachintha Edited Code private void SupplierPaymentRegister_Load(object sender, EventArgs e) { cmbYear.DataSource = myYear.ListAllVisibleYears(); cmbYear.DisplayMember = "YearCode"; cmbYear.ValueMember = "YearCode"; cmbYear.Text = DateTime.Now.Year.ToString(); cmbYear_SelectedIndexChanged(null, null); cmbSupplier.DataSource = mySupplier.ListActiveSuppliers(); cmbSupplier.DisplayMember = "SupplierName"; cmbSupplier.ValueMember = "SupplierCode"; cmbSupplier.Enabled = false; cmbRoute.DataSource = myRoute.ListRouteDetails(); cmbRoute.DisplayMember = "RouteName"; cmbRoute.ValueMember = "RouteCode"; }
private void cmdProcess_Click(object sender, EventArgs e) { if (objCalMonthPay.getProcessEntries(ToDate.Value.Date.Year, ToDate.Value.Date.Month, cmbRoute.SelectedValue.ToString()).Tables[0].Rows.Count > 0) { string ProcessedDivisions = ""; cmdProcess.Enabled = false; String strChkAllRoutes = "%"; if (chkAllRoutes.Checked) { strChkAllRoutes = "%"; } else { strChkAllRoutes = cmbRoute.SelectedValue.ToString(); } DataTable dtRoute = myRoute.ListRouteDetails(strChkAllRoutes); foreach (DataRow drow in dtRoute.Rows) { if (calcBLPayment.getProcessEntries(ToDate.Value.Date.Year, ToDate.Value.Date.Month, cmbRoute.SelectedValue.ToString()).Tables[0].Rows.Count > 0) { txt_rate.Enabled = false; MessageBox.Show("Already Processed."); } else { String status = ""; String statusCancel = ""; calcBLPayment.DtFromDate = new DateTime(ToDate.Value.Date.Year, ToDate.Value.Date.Month, 1); calcBLPayment.DtToDate = calcBLPayment.DtFromDate.AddMonths(1).AddDays(-1); calcBLPayment.StrRouteCode = drow[0].ToString(); //myMonthlySettings.IntYear = ToDate.Value.Date.Year; //myMonthlySettings.IntMonth = ToDate.Value.Date.Month; //bool isIncentiveRouteWise = BoughtLeafBusinessLayer.BLUser.IsIncentiveLevelsSettingRouteWise(); decimal PayRate = myMonthlySettings.getKiloRate(ToDate.Value.Date.Year, ToDate.Value.Date.Month); txt_rate.Text = PayRate.ToString("F2"); //decimal StampDutyLevel = Convert.ToDecimal(fixedPaySettings.GetStampDuty().Rows[0][0].ToString()); //decimal StampDuty = Convert.ToDecimal(fixedPaySettings.GetStampDuty().Rows[0][1].ToString()); //myRoute.RouteCode = drow[0].ToString(); if (PayRate > 0) { DataTable dt = mySupplier.ListActiveSuppliers(drow[0].ToString()); calcBLPayment.IntProYear = ToDate.Value.Date.Year; calcBLPayment.IntProMonth = ToDate.Value.Date.Month; try { //statusCancel = calcBLPayment.CancleMonthBLPayment(drow[0].ToString()); //MessageBox.Show("Cancel Route, " + drow[0].ToString()); } catch (Exception ex) { MessageBox.Show("Error On Cancel, Route:" + drow[0].ToString() + " - " + ex.Message); } if (dt.Rows.Count > 0) { progressBar.Minimum = 0; progressBar.Maximum = dt.Rows.Count; for (int i = 0; i <= dt.Rows.Count - 1; i++) { calcBLPayment.StrSupplierCode = dt.Rows[i][0].ToString(); myGreenLeaf.StrSupplierCode = dt.Rows[i][0].ToString(); string supCode = dt.Rows[i][0].ToString(); //if (Convert.ToInt32(supCode) == 96) // Console.WriteLine(); try { //status = calcBLPayment.CalculateMonthBLPayment(dt.Rows[i][0].ToString(), drow[0].ToString()); } catch (Exception ex) { MessageBox.Show("Error On Supplier:" + dt.Rows[i][0].ToString() + " Of Route " + drow[0].ToString() + " - " + ex.Message); } progressBar.Value = i; } ProcessedDivisions += drow[0].ToString() + "-"; } dt.Dispose(); } else { MessageBox.Show("Bought Leaf Per Kilo Rate Is Not Defined For This Month..."); return; } lblStatus.Text = drow[0].ToString() + " Successfully Prepared Credit Availability"; progressBar.Value = 0; } } MessageBox.Show(ProcessedDivisions + " Successfully Prepared Credit Availability"); lblStatus.Text = "Successfully Prepared Credit Availability"; gbSupplierSelection.Enabled = true; } else { string ProcessedDivisions = ""; cmdProcess.Enabled = false; String strChkAllRoutes = "%"; if (chkAllRoutes.Checked) { strChkAllRoutes = "%"; } else { strChkAllRoutes = cmbRoute.SelectedValue.ToString(); } DataTable dtRoute = myRoute.ListRouteDetails(strChkAllRoutes); foreach (DataRow drow in dtRoute.Rows) { if (calcBLPayment.getProcessEntries(ToDate.Value.Date.Year, ToDate.Value.Date.Month, cmbRoute.SelectedValue.ToString()).Tables[0].Rows.Count > 0) { txt_rate.Enabled = false; MessageBox.Show("Already Processed."); } else { String status = ""; String statusCancel = ""; calcBLPayment.DtFromDate = new DateTime(ToDate.Value.Date.Year, ToDate.Value.Date.Month, 1); calcBLPayment.DtToDate = calcBLPayment.DtFromDate.AddMonths(1).AddDays(-1); calcBLPayment.StrRouteCode = drow[0].ToString(); //myMonthlySettings.IntYear = ToDate.Value.Date.Year; //myMonthlySettings.IntMonth = ToDate.Value.Date.Month; //bool isIncentiveRouteWise = BoughtLeafBusinessLayer.BLUser.IsIncentiveLevelsSettingRouteWise(); decimal PayRate = Convert.ToDecimal(txt_rate.Text); //decimal StampDutyLevel = Convert.ToDecimal(fixedPaySettings.GetStampDuty().Rows[0][0].ToString()); //decimal StampDuty = Convert.ToDecimal(fixedPaySettings.GetStampDuty().Rows[0][1].ToString()); //myRoute.RouteCode = drow[0].ToString(); if (PayRate > 0) { DataTable dt = mySupplier.ListActiveSuppliers(drow[0].ToString()); calcBLPayment.IntProYear = ToDate.Value.Date.Year; calcBLPayment.IntProMonth = ToDate.Value.Date.Month; try { statusCancel = calcBLPayment.CancleMonthBLPayment(drow[0].ToString()); //MessageBox.Show("Cancel Route, " + drow[0].ToString()); } catch (Exception ex) { MessageBox.Show("Error On Cancel, Route:" + drow[0].ToString() + " - " + ex.Message); } if (dt.Rows.Count > 0) { progressBar.Minimum = 0; progressBar.Maximum = dt.Rows.Count; for (int i = 0; i <= dt.Rows.Count - 1; i++) { calcBLPayment.StrSupplierCode = dt.Rows[i][0].ToString(); myGreenLeaf.StrSupplierCode = dt.Rows[i][0].ToString(); string supCode = dt.Rows[i][0].ToString(); //if (Convert.ToInt32(supCode) == 96) // Console.WriteLine(); try { status = calcBLPayment.CalculateMonthBLPayment(dt.Rows[i][0].ToString(), drow[0].ToString(), Convert.ToDecimal(txt_rate.Text)); } catch (Exception ex) { MessageBox.Show("Error On Supplier:" + dt.Rows[i][0].ToString() + " Of Route " + drow[0].ToString() + " - " + ex.Message); } progressBar.Value = i; } ProcessedDivisions += drow[0].ToString() + "-"; } dt.Dispose(); } else { MessageBox.Show("Bought Leaf Per Kilo Rate Is Not Defined For This Month..."); return; } lblStatus.Text = drow[0].ToString() + " Successfully Prepared Credit Availability"; progressBar.Value = 0; } } MessageBox.Show(ProcessedDivisions + " Successfully Prepared Credit Availability"); lblStatus.Text = "Successfully Prepared Credit Availability"; gbSupplierSelection.Enabled = true; } }