protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string code_exist = WebTools.GetExpr("UPPER(MAT_CODE1)", "PIP_SITE_JOINTS_IPMS", " WHERE UPPER(MAT_CODE1)='" + txtMAT_CODE1.Text.ToUpper().Trim() + "'");
if (code_exist != txtMAT_CODE1.Text.ToUpper().Trim())
{
FlangeDataSource.Insert();
Master.ShowMessage(" Saved succesfully!");
}
else
{
Master.ShowWarn(code_exist + " Invalid Data!");
}
}
catch (Exception ex)
{
Master.ShowWarn(ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string code_exist = WebTools.GetExpr("PID_NUMBER", "FLANGE_PID_DATA", " WHERE UPPER(PID_NUMBER)='" + txtPID_NUMBER.Text.ToUpper().Trim() + "'");
if (code_exist.Length == 0)
{
FlangeDataSource.Insert();
FlangeGridView.DataBind();
Master.ShowSuccess(" Saved succesfully!");
}
else
{
Master.ShowError("Already exist Data!");
}
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string code_exist = WebTools.GetExpr("UNIQ_ID", "FLANGE_SYSPID_DATA", " WHERE PID_SEQ='" + RadcobPidNo.SelectedValue + "' AND " +
"SEQ=" + Request.QueryString["SEQ"]);
if (code_exist.Length == 0)
{
FlangeDataSource.Insert();
FlangeGridView.DataBind();
Master.show_success(" Saved succesfully!");
}
else
{
Master.show_error("Already exist Data!");
}
}
catch (Exception ex)
{
Master.show_error(ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string code_exist = WebTools.GetExpr("SEQ", "FLANGE_SYS_DATA", " WHERE UPPER(SYSTEM_NO)='" + txtSYSTEM_NO.Text.ToUpper().Trim() + "'" + "AND UPPER(SUB_SYSTEM_NO)='" + txtSUB_SYSTEM_NO.Text.ToUpper().Trim() + "'"
);
if (code_exist.Length == 0)
{
FlangeDataSource.Insert();
Master.ShowMessage(" Saved succesfully!");
FlangeGridView.DataBind();
}
else
{
Master.ShowWarn("Already exist Data!");
}
}
catch (Exception ex)
{
Master.ShowWarn(ex.Message);
}
}
