private void SaveMachine3Data()
{
obj = new TblMachineReading();
obj.MachineID = 3;
obj.PreviousReading = Convert.ToDecimal(txtPreviousM3N1.Text);
obj.CurrentReading = Convert.ToDecimal(txtCurrentM3N1.Text);
if (txtPetrolDate.Enabled)
{
obj.DateX = Convert.ToDateTime(txtPetrolDate.SelectedDate).ToShortDateString();
}
else
{
obj.DateX = Convert.ToDateTime(txtPetrolDate.SelectedDate).AddDays(1).ToShortDateString();
}
obj.IsActive = true;
obj.CategoryID = 2;
obj.TestLiter = Convert.ToDecimal(txtTestM3N1.Text);
obj.NozleID = 5;
obj.Rate = Convert.ToDecimal(txtDesialRate.Text);
obj.Save();
obj = new TblMachineReading();
obj.MachineID = 3;
obj.PreviousReading = Convert.ToDecimal(txtPreviousM3N2.Text);
obj.CurrentReading = Convert.ToDecimal(txtCurrentM3N2.Text);
if (txtPetrolDate.Enabled)
{
obj.DateX = Convert.ToDateTime(txtPetrolDate.SelectedDate).ToShortDateString();
}
else
{
obj.DateX = Convert.ToDateTime(txtPetrolDate.SelectedDate).AddDays(1).ToShortDateString();
}
obj.IsActive = true;
obj.CategoryID = 2;
obj.TestLiter = Convert.ToDecimal(txtTestM3N2.Text);
obj.NozleID = 6;
obj.Rate = Convert.ToDecimal(txtDesialRate.Text);
obj.Save();
}
protected void btnSaveReading_Click(object sender, EventArgs e)
{
HiddenField hfMachineID = null, hfNozleNo = null, hfCategoryID = null;
double PMGQuantity = 0, HSDQuantity = 0, N1, N2;
TextBox txtPreviousReadingN1 = null, txtCurrentReadingN1 = null, txtTestUnitsN1 = null,
txtPreviousReadingN2 = null, txtCurrentReadingN2 = null, txtTestUnitsN2 = null;
for (int i = 0; i < rptMachines.Items.Count; i++)
{
hfNozleNo = (HiddenField)rptMachines.Items[i].FindControl("hfNozleNo");
hfMachineID = (HiddenField)rptMachines.Items[i].FindControl("hfMachineID");
hfCategoryID = (HiddenField)rptMachines.Items[i].FindControl("hfCategoryID");
//First Nozle
txtPreviousReadingN1 = (TextBox)rptMachines.Items[i].FindControl("txtPreviousReadingN1");
txtCurrentReadingN1 = (TextBox)rptMachines.Items[i].FindControl("txtCurrentReadingN1");
txtTestUnitsN1 = (TextBox)rptMachines.Items[i].FindControl("txtTestUnitsN1");
//Second Nozle
txtPreviousReadingN2 = (TextBox)rptMachines.Items[i].FindControl("txtPreviousReadingN2");
txtCurrentReadingN2 = (TextBox)rptMachines.Items[i].FindControl("txtCurrentReadingN2");
txtTestUnitsN2 = (TextBox)rptMachines.Items[i].FindControl("txtTestUnitsN2");
//First Nozle
obj = new TblMachineReading();
obj.MachineID = Convert.ToInt32(hfMachineID.Value);
obj.PreviousReading = Convert.ToDecimal(txtPreviousReadingN1.Text);
obj.CurrentReading = Convert.ToDecimal(txtCurrentReadingN1.Text);
if (txtPetrolDate.Enabled)
{
obj.DateX = Convert.ToDateTime(txtPetrolDate.SelectedDate).ToShortDateString();
}
else
{
obj.DateX = Convert.ToDateTime(txtPetrolDate.SelectedDate).AddDays(1).ToShortDateString();
}
obj.TestLiter = Convert.ToDecimal(txtTestUnitsN1.Text);
obj.IsActive = true;
obj.CategoryID = Convert.ToInt32(hfCategoryID.Value);
obj.NozleID = Convert.ToInt32(hfNozleNo.Value.Split(',')[0]);
obj.Rate = obj.CategoryID == 1 ? Convert.ToDecimal(txtPetrolRate.Text) : Convert.ToDecimal(txtDesialRate.Text);
obj.Save();
//Second Nozle
obj = new TblMachineReading();
obj.MachineID = Convert.ToInt32(hfMachineID.Value);
obj.PreviousReading = Convert.ToDecimal(txtPreviousReadingN2.Text);
obj.CurrentReading = Convert.ToDecimal(txtCurrentReadingN2.Text);
if (txtPetrolDate.Enabled)
{
obj.DateX = Convert.ToDateTime(txtPetrolDate.SelectedDate).ToShortDateString();
}
else
{
obj.DateX = Convert.ToDateTime(txtPetrolDate.SelectedDate).AddDays(1).ToShortDateString();
}
obj.TestLiter = Convert.ToDecimal(txtTestUnitsN2.Text);
obj.IsActive = true;
obj.CategoryID = Convert.ToInt32(hfCategoryID.Value);
obj.NozleID = Convert.ToInt32(hfNozleNo.Value.Split(',')[1]);
obj.Rate = obj.CategoryID == 1 ? Convert.ToDecimal(txtPetrolRate.Text) : Convert.ToDecimal(txtDesialRate.Text);
obj.Save();
if (obj.CategoryID == 1)
{
N1 = Convert.ToDouble(Convert.ToDecimal(txtCurrentReadingN1.Text) - Convert.ToDecimal(txtPreviousReadingN1.Text));
N2 = Convert.ToDouble(Convert.ToDecimal(txtCurrentReadingN2.Text) - Convert.ToDecimal(txtPreviousReadingN2.Text));
PMGQuantity += N1 + N2;
}
else
{
N1 = Convert.ToDouble(Convert.ToDecimal(txtCurrentReadingN1.Text) - Convert.ToDecimal(txtPreviousReadingN1.Text));
N2 = Convert.ToDouble(Convert.ToDecimal(txtCurrentReadingN2.Text) - Convert.ToDecimal(txtPreviousReadingN2.Text));
HSDQuantity += N1 + N2;
}
}
TblSale objPMGSale = new TblSale();
objPMGSale.IsNew = true;
objPMGSale.Qty = PMGQuantity;
objPMGSale.Rate = Convert.ToDecimal(txtPetrolRate.Text);
objPMGSale.Price = Convert.ToDecimal(objPMGSale.Qty * Convert.ToDouble(objPMGSale.Rate));
objPMGSale.CategoryID = 1;
objPMGSale.DateX = Convert.ToDateTime(txtPetrolDate.SelectedDate);
objPMGSale.Save();
TblSale objHSDSale = new TblSale();
objHSDSale.IsNew = true;
objHSDSale.Qty = HSDQuantity;
objHSDSale.Rate = Convert.ToDecimal(txtDesialRate.Text);
objHSDSale.Price = Convert.ToDecimal(objHSDSale.Qty * Convert.ToDouble(objHSDSale.Rate));
objHSDSale.CategoryID = 2;
objHSDSale.DateX = Convert.ToDateTime(txtPetrolDate.SelectedDate);
objHSDSale.Save();
Response.Redirect("MachineReading.aspx");
}