protected void Page_Load(object sender, EventArgs e)
{
if (Session["User_ID"] != null && Session["Customer_ID"] != null)
{
if (!IsPostBack)
{
try
{
if (Request.QueryString["gaugeId"] != null)
{
string getIds = Request.QueryString["gaugeId"].ToString();
string[] str = getIds.Split(',');
int gaugeId = Convert.ToInt32(str[0].ToString());
int customerId = Convert.ToInt32(str[1].ToString());
DataTable dat = new DataTable();
string stprocedure = "spGaugeDetailsReport";
DataSet ds = q.ProcdureWith3Param(stprocedure, 1, customerId, gaugeId);
if (ds.Tables[0].Rows.Count > 0)
{
ReportViewer1.Reset();
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/GaugeDetailsReport.rdlc");
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportDataSource rep = new ReportDataSource("DataSet1", ds.Tables[0]);
ReportViewer1.LocalReport.DataSources.Add(rep);
ReportViewer1.LocalReport.Refresh();
}
DataTable dtcust = new DataTable();
dtcust = g.GetCustomerDetails(Convert.ToInt32(Session["Customer_ID"]));
ReportDataSource repcust = new ReportDataSource("DataSetcust", dtcust);
ReportViewer1.LocalReport.DataSources.Add(repcust);
ReportViewer1.LocalReport.EnableExternalImages = true;
}
}
catch (Exception ex)
{
g.ShowMessage(this.Page, ex.Message);
}
}
}
else
{
Response.Redirect("Login.aspx");
}
}
private void bindTranHistoryGrd()
{
try
{
grdCalibTran.DataSource = null;
grdCalibTran.DataBind();
string searchValue = txtsearch.Text.Trim();
searchValue = Regex.Replace(searchValue, @"\s+", " ");
bool Status = g.CheckSuperAdmin(Convert.ToInt32(Session["User_ID"]));
string stprocedure = "spCalibTransactionDt";
// Check super Admin condition
#region supper Admin wise
if (Status == true)
{
int customerId;
if (ddlcust.SelectedIndex == 0)
{
if (ddtRejeOrNotInUsed.SelectedIndex == 0)
{
DataSet ds = q.ProcdureWith3Param(stprocedure, 9, 0, "");
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 1 && txtsearch.Text == "")
{
DataSet ds = q.ProcdureWith3Param(stprocedure, 10, 0, "");
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 2 && txtsearch.Text == "")
{
DataSet ds = q.ProcdureWith3Param(stprocedure, 11, 0, "");
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 1 && txtsearch.Text != "")
{
DataSet ds = q.ProcdureWith3Param(stprocedure, 16, 0, searchValue);
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 2 && txtsearch.Text != "")
{
DataSet ds = q.ProcdureWith3Param(stprocedure, 17, 0, searchValue);
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
}
if (ddlcust.SelectedIndex > 0)
{
if (ddtRejeOrNotInUsed.SelectedIndex == 0)
{
customerId = Convert.ToInt32(ddlcust.SelectedValue);
DataSet ds = q.ProcdureWith3Param(stprocedure, 7, customerId, "");
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 1 && txtsearch.Text == "")
{
customerId = Convert.ToInt32(ddlcust.SelectedValue);
DataSet ds = q.ProcdureWith3Param(stprocedure, 12, customerId, "");
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 2 && txtsearch.Text == "")
{
customerId = Convert.ToInt32(ddlcust.SelectedValue);
DataSet ds = q.ProcdureWith3Param(stprocedure, 13, customerId, "");
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 0 && txtsearch.Text != "")
{
customerId = Convert.ToInt32(ddlcust.SelectedValue);
DataSet ds = q.ProcdureWith3Param(stprocedure, 8, customerId, searchValue);
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 1 && txtsearch.Text != "")
{
customerId = Convert.ToInt32(ddlcust.SelectedValue);
DataSet ds = q.ProcdureWith3Param(stprocedure, 14, customerId, searchValue);
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 2 && txtsearch.Text != "")
{
customerId = Convert.ToInt32(ddlcust.SelectedValue);
DataSet ds = q.ProcdureWith3Param(stprocedure, 15, customerId, searchValue);
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
}
}
#endregion
#region employee wise
else
{
int customerID = Convert.ToInt32(Session["Customer_ID"]);
if (ddtRejeOrNotInUsed.SelectedIndex == 0 && txtsearch.Text == "")
{
DataSet ds = q.ProcdureWith3Param(stprocedure, 7, customerID, "");
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 1 && txtsearch.Text == "")
{
DataSet ds = q.ProcdureWith3Param(stprocedure, 12, customerID, "");
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 2 && txtsearch.Text == "")
{
DataSet ds = q.ProcdureWith3Param(stprocedure, 13, customerID, "");
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 0 && txtsearch.Text != "")
{
DataSet ds = q.ProcdureWith3Param(stprocedure, 8, customerID, searchValue);
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 1 && txtsearch.Text != "")
{
DataSet ds = q.ProcdureWith3Param(stprocedure, 14, customerID, searchValue);
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
else if (ddtRejeOrNotInUsed.SelectedIndex == 2 && txtsearch.Text != "")
{
DataSet ds = q.ProcdureWith3Param(stprocedure, 15, customerID, searchValue);
grdCalibTran.DataSource = ds.Tables[0];
grdCalibTran.DataBind();
}
}
#endregion
checkAuthority();
}
catch (Exception ex)
{
g.ShowMessage(this.Page, ex.Message);
}
}
protected void btnEditGauge_Click(object sender, EventArgs e)
{
try
{
LinkButton lnk = (LinkButton)sender;
lblGaugeId.Text = lnk.CommandArgument;
string stprocedure = "spGaugeDetailsReport";
DataSet ds = q.ProcdureWith3Param(stprocedure, 2, 0, Convert.ToInt32(lblGaugeId.Text));
DataTable dtgauge = ds.Tables[0];
txtGaugeId.Text = dtgauge.Rows[0]["gauge_id"].ToString();
txtGaugeName.Text = dtgauge.Rows[0]["gauge_name"].ToString();
txtGaugeSrNo.Text = dtgauge.Rows[0]["gauge_sr_no"].ToString();
txtManufactureId.Text = dtgauge.Rows[0]["gauge_Manufature_Id"].ToString();
txtmake.Text = dtgauge.Rows[0]["make"].ToString();
ddlgaugeType.SelectedValue = dtgauge.Rows[0]["gauge_type_master_id"].ToString();
if (dtgauge.Rows[0]["gauge_type"].ToString() == "ATTRIBUTE")
{
ddlType.SelectedIndex = 1;
divSize.Visible = true;
divRange.Visible = false;
divLeastCount.Visible = false;
divResolution.Visible = false;
divGoandNoGoPlus.Visible = true;
divGoandNoGoTolleranceminus.Visible = true;
divPermisable1.Visible = false;
divPermisable2.Visible = false;
divGoWereLimit.Visible = true;
txtSize.Text = dtgauge.Rows[0]["size_range"].ToString();
string tolType = dtgauge.Rows[0]["tolerance_type"].ToString();
if (tolType == "Plug Tolerance")
{
ddlTolerance.SelectedIndex = 1;
}
else if (tolType == "Snap Tolerance")
{
ddlTolerance.SelectedIndex = 2;
}
else
{
ddlTolerance.SelectedIndex = 0;
}
txtSizeMax.Text = dtgauge.Rows[0]["size2"].ToString();
txtToleranceRange.Text = dtgauge.Rows[0]["tolerance_desc"].ToString();
hftoleranceId.Value = dtgauge.Rows[0]["tolerance_id"].ToString();
string grade = dtgauge.Rows[0]["tolerance_grd"].ToString();
grade = grade.Replace("grd_", "grd");
hfGrade.Value = grade;
}
else if (dtgauge.Rows[0]["gauge_type"].ToString() == "VARIABLE")
{
ddlType.SelectedIndex = 2;
divSize.Visible = false;
divRange.Visible = true;
divLeastCount.Visible = true;
divResolution.Visible = true;
divGoandNoGoPlus.Visible = false;
divGoandNoGoTolleranceminus.Visible = false;
divPermisable1.Visible = true;
divPermisable2.Visible = true;
divGoWereLimit.Visible = false;
txtRange.Text = dtgauge.Rows[0]["size_range"].ToString();
}
txtGoWereLimit.Text = dtgauge.Rows[0]["go_were_limit"].ToString();
txtGoTollerancePlus.Text = dtgauge.Rows[0]["go_tollerance_plus"].ToString();
txtGoTolleranceMinus.Text = dtgauge.Rows[0]["go_tollerance_minus"].ToString();
txtNoGoTollerancePlus.Text = dtgauge.Rows[0]["no_go_tollerance_plus"].ToString();
txtNoGoTolleranceMinus.Text = dtgauge.Rows[0]["no_go_tollerance_minus"].ToString();
txtLeastCount.Text = dtgauge.Rows[0]["least_count"].ToString();
txtResolution.Text = dtgauge.Rows[0]["resolution"].ToString();
txtPermisableError1.Text = dtgauge.Rows[0]["permisable_error1"].ToString();
txtPermisableError2.Text = dtgauge.Rows[0]["permisable_error2"].ToString();
MultiView1.ActiveViewIndex = 1;
btnSaveGauge.Text = "Update";
}
catch (Exception ex)
{
g.ShowMessage(this.Page, ex.Message);
}
}
