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); } }