String tovisit() { SpaMaster MyMasterPage = (SpaMaster)Page.Master; String zipRegex = "^[a-z A-Z]+$"; if (txtToVisit2.Text != "") { if (Regex.IsMatch(txtToVisit2.Text, zipRegex)) { return(txtToVisit2.Text); } else { MyMasterPage.ShowErrorMessage("Please Fill String Values ..!"); //lblerror.Visible = true; //lblerror.Text = "Please Fill String Values ..!"; //lblerr6.Visible = true; //throw new Exception(); return(""); } } else { MyMasterPage.ShowErrorMessage("Please Fill To Visit Values ..!"); //lblerror.Visible = true; //lblerror.Text = "Please Fill To Visit Values ..!"; //lblerr6.Visible = true; //throw new Exception(); return(""); } return(""); }
String tovisit() { SpaMaster SM = (SpaMaster)Page.Master; String zipRegex = "^[a-z A-Z]+$"; if (txtServingAt1.Text != "") { if (Regex.IsMatch(txtServingAt1.Text, zipRegex)) { return(txtServingAt1.Text); } else { //lblerror.Visible = true; //lblerror.Text = "Please Fill Alphabets Values ..!"; //lblerr6.Visible = true; SM.ShowErrorMessage("Please Fill Alphabets Values ..!"); throw new Exception(); } } else { //lblerror.Visible = true; //lblerror.Text = "Please Fill To Visit Values ..!"; //lblerr6.Visible = true; SM.ShowErrorMessage("Please Fill To Visit Values ..!"); throw new Exception(); } return(""); }
protected void txtaddNumberofStaff_Changed(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; if (txtNricID2.Text.Trim() != "") { SqlParameter[] para = new SqlParameter[2]; para[0] = new SqlParameter("@NRICno", SqlDbType.VarChar, 100); para[0].Value = txtNricID2.Text.Trim(); para[1] = new SqlParameter("@Role", SqlDbType.VarChar, 100); para[1].Value = txtrole.Text.Trim(); DataTable dt = dal.executeprocedure("SP_GetCheckInDetailByNRICrole", para, false); if (dt.Rows.Count > 0) { txtNricID2.Text = dt.Rows[0]["NRICno"].ToString(); txtTeleNo2.Text = dt.Rows[0]["telephone"].ToString(); txtName2.Text = dt.Rows[0]["user_name"].ToString(); txtName2.Enabled = false; txtKeyNo2.Text = dt.Rows[0]["key_no"].ToString(); txtPassNo2.Text = dt.Rows[0]["pass_no"].ToString(); image3.ImageUrl = dt.Rows[0]["ImagePath"].ToString(); txtAddress2.Text = dt.Rows[0]["user_address"].ToString(); txtCompanyFrom2.Text = dt.Rows[0]["company_from"].ToString(); txtRemarks2.Text = dt.Rows[0]["remarks"].ToString(); txtVehicleNo2.Text = dt.Rows[0]["Vehicle_No"].ToString(); txtpasstype.Text = dt.Rows[0]["pass_type"].ToString(); txtToVisit2.Text = dt.Rows[0]["to_visit"].ToString(); txtVisitorPurpose2.Text = dt.Rows[0]["purpose"].ToString(); txtItemDeclear2.Text = dt.Rows[0]["Item_Declear"].ToString(); txtcheckinTime.Text = dt.Rows[0]["Checkin_DateTime"].ToString(); Panel1.Visible = true; } else { MyMasterPage.ShowErrorMessage("NRIC/FIN No. Already Checked Out ..!"); // MyMasterPage.ShowErrorMessage("Invalid NRIC/FIN No. ..!"); //lblerror.Visible = true; //lblerror.Text = "Invalid NRIC/FIN No. ..!"; clear(); //lblerr1.Visible = true; } } else { MyMasterPage.ShowErrorMessage("Fill NRIC/FIN No. ..!"); //lblerror.Visible = true; //lblerror.Text = "Invalid NRIC/FIN No. ..!"; //lblerr1.Visible = true; } } catch (Exception ex) { logger.Info(ex.Message); } }
protected void imgUpdate_Click(object sender, EventArgs e) { SpaMaster MyMasterPage = (SpaMaster)Page.Master; log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { DataTable dtAddNewPass = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "94"); if (dtAddNewPass.Rows.Count > 0) { if (ViewState["Passid"] != null) { string _BTId = ViewState["Passid"].ToString(); string state = string.Empty; SqlDataReader rd = dal.getDataReader("select Pass_Status from Pass_Master where Pass_id ='" + _BTId + "'");//change by rakesh if (rd.Read()) { state = (rd.GetValue(0).ToString().Trim()); } rd.Close(); rd.Dispose(); if (state == "Free") { ModalPopupUpdate.Show(); fillpasstype(); PopulatePageCntrls(_BTId); //HttpContext.Current.Items.Add(ContextKeys.CTX_UPDATE_URL, Request.Url.ToString()); //HttpContext.Current.Items.Add(ContextKeys.CTX_BT_ID, _BTId); //Server.Transfer("KeyDataUpdate.aspx"); } else { MyMasterPage.ShowErrorMessage("Cannot be Edit It is Reserved ..!"); //lblerror.Visible = true; //lblerror.Text = "Can't be Edit It's Reserved ..!"; } } } else { MyMasterPage.ShowErrorMessage("You Do not Have Permission ..!"); } } catch (Exception ex) { logger.Info(ex.Message); } }
String addkey() { SpaMaster SM = (SpaMaster)Page.Master; Boolean bal = false; String ZipRegex = "^[a-z A-Z 0-9]+$"; if (txtKeyNo3.Text.Trim() != "") { if (Regex.IsMatch(txtKeyNo3.Text, ZipRegex)) { column = "Key_no"; table = "addnewKey"; where = "Where Key_no = '" + txtKeyNo3.Text + "' "; bal = b.isexistBLL(column, table, where); if (bal) { where1 = "where Key_no = '" + txtKeyNo3.Text + "' and Status='Free'"; bal = b.isexistBLL(column, table, where1); if (bal) { return(txtKeyNo3.Text); } else { //lblerror.Visible = true; //lblerror.Text = "Key No. is Occupied ..!"; //lblerr4.Visible = true; SM.ShowErrorMessage("Key No. is Occupied ..!"); throw new Exception(); } } else { //lblerror.Visible = true; //lblerror.Text = "Key No. Not Found ..!"; //lblerr4.Visible = true; SM.ShowErrorMessage("Key No. Not Found ..!"); throw new Exception(); } } else { //lblerror.Visible = true; //lblerror.Text = "Please Fill Only Numeric Values ..!"; //lblerr4.Visible = true; SM.ShowErrorMessage("Please Fill Only Numeric Values ..!"); throw new Exception(); } } return(""); }
//protected void txtnric_TextChanged(object sender, EventArgs e) //{ // try // { // SpaMaster MyMasterPage = (SpaMaster)Page.Master; // if (txtnric.Text.Trim() != "") // { // SqlParameter[] para2 = new SqlParameter[1]; // para2[0] = new SqlParameter("@NRICno", txtnric.Text.Trim()); // DataTable dsuserinfo = dal.executeprocedure("sp_FillNameByStaffId", para2, true); // if (dsuserinfo.Rows.Count > 0) // { // txtname.Text = dsuserinfo.Rows[0]["FirstName"].ToString(); // txtname.Text += " "; // txtname.Text += dsuserinfo.Rows[0]["MiddleName"].ToString(); // txtname.Text += " "; // txtname.Text += dsuserinfo.Rows[0]["LastName"].ToString(); // txtposition.Text = dsuserinfo.Rows[0]["Role"].ToString(); // //txtstffid.Text = dsuserinfo.Rows[0]["Staff_ID"].ToString(); // } // else // { // txtnric.Text = ""; // MyMasterPage.ShowErrorMessage("Invalid NRICno....!"); // //lblerror.Visible = true; // //lblerror.Text = "Invalid NRICno....!"; // // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Invalid NRICno....!');", true); // } // } // } // catch (Exception ex) // { // } //} protected void btnNewInventoryOut_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; if (ddlItemName.Text.Trim() != "" && ddlItemType.Text.Trim() != "" && txtquantity.Text.Trim() != "" && txtnric.Text.Trim() != "" && txtname.Text.Trim() != "") { string type = ddlItemType.SelectedItem.Text.ToString().Trim(); string name = ddlItemName.SelectedValue.ToString().Trim(); int currqty = 0; int oldqty = 0; currqty = Convert.ToInt32(txtquantity.Text.Trim()); int insertItemid = itemId(type, name); DataSet dsoldqty = dal.getdataset("Select Item_qty from AddNewInvetory where Item_id = '" + insertItemid + "'"); if (dsoldqty.Tables[0].Rows.Count > 0) { int newqty = 0; oldqty = Convert.ToInt32(dsoldqty.Tables[0].Rows[0]["Item_qty"].ToString().Trim()); dal.executesql("insert into NewInventory_Temp(item_Id,Item_Type,Item_Name,Item_QTY,Staff_ID,Status,Comment,Position,FromDate) values(" + insertItemid + ",'" + type + "','" + name + "','" + currqty + "','" + txtstffid.Text + "','New','" + txtComment.Text + "','" + txtposition.Text + "','" + DateTime.Now + "')"); if (oldqty > currqty) { newqty = oldqty - currqty; dal.executesql("Update AddNewInvetory set Item_qty = " + newqty + " where Item_id = '" + insertItemid + "'"); //lblerror.Visible = true; //lblerror.Text = "Inventory Out Successfully....!"; CearlAll(); MyMasterPage.ShowErrorMessage("Inventory Out Successfully....!"); BindGridTelerik(); // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Inventory Out Successfully....!');", true); } } } else { MyMasterPage.ShowErrorMessage("Please Fill All Entries....!"); //lblerror.Visible = true; //lblerror.Text = "Please Fill All Entries....!"; //ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Please Fill All Entries....!');", true); } } catch (Exception ex) { logger.Info(ex.Message); } }
protected void txtID1_TextChanged(object sender, EventArgs e) { SpaMaster SM = (SpaMaster)Page.Master; log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { String ZipRegex = "^[a-z A-Z 0-9]+$"; if (Regex.IsMatch(txtID1.Text.Trim(), ZipRegex)) { DataTable dt = dal.getdata("Select Staff_ID,ImagePathName from UserInformation where NRICno='" + txtID1.Text + "' and Role = '" + txtrole.Text + "' and Staff_ID='" + Session["StaffID1"].ToString() + "'"); SqlParameter[] para = new SqlParameter[2]; para[0] = new SqlParameter("@NRICno", SqlDbType.VarChar, 100); para[0].Value = txtID1.Text.Trim(); para[1] = new SqlParameter("@Role", SqlDbType.VarChar, 100); para[1].Value = txtrole.Text.Trim(); DataTable dt1 = dal.executeprocedure("SP_GetCheckInDetailByNRICrole", para, false); if (dt1.Rows.Count > 0) { txtID1.Text = dt1.Rows[0]["NRICno"].ToString(); txtTeleNo1.Text = dt1.Rows[0]["telephone"].ToString(); txtName1.Text = dt1.Rows[0]["user_name"].ToString(); txtcheckinTime.Text = dt1.Rows[0]["Checkin_DateTime"].ToString(); Image3.ImageUrl = dt.Rows[0]["ImagePathName"].ToString(); gvContractorTable.Visible = true; BindGridWithFilterContractor(); } else { //lblerror.Visible = true; //lblerror.Text = "Invalid NRIC/FIN No. ..!"; //lblerr1.Visible = true; SM.ShowErrorMessage("Invalid NRIC/FIN No. ..!"); } } else { //lblerror.Visible = true; //lblerror.Text = "Invalid NRIC/FIN No. ..!"; //lblerr1.Visible = true; SM.ShowErrorMessage("Invalid NRIC/FIN No. ..!"); } } catch (Exception ex) { logger.Info(ex.Message); } Page.ClientScript.RegisterStartupScript(this.GetType(), "MenuShow", "ShowManualPortion();", true); }
protected void btnSearchKeyAdd_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; if (ddlbunchno.Text != " ") { SqlParameter[] para = new SqlParameter[6]; para[0] = new SqlParameter("@Key_ID", getkeyid(ddlbunchno.Text.Trim())); para[1] = new SqlParameter("@Name", txtname.Text.Trim()); para[2] = new SqlParameter("@Designation", txtdesignation.Text.Trim()); para[3] = new SqlParameter("@Nricno", txtKeyNRIC.Text.Trim()); para[4] = new SqlParameter("@ContNo", txtphone.Text.Trim()); para[5] = new SqlParameter("@Fromdate", DateTime.Now); //para[7] = new SqlParameter("@LocationID", int.Parse(Session["LCID"].ToString())); int result = dal.executeprocedure("sp_CheckInKey", para); if (result > 0) { UpdateStatus(getkeyid(ddlbunchno.Text.Trim())); AllClear(); BindGrid(); getkeybunch("Free"); // ModalPopupAdd.Hide(); //HttpContext.Current.Items.Add("COMPLETE", "INSERT"); //Server.Transfer("../SMSAdmin/AlertUpdateComplete.aspx"); MyMasterPage.ShowErrorMessage("Record Inserted Successfully..!"); } else { MyMasterPage.ShowErrorMessage("Faild To Insert Record..!"); } } else { MyMasterPage.ShowErrorMessage("Please Add New Key Firstly."); } } catch (Exception ex) { logger.Info(ex.Message); } }
protected void btnsubmit_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; if (txtpassword.Text.Trim() != "" && txtrepassword.Text.Trim() != "") { if (txtpassword.Text.Trim() == txtrepassword.Text.Trim()) { if (Session["ManagementRole"].ToString().ToLower() == "superuser") { string staffid = txtuserid.Text; dal.executesql("Update UserInformation Set UserPassword='******' where UserId = '" + staffid + "'"); // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Password Successfully Set...!');", true); // lblerror.Text = "Password Successfully Set...!"; MyMasterPage.ShowErrorMessage("Password Successfully Set...!"); clear(); } else { string staffid = Session["StaffID"].ToString(); dal.executesql("Update UserInformation Set UserPassword='******' where Staff_ID = '" + staffid + "'"); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Password Successfully Set...!');", true); // lblerror.Text = "Password Successfully Set...!"; MyMasterPage.ShowErrorMessage("Password Successfully Set...!"); clear(); } } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Re-Confirm Password..!');", true); //lblerror.Text = "Re-Confirm Password..!"; MyMasterPage.ShowErrorMessage("Re-Confirm Password..!"); } } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Please Fill All Entries .....!');", true); // lblerror.Text = "Please Fill All Entries .....!"; MyMasterPage.ShowErrorMessage("Please Fill All Entries .....!"); } } catch (Exception ex) { logger.Info(ex.Message); } }
protected void btnDelete_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; if (!string.IsNullOrEmpty(hdnitmID.Value.ToString())) { AdminBLL ws = new AdminBLL(); DeleteInventoryRequest _req = new DeleteInventoryRequest(); _req.InventoryItemId = hdnitmID.Value.ToString(); ws.DeleteInventory(_req); ModalPopupDelete.Hide(); BindGridTelerik(); MyMasterPage.ShowErrorMessage("Record Deleted Successfully..!"); // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Record Deleted Successfully..!');", true); //HttpContext.Current.Items.Add(ContextKeys.CTX_COMPLETE, "DELETE"); //Server.Transfer("CompleteForm.aspx"); } } catch (Exception ex) { logger.Info(ex.Message); } }
private int Itemqty(string type, string name, int Newqty) { SpaMaster MyMasterPage = (SpaMaster)Page.Master; int ItemID = 0; int Oldqty = 0; int bothqty = 0; int nwqty = Newqty; DataSet dsItemdqty = Dal.getdataset("Select Item_id,Item_qty from AddNewInvetory where Item_Type='" + type + "' and Item_Name ='" + name + "' "); if (dsItemdqty.Tables[0].Rows.Count > 0) { ItemID = Convert.ToInt32(dsItemdqty.Tables[0].Rows[0][0].ToString().Trim()); Oldqty = Convert.ToInt32(dsItemdqty.Tables[0].Rows[0][1].ToString().Trim()); bothqty = Oldqty + nwqty; Dal.executesql("Update AddNewInvetory Set Item_qty ='" + bothqty + "' where Item_id ='" + ItemID + "' "); ClearAll(); MyMasterPage.ShowErrorMessage("Record Inserted SuccessFully"); // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Record Inserted SuccessFully');", true); BindGridTelerik(); //HttpContext.Current.Items.Add("COMPLETE", "INSERT"); //Server.Transfer("CompleteForm.aspx"); } return(nwqty); }
protected void Deletepopup_Yes_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { if (ViewState["Event_ID"] != null) { DeleteItem(ViewState["Event_ID"].ToString()); // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Record Delete SuccessFully');", true); SpaMaster MyMasterPage = (SpaMaster)Page.Master; MyMasterPage.ShowErrorMessage("Record Deleted SuccessFully..!"); BindGridWithFilter(); ViewState["Event_ID"] = null; ModalPopupDelete.Hide(); } } catch (Exception ex) { logger.Info("AdminCappAsset(AssertImgUpdate_Click):" + ex.Message); } }
private void checkTime() { SpaMaster MyMasterPage = (SpaMaster)Page.Master; DBConnectionHandler1 db = new DBConnectionHandler1(); SqlConnection cn = db.getconnection(); cn.Open(); SqlCommand cmd = new SqlCommand("select checkin_DateTime,user_name from checkin_manager where NRICno=@NRICno", cn); cmd.Parameters.AddWithValue("@NRICno", txtNricID2.Text); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { DateTime currentTime = DateTime.Now; DateTime DbTime = dr.GetDateTime(0); double diff = (currentTime - DbTime).TotalHours; if (diff > 6) { Label1.Visible = true; MyMasterPage.ShowErrorMessage("Your Time is Over..."); ////Label1.Text = "Your Time is Over..."; //string Msg = "<script>confirm('Time Over');</script>"; //ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "confirm", Msg, false); } } //========================// dr.Close(); dr.Dispose(); cn.Close(); //========================// }
protected void ImgUpdate_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; DataTable dtViewEvents = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "23"); if (dtViewEvents.Rows.Count > 0) { if (ViewState["Event_ID"] != null) { Fill(); this.ModalPopupUpdate.Show(); } } else { MyMasterPage.ShowErrorMessage("You Do Not Have permission..!"); } } catch (Exception ex) { logger.Info("AdminCappAsset(AssertImgUpdate_Click):" + ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { SpaMaster SM = (SpaMaster)Page.Master; log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { lblerror.Visible = false; lblerr1.Visible = false; txtNricID2.Focus(); gvContractorTable.Visible = false; } catch (Exception ex) { logger.Info(ex.Message); } if (Session["LCID"] != null) { // objchickin.LocationID = int.Parse(Session["LCID"].ToString()); // Location = Session["LCID"].ToString(); } else { SM.ShowErrorMessage("Please select Location first!!!"); //lblerror.Visible = true; //lblerror.Text = "Please select Location first!!!"; } }
String PassOccupied() { SpaMaster SM = (SpaMaster)Page.Master; string passvalue = txtPassNo3.Text.Trim(); if (txtPassNo3.Text.Trim() != "") { //string passvalue = Addpass(); column = "Pass_No"; table = "checkin_manager"; where = "Where Pass_No = '" + passvalue + "' "; if (b.isexistBLL(column, table, where)) { //lblerror.Visible = true; //lblerror.Text = "Pass No. is Occupied ..!"; //lblerr2.Visible = true; SM.ShowErrorMessage("Pass No. is Occupied ..!"); throw new Exception(); } return(passvalue); } return(passvalue); }
protected void btnAssignmentAdd_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; SqlParameter[] para = new SqlParameter[9]; para[0] = new SqlParameter("@Location", ddlLocationAdd.Text.Trim()); para[1] = new SqlParameter("@CompletedBy", txtCompletedByAdd.Text.Trim()); para[2] = new SqlParameter("@Date", txtdatefromAdd.Text.Trim()); para[3] = new SqlParameter("@ClientName", txtClientName.Text.Trim()); para[4] = new SqlParameter("@Complaints", txtcomplaints.Text.Trim()); para[5] = new SqlParameter("@PositiveComment", txtpositivecomments.Text.Trim()); para[6] = new SqlParameter("@Deployment", txtdeployment.Text.Trim()); para[7] = new SqlParameter("@UpcomingEvent", txtupcomingevent.Text.Trim()); para[8] = new SqlParameter("@Remarks", txtremarks.Text.Trim()); dal.executeprocedure("SP_AddClientVisitMinutes", para); HttpContext.Current.Items.Add("COMPLETE", "INSERT"); // Server.Transfer("CompleteForm.aspx"); MyMasterPage.ShowErrorMessage("Record Insert SuccessFully"); //dal.executesql("Update PreRegisteredVisits set FromDate='" + txtFromDate.Text.Trim() + "',ToDate='" + txtToDate.Text.Trim() + "',ExpectedTime='" + newtime + "',Name='" + txtName.Text.Trim() + "',Company='" + txtCompany.Text.Trim() + "',Position='" + txtPosition.Text.Trim() + "',Invited_By='" + txtInvitedBy.Text.Trim() + "',LocationID='" + Searchid.Text + "',VechicleNo='" + txtVechicle.Text + "',Purpose='" + txtpurpose.Text + "',Telephoe='"+txttelephone.Text+"' where PRVID ='" + hdnCSID.Value + "' "); // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Record Insert SuccessFully');", true); BindGrid(); ClearAdd(); } catch (Exception ex) { logger.Info(ex.Message); } }
protected void btnDelete_Click(object sender, EventArgs e) { string argitemid = hdnitmID.Value.ToString(); log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; if (!string.IsNullOrEmpty(argitemid)) { DataAccessLayer dal = new DataAccessLayer(); dal.executesql("delete from Shift_Master where shift_ID=" + argitemid); BindGridTelerik(); ModalPopupDelete.Hide(); MyMasterPage.ShowErrorMessage("Record Deleted Successfully"); // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Record Deletd Submitted..!');", true); //HttpContext.Current.Items.Add(ContextKeys.CTX_COMPLETE, "DELETE"); //Server.Transfer("CompleteForm.aspx"); } } catch (Exception ex) { logger.Info(ex.Message); } }
protected void Button1_Click(object sender, EventArgs e) { SpaMaster MyMasterPage = (SpaMaster)Page.Master; log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { dal.executesql("delete from RoleMenuMap where RoleID=" + tvRoleHierarchy.SelectedValue); foreach (TreeNode tn in tvFunctions.Nodes) { if (tn.ChildNodes.Count > 0) { AssignCheckedMenus(tn); } else { if (tn.Checked) { dal.executesql("insert into RoleMenuMap (RoleID,MenuID) values (" + tvRoleHierarchy.SelectedNode.Value + "," + tn.Value + ")"); } } } MyMasterPage.ShowErrorMessage("Permission has been Successfully assigned!!"); //lblerror.Text = "Permission has been Successfully assigned!!"; // Server.Transfer("~//SMSADMIN//AlertUpdateComplete.aspx"); } catch (Exception ex) { logger.Info(ex.Message); } }
protected void imgUpdate_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; DataTable dtViewItems = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "97"); if (dtViewItems.Rows.Count > 0) { if (ViewState["AddItem_ID"] != null) { string _BTId = ViewState["AddItem_ID"].ToString(); PopulatePageCntrls(_BTId); ModalPopupupdate.Show(); } } else { MyMasterPage.ShowErrorMessage("You Do not Have Permission..!"); } } catch (Exception ex) { logger.Info(ex.Message); } }
private void DeleteItem() { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { if (!string.IsNullOrEmpty(ViewState["Alert_ID"].ToString().Trim())) { //AdminBLL ws = new AdminBLL(); //DeleteAlertRequest _req = new DeleteAlertRequest(); //_req.Alert_ID = ViewState["Alert_ID"].ToString().Trim(); //ws.DeleteAlert(_req); string argId1 = ViewState["Alert_ID"].ToString().Trim(); dal.executesql("Delete From Alert_Handling Where Alert_ID='" + argId1 + "' "); // HttpContext.Current.Items.Add(ContextKeys.CTX_COMPLETE, "DELETE"); SpaMaster MyMasterPage = (SpaMaster)Page.Master; MyMasterPage.ShowErrorMessage("Record Delete sucessfully ..!"); ModalPopupDelete.Hide(); ModalPopupDelete.Hide(); BindGridWithFilter(); } } catch (Exception ex) { logger.Info(ex.Message); } }
protected void txtnric_TextChanged(object sender, EventArgs e) { try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; if (txtnric.Text.Trim() != "") { SqlParameter[] para2 = new SqlParameter[1]; para2[0] = new SqlParameter("@NRICno", txtnric.Text.Trim()); DataTable dsuserinfo = dal.executeprocedure("sp_FillNameByStaffId", para2, true); if (dsuserinfo.Rows.Count > 0) { txtname.Text = dsuserinfo.Rows[0]["FirstName"].ToString(); txtname.Text += " "; txtname.Text += dsuserinfo.Rows[0]["MiddleName"].ToString(); txtname.Text += " "; txtname.Text += dsuserinfo.Rows[0]["LastName"].ToString(); txtposition.Text = dsuserinfo.Rows[0]["Role"].ToString(); //txtstffid.Text = dsuserinfo.Rows[0]["Staff_ID"].ToString(); } else { txtnric.Text = ""; MyMasterPage.ShowErrorMessage("Invalid NRICno....!"); //lblerror.Visible = true; //lblerror.Text = "Invalid NRICno....!"; // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Invalid NRICno....!');", true); } } } catch (Exception ex) { } }
protected void lnkViewKey_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; DataTable dtAddNewKey = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "89"); DataTable dtViewKey = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "90"); if (dtAddNewKey.Rows.Count > 0) { Response.Redirect("../SMSAdmin/AddNewKey.aspx"); } else if (dtViewKey.Rows.Count > 0) { Response.Redirect("../SMSAdmin/AddNewKey.aspx"); } else { MyMasterPage.ShowErrorMessage("You Don not Have Permission..!"); } } catch (Exception ex) { logger.Info(ex.Message); } }
protected void imgDelete_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; // SpaMaster MyMasterPage = (SpaMaster)Page.Master; DataTable dtAddNewPass = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "90"); if (dtAddNewPass.Rows.Count > 0) { if (ViewState["KeyID"] != null) { ModalPopupDeleteimage.Show(); } } else { MyMasterPage.ShowErrorMessage("You Do not Have Permission..!"); } } catch (Exception ex) { logger.Info(ex.Message); } }
protected void txtNricID3_TextChanged(object sender, EventArgs e) { SpaMaster SM = (SpaMaster)Page.Master; log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SqlDataReader rd = dal.getDataReader("select Top 1 NRICno,FirstName,Staff_TelPhone,ImagePathName from UserInformation where NRICno='" + txtNricID3.Text + "' and Role='" + txtrole.Text + "' and Staff_ID='" + Session["StaffID1"].ToString() + "'"); if (rd.HasRows) { if (rd.Read()) { txtNricID3.Text = rd.GetValue(0).ToString(); txtName3.Text = rd.GetValue(1).ToString(); txtTeleNo3.Text = rd.GetValue(2).ToString(); Image3.ImageUrl = rd.GetValue(3).ToString(); } rd.Close(); gvContractorTable.Visible = true; BindGridWithFilterStaff(); } else { //lblerror.Visible = true; //lblerror.Text = "Invalid NRIC/FIN No. ..!"; //lblerr1.Visible = true; SM.ShowErrorMessage("Invalid NRIC/FIN No. ..!"); } } catch (Exception ex) { logger.Info(ex.Message); } Page.ClientScript.RegisterStartupScript(this.GetType(), "MenuShow", "ShowManualPortion();", true); }
protected void BtnUpload_Click1(object sender, EventArgs e) { SpaMaster MyMasterPage = (SpaMaster)Page.Master; if (FileUpload1.PostedFile.FileName != "") { ImgUpload.Visible = true; string file = FileUpload1.PostedFile.FileName; string filename = Path.GetFileName(FileUpload1.FileName); thubpath = ("/Images" + "/" + filename);//Chnages According to Requirement Logic //thubpathMaster=("master/Images"+"/"+filename);//According to Requirement FileUpload1.PostedFile.SaveAs(Server.MapPath("Images/") + filename); //FileUpload1.PostedFile.SaveAs(Server.MapPath("master/Images/") + filename);//According to Requirement ImgUpload.ImageUrl = thubpath; TextBox1.Text = thubpath; TextBox2.Text = Server.MapPath(thubpath).Trim(); BtnSave.Visible = true; } else { ImgUpload.Visible = false; MyMasterPage.ShowErrorMessage("Please choose a file."); //lblErr.Visible = true; //lblErr.Text = "Please choose a file!!!"; } }
protected void imdAdd_Click(object sender, EventArgs e) { SpaMaster MyMasterPage = (SpaMaster)Page.Master; DataTable dtAddNewPass = AdminDAL.Checkmenu(Session["RoleID"].ToString(), "93"); if (dtAddNewPass.Rows.Count > 0) { getPassTypeAdd("passtype"); if (Session["ManagementRole"].ToString().ToLower() == "superuser") { getLocationName(); } else { getLocationNameById(Session["LCID"].ToString()); } ModalPopupAdd.Show(); } else { MyMasterPage.ShowErrorMessage("You Don not Have Permission ..!"); } }
//private void fillAlertType() //{ // ddlAlertType.Items.Clear(); // ddlAlertType.Items.Add(" "); // string ID = "alerttype"; // SqlParameter[] para1 = new SqlParameter[1]; // para1[0] = new SqlParameter("@ID", ID); // DataTable dt = dal.executeprocedure("sp_getLogvaluebyID", para1, true); // if (dt.Rows.Count > 0) // { // for (int k = 0; k < dt.Rows.Count; k++) // { // ddlAlertType.Items.Add(dt.Rows[k][0].ToString()); // } // } //} private void DeleteItem(string argalertid) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; if (!string.IsNullOrEmpty(argalertid)) { AdminBLL ws = new AdminBLL(); DeleteAlertRequest _req = new DeleteAlertRequest(); _req.Alert_ID = argalertid.ToString(); ws.DeleteAlert(_req); MyMasterPage.ShowErrorMessage("Record Deleted Successfully..!"); ModalPopupDelete.Hide(); } } catch (Exception ex) { logger.Info(ex.Message); } }
protected void btnAssignSites_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; if (ddlUser.SelectedValue != "0") { string LocationIDs = ""; foreach (GridViewRow gr in grdLocations.Rows) { if (((CheckBox)gr.Cells[0].FindControl("chkSite")).Checked) { LocationIDs += ((CheckBox)gr.Cells[0].FindControl("chkSite")).ToolTip + ","; } } string StaffID = ddlUser.SelectedValue; if (StaffID.ToString() != "") { LocationIDs = LocationIDs.Substring(0, LocationIDs.Length - 1); SqlParameter[] para = new SqlParameter[2]; dal.executesql("Delete from StaffLocationMap where StaffID = '" + StaffID + "'"); para[0] = new SqlParameter("@StaffID", StaffID); para[1] = new SqlParameter("@LocationIDs", LocationIDs); dal.executeprocedure("usp_AssignLocatiosToStaffs", para); MyMasterPage.ShowErrorMessage("Locations Have Been Assigned Successfully !"); // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Locations Have Been Assigned Successfully !');", true); // lblerror.Text = "Locations Have Been Assigned Successfully !"; } else { MyMasterPage.ShowErrorMessage("Please Select User!"); //lblerror.Text = "Please Select User!"; // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Please Select User!');", true); } } } catch (Exception ex) { logger.Info(ex.Message); } }
protected void btnSave_Click(object sender, EventArgs e) { log4net.ILog logger = log4net.LogManager.GetLogger("File"); try { SpaMaster MyMasterPage = (SpaMaster)Page.Master; AddNewInventory objInventory_Data = new AddNewInventory(); AdminBLL ws = new AdminBLL(); if (txtItemNameupd.Text.Trim() != "") { objInventory_Data.Item_id = txtItemID.Text.Trim(); objInventory_Data.Item_Name = txtItemNameupd.Text.Trim(); objInventory_Data.Item_qty = txtqunatityupd.Text.Trim(); objInventory_Data.CreatedBy = txtCreatedByupd.Text.Trim(); objInventory_Data.Item_Type = ddItemTypeupdate.Text.Trim(); objInventory_Data.CreatedTime = Convert.ToDateTime(txtCreatedTime.Text.Trim()); objInventory_Data.EditBy = txtEditBy.Text.Trim(); if (txtCreatedBy.Text.Trim() != "") { objInventory_Data.EditTime = DateTime.Now; } ws.UpdateInventoryData(objInventory_Data); BindGridTelerik(); MyMasterPage.ShowErrorMessage("Record Updated Successfully..!"); // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Record Updated Successfully..!');", true); ModalPopupUpdate.Hide(); //HttpContext.Current.Items.Add(ContextKeys.CTX_COMPLETE, "UPDATE"); //Server.Transfer("CompleteForm.aspx"); } else { MyMasterPage.ShowErrorMessage("Invalid Item Name ..!"); //lblErrMsg.Visible = true; //lblErrMsg.Text = "Invalid Item Name ..!"; //ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "AlertMessage", " alert('Invalid Item Name ..!');", true); } } catch (Exception ex) { logger.Info(ex.Message); } }