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