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