protected void btnSaveCode_Click(object sender, EventArgs e) { SqlCode.InsertParameters["Code_Type"].DefaultValue = txtCodeType.Text.ToUpper().Trim(); SqlCode.InsertParameters["Code_Description"].DefaultValue = txtCodeDescription.Text.ToUpper().Trim(); SqlCode.Insert(); gvCode.DataBind(); PaneladdCode.Visible = false; PanelgvCode.Visible = true; txtCodeType.Text = string.Empty; txtCodeDescription.Text = string.Empty; }
protected void btnaddSave_Click(object sender, EventArgs e) { if (Session["user"] == null || Session["access"] != "ADMIN") { Response.Redirect("../index.aspx"); } DataSourceSelectArguments dsArguments = new DataSourceSelectArguments(); SqlAddCode.SelectCommand = " SELECT * FROM CODE WHERE CODE_TYPE = @CODE_TYPE AND CODE_ID = @CODE_ID "; SqlAddCode.SelectParameters["CODE_TYPE"].DefaultValue = txtaddCodeType.Text.Trim(); SqlAddCode.SelectParameters["CODE_ID"].DefaultValue = txtaddCodeId.Text.Trim(); DataView dvCodeExists = new DataView(); dvCodeExists = (DataView)SqlAddCode.Select(dsArguments); if (dvCodeExists.Count >= 1) { txtaddCodeType.Text = string.Empty; txtaddCodeId.Text = string.Empty; txtaddCodeDescription.Text = string.Empty; rbaddEnableList.SelectedIndex = -1; addError.Text = "CODE Already Exist !!! Please Enter another CODE"; addError.ForeColor = System.Drawing.Color.Red; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append("alert('CODE Already Exist !!! Please Enter another CODE');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AddErrorModalScript", sb.ToString(), false); } else { string UserName = (string)Session["commonname"]; string CurrentDate = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString(); SqlCode.InsertParameters["CODE_TYPE"].DefaultValue = txtaddCodeType.Text; SqlCode.InsertParameters["CODE_ID"].DefaultValue = txtaddCodeId.Text; SqlCode.InsertParameters["CODE_DESCRIPTION"].DefaultValue = txtaddCodeDescription.Text; SqlCode.InsertParameters["CODE_STATUS"].DefaultValue = rbaddEnableList.SelectedValue; SqlCode.InsertParameters["ADDED_BY"].DefaultValue = UserName.ToUpper().Trim(); SqlCode.InsertParameters["ADDED_DATE"].DefaultValue = CurrentDate; SqlCode.InsertParameters["UPDATED_BY"].DefaultValue = UserName.ToUpper().Trim(); SqlCode.InsertParameters["UPDATED_DATE"].DefaultValue = CurrentDate; try { SqlCode.Insert(); txtaddCodeId.Text = string.Empty; txtaddCodeType.Text = string.Empty; txtaddCodeDescription.Text = string.Empty; addError.Text = string.Empty; rbaddEnableList.SelectedIndex = -1; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append("alert('Code added successfully.');"); sb.Append("$('#addModal').modal('hide');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AddHideModalScript", sb.ToString(), false); gvCode.DataBind(); CodeTypeSearch.AppendDataBoundItems = false; upCode.Update(); } catch { addError.Text = "An error has occured while adding a user please contact administrator"; addError.ForeColor = System.Drawing.Color.Red; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append("$('#addModal').modal('show');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AddHideModalScript", sb.ToString(), false); } } }