protected void btnAddParameter_Click(object sender, EventArgs e)
{
GetParameter();
GetSeverity();
GetUOM();
GetDuration();
QualitativeGroup.Visible = false;
QuantitativeGroup.Visible = false;
MPAddParameter.Show();
if (GrdSQCScheduleStatus != null && GrdSQCScheduleStatus.Rows.Count > 0)
{
Session["ScheduleId"] = GrdSQCScheduleStatus.DataKeys[0].Values[1];
GetStation();
}
}
protected void OnParameterChange(Object sender, EventArgs e)
{
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@OPR", "39"),
new SqlParameter("@ParameterId", drpParameter.SelectedValue),
};
DataTable Dt = new DataTable();
Dt = DBClass.GetDatatable_WithParam(param, "DM_SP_GET_DATA");
if (Dt != null && Dt.Rows.Count > 0)
{
if (Convert.ToInt16(Dt.Rows[0]["ParameterTypeId"].ToString()) == 1)
{
QualitativeGroup.Visible = true;
QuantitativeGroup.Visible = false;
txtLCL.Text = string.Empty;
txtUCL.Text = string.Empty;
txtQUOM.Text = string.Empty;
MPAddParameter.Show();
}
else
{
QualitativeGroup.Visible = false;
QuantitativeGroup.Visible = true;
txtEResult.Text = string.Empty;
MPAddParameter.Show();
}
}
}
catch (Exception ex)
{
_logger.Error(string.Concat("GetParameterType::", ex.Message), ex);
}
}
protected void btnAddParam_Click(object sender, EventArgs e)
{
try
{
object obj;
lblStartMessage.Text = string.Empty;
if (drpParameter.SelectedValue == "0")
{
lblStartMessage.Text = "Please Select Parameter !";
lblStartMessage.ForeColor = Color.Red;
MPAddParameter.Show();
}
else if (drpStation.SelectedValue == "")
{
lblStartMessage.Text = "Please Select Station !";
lblStartMessage.ForeColor = Color.Red;
MPAddParameter.Show();
}
else if (drpSeverity.SelectedValue == "0")
{
lblStartMessage.Text = "Please Select Severity !";
lblStartMessage.ForeColor = Color.Red;
MPAddParameter.Show();
}
else if (string.IsNullOrEmpty(txtNoOfSamples.Text))
{
lblStartMessage.Text = "Please enter No.of Sample !";
lblStartMessage.ForeColor = Color.Red;
MPAddParameter.Show();
}
else if (drpUOM.SelectedValue == "0")
{
lblStartMessage.Text = "Please Select UOM !";
lblStartMessage.ForeColor = Color.Red;
MPAddParameter.Show();
}
else if (string.IsNullOrEmpty(txtEResult.Text) && (string.IsNullOrEmpty(txtLCL.Text) && string.IsNullOrEmpty(txtUCL.Text) && string.IsNullOrEmpty(txtQUOM.Text)))
{
lblStartMessage.Text = "Please enter either qualitative or quantitative parameter !";
lblStartMessage.ForeColor = Color.Red;
MPAddParameter.Show();
}
else
{
TimeSpan time = new TimeSpan(Int16.Parse(ddlHour.SelectedValue), Int16.Parse(ddlMinute.SelectedValue), 0);
if (Session["ScheduleId"] == null && Convert.ToInt16(Session["ScheduleId"]) <= 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('Please activate schedule')", true);
}
else
{
List <SqlParameter> saveParam = new List <SqlParameter>
{
new SqlParameter("@OPR", "14"),
new SqlParameter("@ScheduleId", Int32.Parse(Session["ScheduleId"].ToString())),
new SqlParameter("@ParameterId", drpParameter.SelectedValue),
new SqlParameter("@StationCode", drpStation.SelectedValue),
new SqlParameter("@SeverityId", drpSeverity.SelectedValue),
new SqlParameter("@NoOfSamplesId", txtNoOfSamples.Text.Trim()),
new SqlParameter("@UOMId", drpUOM.SelectedValue),
new SqlParameter("@ShiftCode", lblshift.Text.Trim()),
new SqlParameter("@CreatedBy", Convert.ToString(Session["username"]))
};
SqlParameter repeatParameter = new SqlParameter("@Repeat", SqlDbType.Time);
repeatParameter.Value = time;
saveParam.Add(repeatParameter);
if (!string.IsNullOrEmpty(txtEResult.Text))
{
saveParam.Add(new SqlParameter("@EResult", txtEResult.Text));
}
else if (!string.IsNullOrEmpty(txtLCL.Text) && !string.IsNullOrEmpty(txtUCL.Text) && !string.IsNullOrEmpty(txtQUOM.Text))
{
saveParam.Add(new SqlParameter("@LCL", txtLCL.Text));
saveParam.Add(new SqlParameter("@UCL", txtUCL.Text));
saveParam.Add(new SqlParameter("@UOM", txtQUOM.Text));
}
obj = DBClass.ExecuteNonQuery_WithParam(saveParam.ToArray(), "DM_SP_DML_DATA");
if (obj != null && Convert.ToInt64(obj) != 0)
{
BindGrdSQCScheduleStatus();
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "javascript:alert('Parameter added successfully')", true);
}
}
}
}
catch (Exception ex)
{
_logger.Error(string.Concat("btnSubmit_Click::", ex.Message), ex);
}
}
