private void submitOT()
{
double overtimeAmount;
try
{
overtimeAmount = Convert.ToDouble(txtOvertime.Text);
}
catch
{
overtimeAmount = 0;
}
Overtime o = new Overtime();
o.updateOT(_selectedDate, _department, overtimeAmount);
}
private void btn_update_Click(object sender, EventArgs e)
{
//update each line here to add new overtime, even if it hasnt been changed then it should not matter because it pulls the current overtime into that cell
using (SqlConnection CONNECT = new SqlConnection(connectionStrings.ConnectionString))
{
string sql = "";
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
Overtime o = new Overtime();
o.updateOT(Convert.ToDateTime(dataGridView1.Rows[i].Cells[1].Value), dept, Convert.ToDouble(dataGridView1.Rows[i].Cells[2].Value));
if (dataGridView1.Rows[i].Cells[0].Value.ToString() == dateID.ToString())
{
overtimeForSD = Convert.ToInt32(dataGridView1.Rows[i].Cells[2].Value);
}
}
}
this.Close();
}
private void getOvertime()
{
SqlConnection conn = new SqlConnection(connectionStrings.ConnectionString);
string sql = "";
switch (_department)
{
case "Slimline":
sql = "SELECT slimline_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "Laser":
sql = "SELECT laser_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "Punching":
sql = "SELECT punching_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "Bending":
sql = "SELECT bending_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "Welding":
sql = "SELECT welding_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "Dressing":
sql = "SELECT buffing_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "Painting":
sql = "SELECT painting_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "Packing":
sql = "SELECT packing_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "Stores":
sql = "SELECT stores_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "Dispatch":
sql = "SELECT dispatch_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "toolroom":
sql = "SELECT toolroom_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "Cleaning":
sql = "SELECT cleaning_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "Management":
sql = "SELECT management_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
case "HS":
sql = "SELECT hs_OT as 'FieldName' from dbo.power_plan_overtime where date_id=@dateID";
break;
}
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
Overtime o = new Overtime();
o.getDateID(_selectedDate);
cmd.Parameters.AddWithValue("@dateID", o._dateID);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read())
{
txtOvertime.Text = rdr["FieldName"].ToString();
}
else
{
txtOvertime.Text = 0.ToString();
}
}
}
