protected void btnsave_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { AlertHandlingUser objalert = new AlertHandlingUser(); AdminBLL ws = new AdminBLL(); objalert.Alert_Type = ddlRole.Text; objalert.Name = txtAddItemDesc.Text; objalert.NRIC_no = txtAddNRIC.Text; objalert.Company = txtAddCompany.Text; objalert.Vehicle_no = txtAddVehicle.Text; objalert.Message = txtmessage.Text; objalert.Bynricno = txtbynric.Text; objalert.Name1 = txtname.Text; objalert.Designation = txtdesignation.Text; objalert.Department = ddlRole0.Text; objalert.phone = txtphone.Text; ws.Updatalert(objalert); HttpContext.Current.Items.Add(ContextKeys.CTX_COMPLETE, "UPDATE"); Server.Transfer("../SMSAdmin/AlertUpdateComplete.aspx"); } catch (Exception ex) { logger.Info(ex.Message); } }
public void AddAlertHandling(AlertHandlingUser objAlertHandling) { try { AdminDAL objAdminDAL = new AdminDAL(); objAdminDAL.AddAlertHandling(objAlertHandling); } catch (Exception es) { throw es; } }
public void Updatalert(AlertHandlingUser objalert) { try { AdminDAL objAdminDAL = new AdminDAL(); objAdminDAL.Updatalert(objalert); } catch (Exception ex) { throw ex; } }
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 btnsave_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { AlertHandlingUser objAlert_Data = new AlertHandlingUser(); AdminBLL ws = new AdminBLL(); objAlert_Data.Location_id = locationId(ddllocation.Text.Trim()); objAlert_Data.Alert_ID = txtAlertid.Text.Trim(); objAlert_Data.Alert_Type = ddlAlertreason.Text.Trim(); objAlert_Data.P_Name = txtP_name.Text.Trim(); objAlert_Data.P_Nationality = txtnationality.Text.Trim(); objAlert_Data.P_NRIC_no = txtP_NricNo.Text.Trim(); objAlert_Data.P_Passport = txtP_Passport.Text.Trim(); objAlert_Data.V_Color = ""; objAlert_Data.V_OwnerName = ""; objAlert_Data.V_OwnerNricNo = ""; objAlert_Data.V_Type = ""; objAlert_Data.AlertBy_Name = txtname.Text.Trim(); objAlert_Data.AlertBy_NRICNo = txtbynric.Text.Trim(); objAlert_Data.AlertContNo = txtphone.Text.Trim(); objAlert_Data.AlertDepartment = ddlRole0.Text.Trim(); objAlert_Data.AlertDesignation = txtdesignation.Text.Trim(); objAlert_Data.Comment = txtmessage.Text.Trim(); objAlert_Data.Date_From = Convert.ToDateTime(DateTime.Now); ws.Updatalert(objAlert_Data); HttpContext.Current.Items.Add(ContextKeys.CTX_COMPLETE, "UPDATE"); Server.Transfer("..//SMSADMIN//AlertUpdateComplete.aspx"); } 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); } }