protected void GetData()
{
try
{
UserSelectionModel model = new UserSelectionModel();
model = (UserSelectionModel)Session["UserSelectionModel"];
var x = Session["UserID"];
string Shift = drpShift.SelectedItem.Text;
string[] tokens = Shift.Split('/');
string date = tokens[tokens.Length - 1];
string dateTime = DateTime.ParseExact(date.Trim().Replace("-", "/"), "dd/MM/yyyy", null).ToString("yyyy-MM-dd");
//DateTime datetime = DateTime.Parse(date);
//var FormatedDate = datetime.ToString("yyyy-MM-dd");
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@OPR", "3"),
new SqlParameter("@PlantCode", drpPlant.SelectedValue),
new SqlParameter("@Shift", drpShift.SelectedValue),
new SqlParameter("@Date", dateTime),
new SqlParameter("@UserId", HttpContext.Current.Session["USERID"].ToString()),
};
DataTable Dt = new DataTable();
Dt = DBClass.GetDatatable_WithParam(param, "DM_SP_GET_STOPPAGE_DATA");
GrdStoppageReason.DataSource = Dt;
GrdStoppageReason.DataBind();
}
catch (Exception ex)
{
_logger.Error(string.Concat("GetData::", ex.Message), ex);
}
}
protected void GetData()
{
try
{
UserSelectionModel model = new UserSelectionModel();
model = (UserSelectionModel)Session["UserSelectionModel"];
string Shift = drpShift.SelectedItem.Text;
string[] tokens = Shift.Split('/');
string date = tokens[tokens.Length - 1];
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@OPR", "3"),
new SqlParameter("@PlantCode", drpPlant.SelectedValue),
new SqlParameter("@Shift", drpShift.SelectedValue),
new SqlParameter("@Date", date),
new SqlParameter("@UserId", HttpContext.Current.Session["USERID"].ToString()),
};
DataTable Dt = new DataTable();
Dt = DBClass.GetDatatable_WithParam(param, "DM_SP_GET_STOPPAGE_DATA");
GrdStoppageReason.DataSource = Dt;
GrdStoppageReason.DataBind();
}
catch (Exception ex)
{
_logger.Error(string.Concat("GetData::", ex.Message), ex);
}
}
public void BindStoppagesReason()
{
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@OPR", 2),
new SqlParameter("@Line", lblline.Text),
new SqlParameter("@PlantCode", lblplantcode.Text),
new SqlParameter("@Date", lbldate.Text),
new SqlParameter("@ShiftCode", lblshift.Text),
};
dt = DBClass.GetDatatable_WithParam(param, "DM_SP_DML_STOPPAGE_DATA");
GrdStoppageReason.DataSource = dt;
GrdStoppageReason.DataBind();
}
