//protected void OnSelectedIndexChanged_ddl_shift(object sender, EventArgs e)
//{
// string shift11 = ddl_shift.Text.ToString();
// if(shift11=="A")
// {
// txt_shift.Value="6:00 AM to 2:00 PM";
// }
// if (shift11 == "B")
// {
// txt_shift.Value = "2:00 PM to 10:00 PM";
// }
// if (shift11 == "C")
// {
// txt_shift.Value = "10:00 PM to 6:00 AM";
// }
// if (shift11 == "A1")
// {
// txt_shift.Value = "6:00 AM to 6:00 PM";
// }
// if (shift11 == "B1")
// {
// txt_shift.Value = "6:00 PM to 6:00 AM";
// }
//}
protected void btn_submit_Click(object sender, ImageClickEventArgs e)
{
objplanned = new PlaneedEntryDetail();
objcontext = new QualitySheetdclassDataContext();
try
{
ds = objserver.GetDateset("select * from PlaneedEntryDetails where PartNo='" + ddl_partno.Value.ToString() + "' and Process='" + ddl_process.Value.ToString() + "'");
if (ds.Tables[0].Rows.Count > 0)
{
//var query = (from table in objcontext.PlaneedEntryDetails where table.PartNo == ddl_partno.Value.ToString() select table).FirstOrDefault();
//if (query != null)
//{
// query.PartNo = ddl_partno.Value.ToString();
// query.Process = ddl_process.Value.ToString();
// query.Setup = txt_fixed_data.Value.ToString();
// query.LunchTime = txt_lunchtime.Value.ToString();
// query.TeaTime = txt_teatime.Value.ToString();
// //query.ShiftTime = txt_shift.Value.ToString();
// query.PlanTime = txt_plan.Value.ToString();
// query.Maintenance = txt_maintenance.Value.ToString();
// query.Manufacturing = txt_manuf.Value.ToString();
// query.Meeting = txt_meeting.Value.ToString();
// // query.Shift = ddl_shift.Text.ToString();
// objcontext.SubmitChanges();
// clearcontrols();
// Loadplan();
//}
ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "alert('Data Already Exist !');", true);
}
else
{
objplanned.PartNo = ddl_partno.Value.ToString();
objplanned.Process = ddl_process.Value.ToString();
objplanned.Maintenace = txt_pmaintenance.Value.ToString();
objplanned.Cleaning = txt_cleaning.Value.ToString();
objplanned.Break = txt_break.Value.ToString();
objplanned.Noplan = txt_demand.Value.ToString();
objplanned.Trials = txt_trial.Value.ToString();
objplanned.Meetings = txt_meetings.Value.ToString();
objplanned.Trainings = txt_traings.Value.ToString();
objplanned.Planedmaintenance = txt_planedmaintenance.Value.ToString();
objcontext.PlaneedEntryDetails.InsertOnSubmit(objplanned);
objcontext.SubmitChanges();
ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "alert('Data Submitted Successfuly !');", true);
clearcontrols();
Loadplan();
}
}
catch (Exception ex)
{
}
finally
{
}
}
public void Loadplan()
{
objplanned = new PlaneedEntryDetail();
dt = new DataTable();
objcontext = new QualitySheetdclassDataContext();
//var query = (from c in (objQualitySheetdclassDataContext.CycleTimeEntries) select c).ToList();
da = new SqlDataAdapter("select * from PlaneedEntryDetails", strConnString);
ds = new DataSet();
da.Fill(dt);
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
paging.DataSource = dt.DefaultView;
if (ds.Tables[0].Rows.Count > 5)
{
paging.AllowPaging = true;
paging.PageSize = 5;
paging.CurrentPageIndex = CurrentPage;
ViewState["totalpage"] = paging.PageCount;
link_previous.Enabled = !paging.IsFirstPage;
link_next.Enabled = !paging.IsLastPage;
}
else
{
div_paging.Visible = false;
}
Grid_plan.DataSource = paging;
Grid_plan.DataBind();
div_planentry.Visible = true;
div_actualerror.Visible = false;
createpaging();
}
else
{
div_planentry.Visible = false;
div_actualerror.Visible = true;
}
}
