private void btnShowMonitoring_Click(object sender, EventArgs e)
{
try
{
DAL.JobEntry objDAL = new DAL.JobEntry();
DataTable dtData = new DataTable();
if (string.IsNullOrEmpty(dtpFromMonitoring.Text) && string.IsNullOrEmpty(dtpToMonitoring.Text))
{
dtData = objDAL.GetCurrentJob(string.Empty, string.Empty, chkIsLive.Checked, txtSearchJobNo.Text.Trim());
}
else
{
dtData = objDAL.GetCurrentJob(dtpFromMonitoring.Value.ToString("dd/MMM/yyyy"), dtpToMonitoring.Value.ToString("dd/MMM/yyyy"), chkIsLive.Checked, txtSearchJobNo.Text.Trim());
}
if (dtData.Rows.Count > 0)
{
SetCurrentJobData(dtData);
}
else
{
MessageBox.Show("Record Not Found For Selected Date.", "Data", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnShowCalculation_Click(object sender, EventArgs e)
{
try
{
DAL.JobEntry objDAL = new DAL.JobEntry();
DataTable dtData = new DataTable();
if (string.IsNullOrEmpty(dtpFromCalculation.Text) && string.IsNullOrEmpty(dtpToCalculation.Text))
{
dtData = objDAL.GetDryRunReport(string.Empty, string.Empty);
}
else
{
dtData = objDAL.GetDryRunReport(dtpFromCalculation.Value.ToString("dd/MMM/yyyy"), dtpToCalculation.Value.ToString("dd/MMM/yyyy"));
}
dgvDryRun.DataSource = dtData;
dgvDryRun.Columns[0].Visible = false;
dgvDryRun.Columns[1].HeaderText = "Heat Start Time";
dgvDryRun.Columns[2].HeaderText = "Heat End Time";
dgvDryRun.Columns[3].HeaderText = "Tot. Fur. Dur.";
dgvDryRun.Columns[4].HeaderText = "Tot. All Job Dur.";
dgvDryRun.Columns[5].HeaderText = "Tot. Dry Run Dur.";
dgvDryRun.Columns[6].HeaderText = "Tot. Fur. Unit";
dgvDryRun.Columns[7].HeaderText = "Tot. Job Unit";
dgvDryRun.Columns[8].HeaderText = "Tot. Dry Run Unit";
dgvDryRun.Columns[9].HeaderText = "Tot. Dry Run Amt.";
dgvDryRun.Columns[0].Width = 0;
dgvDryRun.Columns[1].Width = 150;
dgvDryRun.Columns[2].Width = 150;
dgvDryRun.Columns[3].Width = 65;
dgvDryRun.Columns[4].Width = 65;
dgvDryRun.Columns[5].Width = 65;
dgvDryRun.Columns[6].Width = 65;
dgvDryRun.Columns[7].Width = 65;
dgvDryRun.Columns[8].Width = 65;
dgvDryRun.Columns[9].Width = 65;
dgvDryRun.Columns[1].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt";
dgvDryRun.Columns[2].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt";
dgvDryRun.Columns[9].DefaultCellStyle.Format = "#0.000";
dgvDryRun.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvDryRun.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvDryRun.Columns[8].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvDryRun.Columns[9].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private DataTable GetCurrentJob(string fromDate, string toDate, bool IsLive, string JobNo)
{
DataTable dtNew = new DataTable();
try
{
this.Invoke((Action) delegate
{
dtNew = new DAL.JobEntry().GetCurrentJob(fromDate, toDate, IsLive, JobNo);
});
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
return(dtNew);
}
public void GetJobEntry()
{
try
{
ENT.JobEntry objENT = new ENT.JobEntry();
List <ENT.JobEntry> lstENT = new List <ENT.JobEntry>();
if (checkBox1.Checked)
{
objENT.Mode = "GetAllJobEntryToday";
}
else
{
objENT.Mode = "GetAllJobEntryByDate";
objENT.strJobStartTime = DAL.DBHelper.ChangeDate(dtpFromDate.Text);
objENT.strJobEndTime = DAL.DBHelper.ChangeDate(dtpToDate.Text);
objENT.JobNo = txtJobNo.Text.Trim();
}
lstENT = new DAL.JobEntry().GetJobEntry(objENT);
dgvSales.DataSource = lstENT;
dgvSales.Columns[0].HeaderText = "JobID";
dgvSales.Columns[0].Visible = false;
dgvSales.Columns[1].HeaderText = "Job No";
dgvSales.Columns[2].HeaderText = "Job Furnace No";
dgvSales.Columns[3].HeaderText = "Start Time";
dgvSales.Columns[4].HeaderText = "End Time";
dgvSales.Columns[5].HeaderText = "Pour1 Time";
dgvSales.Columns[6].HeaderText = "Pour2 Time";
dgvSales.Columns[7].HeaderText = "Pour3 Time";
dgvSales.Columns[8].HeaderText = "Pour4 Time";
dgvSales.Columns[9].HeaderText = "Pour5 Time";
dgvSales.Columns[10].HeaderText = "Pour6 Time";
dgvSales.Columns[11].Visible = false;
dgvSales.Columns[12].Visible = false;
dgvSales.Columns[13].Visible = false;
dgvSales.Columns[14].HeaderText = "Job Status";
dgvSales.Columns[15].Visible = false;
dgvSales.Columns[16].Visible = false;
dgvSales.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnShowConsumption_Click(object sender, EventArgs e)
{
try
{
DAL.JobEntry objDAL = new DAL.JobEntry();
DataTable dtData = new DataTable();
if (string.IsNullOrEmpty(dtpFromConsumption.Text) && string.IsNullOrEmpty(dtpToConsumption.Text))
{
dtData = objDAL.GetEnergyConsumptionHeatWise(string.Empty, string.Empty);
}
else
{
dtData = objDAL.GetEnergyConsumptionHeatWise(dtpFromConsumption.Value.ToString("dd/MMM/yyyy"), dtpToConsumption.Value.ToString("dd/MMM/yyyy"));
}
dgvEngCons.DataSource = dtData;
dgvEngCons.Columns[0].HeaderText = "Job No.";
dgvEngCons.Columns[1].HeaderText = "Job Furnace No.";
dgvEngCons.Columns[2].HeaderText = "Total Unit";
dgvEngCons.Columns[3].HeaderText = "Job Start";
dgvEngCons.Columns[4].HeaderText = "Job End";
dgvEngCons.Columns[5].HeaderText = "Heat Start";
dgvEngCons.Columns[6].HeaderText = "Heat End";
dgvEngCons.Columns[0].Width = 100;
dgvEngCons.Columns[1].Width = 100;
dgvEngCons.Columns[2].Width = 100;
dgvEngCons.Columns[3].Width = 150;
dgvEngCons.Columns[4].Width = 150;
dgvEngCons.Columns[5].Width = 150;
dgvEngCons.Columns[6].Width = 150;
dgvEngCons.Columns[3].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt";
dgvEngCons.Columns[4].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt";
dgvEngCons.Columns[5].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt";
dgvEngCons.Columns[6].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnShowOverall_Click(object sender, EventArgs e)
{
try
{
DAL.JobEntry objDAL = new DAL.JobEntry();
DataTable dtData = new DataTable();
if (string.IsNullOrEmpty(dtpFromOverall.Text) && string.IsNullOrEmpty(dtpToOverall.Text))
{
dtData = objDAL.GetOverAllHeatFurnaceTime(string.Empty, string.Empty);
}
else
{
dtData = objDAL.GetOverAllHeatFurnaceTime(dtpFromOverall.Value.ToString("dd/MMM/yyyy"), dtpToOverall.Value.ToString("dd/MMM/yyyy"));
}
dgvOverAll.DataSource = dtData;
dgvOverAll.Columns[0].HeaderText = "Job No.";
dgvOverAll.Columns[1].HeaderText = "Job Furnace No.";
dgvOverAll.Columns[2].HeaderText = "Job Start";
dgvOverAll.Columns[3].HeaderText = "Job End";
dgvOverAll.Columns[4].HeaderText = "Job Duration";
dgvOverAll.Columns[0].Width = 100;
dgvOverAll.Columns[1].Width = 100;
dgvOverAll.Columns[2].Width = 150;
dgvOverAll.Columns[3].Width = 150;
dgvOverAll.Columns[4].Width = 100;
dgvOverAll.Columns[2].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt";
dgvOverAll.Columns[3].DefaultCellStyle.Format = "dd/MM/yyyy hh:mm:ss tt";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
