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