protected void btnNewItemAdd_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { if (txtP_NricNo.Text != "" && txtbynric.Text != "") { lblerror.Visible = false; AddAlertHandling objAddAlertHandling = new AddAlertHandling(); AlertHandlingUser objAH = new AlertHandlingUser(); objAH.Location_id = locationId(ddllocation.Text.Trim()); objAH.P_NRIC_no = txtP_NricNo.Text; objAH.P_Name = txtP_name.Text; objAH.P_Nationality = txtnationality.Text; objAH.P_Passport = txtP_Passport.Text; objAH.Alert_Type = ddlAlertreason.Text.Trim(); objAH.Comment = txtmessage.Text; objAH.AlertBy_Name = txtname.Text; objAH.AlertBy_NRICNo = txtbynric.Text; objAH.AlertDepartment = ddlRole0.Text; objAH.AlertDesignation = txtdesignation.Text; objAH.AlertContNo = txtphone.Text; objAH.V_Color = ""; objAH.V_OwnerName = ""; objAH.V_OwnerNricNo = ""; objAH.V_ResgistNo = ""; objAH.V_Type = ""; objAH.Date_From = Convert.ToDateTime(DateTime.Now); AdminBLL ws = new AdminBLL(); ws.AddAlertHandling(objAH); HttpContext.Current.Items.Add("COMPLETE", "INSERT"); Server.Transfer("..//SMSAdmin//AlertUpdateComplete.aspx"); } else { lblerror.Visible = true; lblerr.Visible = true; lblerr1.Visible = true; lblerror.Text = "please fill all the fields!!!"; } } catch (Exception ex) { logger.Info(ex.Message); } }
protected void btnNewItemAdd_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { String ZipRegex = "^[0-9]+$"; //if (Regex.IsMatch(txtAddNRIC.Text, ZipRegex)) // { AddAlertHandling objAddAlertHandling = new AddAlertHandling(); AlertHandlingUser objAH = new AlertHandlingUser(); String d = txtbynric.Text; String x = "select NRICno from UserInformation"; SqlCommand cmd4 = new SqlCommand(x, cn); SqlDataAdapter adp4 = new SqlDataAdapter(cmd4); DataSet ds4 = new DataSet(); adp4.Fill(ds4); int count1 = ds4.Tables[0].Rows.Count; for (i = 0; i < count1; i++) { String z = ds4.Tables[0].Rows[i].ItemArray[0].ToString(); if (string.Equals(d, z, StringComparison.CurrentCultureIgnoreCase)) { String d1 = txtAddNRIC.Text; String x1 = "select NRIC_no from Alert_Handling"; SqlCommand cmd3 = new SqlCommand(x1, cn); SqlDataAdapter adp = new SqlDataAdapter(cmd3); DataSet ds = new DataSet(); adp.Fill(ds); int count = ds.Tables[0].Rows.Count; for (i = 0; i < count; i++) { String z1 = ds.Tables[0].Rows[i].ItemArray[0].ToString(); if (string.Equals(d1, z1, StringComparison.CurrentCultureIgnoreCase)) { lblerror.Visible = true; lblerror.Text = "NRIC/FIN No. already exist ..!"; lblerr.Visible = true; throw new Exception(); } } objAH.Alert_Type = ddlRole.Text; objAH.Name = txtAddItemDesc.Text; objAH.NRIC_no = txtAddNRIC.Text; objAH.Company = txtAddCompany.Text; objAH.Vehicle_no = txtAddVehicle.Text; objAH.Message = txtmessage.Text; objAH.Name1 = txtname.Text; objAH.Designation = txtdesignation.Text; //objAH.Department = txtdepartment.Text; objAH.phone = txtphone.Text; objAH.Bynricno = txtbynric.Text; objAH.Date_From = Convert.ToDateTime(DateTime.Now); AdminBLL ws = new AdminBLL(); ws.AddAlertHandling(objAH); HttpContext.Current.Items.Add("COMPLETE", "INSERT"); Server.Transfer("..//SMSADMIN//AlertUpdateComplete.aspx"); } } lblerror.Visible = true; lblerror.Text = "No Exist NRIC/FIN No. ..!"; lblerr1.Visible = true; // } //else //{ // lblerror.Visible = true; // lblerror.Text = "Invalid NRIC/FIN No. ..!"; // lblerr.Visible = true; //} } catch (Exception ex) { logger.Info(ex.Message); } }