protected void grdRisks_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DoConfirm") { int userRiskId = Convert.ToInt32(e.CommandArgument); UserRisks userRisk = db.UserRisks.Where(current => current.UserRiskID == userRiskId).FirstOrDefault(); if (userRisk != null) { userRisk.IsCheckByAdmin = true; userRisk.LastModifationDate = DateTime.Now; db.SaveChanges(); GridViewDataSource(); //Checking(); } } if (e.CommandName == "DoDeny") { int userRiskId = Convert.ToInt32(e.CommandArgument); UserRisks userRisk = db.UserRisks.Where(current => current.UserRiskID == userRiskId).FirstOrDefault(); if (userRisk != null) { userRisk.IsCheckByAdmin = false; userRisk.LastModifationDate = DateTime.Now; db.SaveChanges(); //Checking(); GridViewDataSource(); } } }
private void Delete() { int RiskID = Convert.ToInt32(ViewState["RiskID"]); (from p in db.Risks where p.RiskID == RiskID select p).ToList().ForEach(db.DeleteObject); db.SaveChanges(); }
private void Delete() { int FileGroupID = Convert.ToInt32(ViewState["FileGroupID"]); (from p in db.FileGroups where p.FileGroupID == FileGroupID select p).ToList().ForEach(db.DeleteObject); db.SaveChanges(); }
private void Delete() { int EducationId = Convert.ToInt32(ViewState["EducationID"]); (from us in db.Education where us.Id == EducationId select us).ToList().ForEach(db.DeleteObject); db.SaveChanges(); }
private void Delete() { int ControlID = Convert.ToInt32(ViewState["ControlID"]); (from p in db.ControlingWorks where p.ControlID == ControlID select p).ToList().ForEach(db.DeleteObject); db.SaveChanges(); }
protected void grdUsers_RowCommand(object sender, GridViewCommandEventArgs e) { switch (e.CommandName) { case "DoEdit": { ViewState["UserID"] = Convert.ToInt32(e.CommandArgument); ViewState["EditMode"] = "Edit"; LoadForm(); pnlPassword.Visible = false; mvUsers.SetActiveView(vwEdit); break; } case "DoDelete": { ViewState["UserID"] = Convert.ToInt32(e.CommandArgument); int UserID = Convert.ToInt32(ViewState["UserID"]); ViewState["EditMode"] = "Delete"; var n = (from us in db.Users where us.UserID == UserID select us).FirstOrDefault(); lblUserDelete.Text = n.Username; mvUsers.SetActiveView(vwDelete); break; } case "DoReset": { ViewState["UserID"] = Convert.ToInt32(e.CommandArgument); int userId = Convert.ToInt32(ViewState["UserID"]); Users user = db.Users.FirstOrDefault(current => current.UserID == userId); if (user != null) { user.Password = Helper.CreateHashPassword("111111"); user.IsChangedPass = false; db.SaveChanges(); mvUsers.SetActiveView(vwResetPassword); } break; } } }
protected void btnInsert_OnClick(object sender, EventArgs e) { try { if (Page.IsValid) { if (HttpContext.Current.User.Identity.IsAuthenticated) { string userId = HttpContext.Current.User.Identity.Name; int id = Convert.ToInt32(userId); using (RiskManagementEntities db = new RiskManagementEntities()) { string password = Helper.CreateHashPassword(txtPassword.Text); Users user = db.Users .FirstOrDefault(current => current.UserID == id); user.Password = password; user.IsChangedPass = true; db.SaveChanges(); RedirectToPage(user.RoleID); } } } } catch (Exception exception) { Console.WriteLine(exception); throw; } }
private void UpdateForm() { int UserID = Convert.ToInt32(ViewState["UserID"]); using (RiskManagementEntities db = new RiskManagementEntities()) { var n = (from us in db.Users where us.UserID == UserID select us).FirstOrDefault(); if (ddlUser.SelectedValue != "-1") { n.SupervisorUserId = Convert.ToInt32(ddlUser.SelectedValue); } else { n.SupervisorUserId = null; } n.Username = txtUsername.Text; n.Password = txtPassword.Text; n.Email = txtEmail.Text; n.Name = txtName.Text; n.Family = txtFamily.Text; db.SaveChanges(); } }
private void Delete() { int UserID = Convert.ToInt32(ViewState["UserID"]); using (RiskManagementEntities db = new RiskManagementEntities()) { (from us in db.Users where us.UserID == UserID select us).ToList().ForEach(db.DeleteObject); db.SaveChanges(); } }
private void LoadForm() { int Id = Convert.ToInt32(ViewState["Id"]); var n = (from p in db.Messages where p.Id == Id select p).FirstOrDefault(); if (n != null) { lblTitle.Text = n.Subject; lblBody.Text = n.Body; n.IsRead = true; db.SaveChanges(); } ; }
protected void btnSave_OnClick(object sender, EventArgs e) { Users us = new Users() { RoleID = Convert.ToInt32(ddlRoles.SelectedValue), Username = txtUsername.Text, Password = Helper.CreateHashPassword(txtPassword.Text), Email = txtEmail.Text, Name = txtName.Text, Family = txtFamily.Text, IsChangedPass = false, SupervisorUserId = FindSupervisorUserId(), }; db.Users.AddObject(us); db.SaveChanges(); Response.Redirect("~/Admin/UserSetting.aspx"); }
protected void btnInsert_Click(object sender, EventArgs e) { int UserID = Convert.ToInt32(HttpContext.Current.User.Identity.Name); var n = (from u in db.Users where u.UserID == UserID select u).FirstOrDefault(); n.Address = txtAddress.Text; n.Email = txtEmail.Text; n.Family = txtFamily.Text; n.Name = txtName.Text; n.Phone = txtPhone.Text; n.CompanyPosition = txtPosition.Text; n.CompanyProjectName = txtProjectName.Text; db.SaveChanges(); Response.Redirect("~/Companies/Default.aspx"); }
protected void btnSave_OnClick(object sender, EventArgs e) { if (Request.QueryString["Id"] != null) { int id = Convert.ToInt32(Request.QueryString["Id"]); var n = (from us in db.Users where us.UserID == id select us).FirstOrDefault(); n.RoleID = Convert.ToInt32(ddlRoles.SelectedValue); n.Username = txtUsername.Text; n.Email = txtEmail.Text; n.Name = txtName.Text; n.Family = txtFamily.Text; n.SupervisorUserId = FindSupervisorUserId(); db.SaveChanges(); Response.Redirect("~/Admin/UserSetting.aspx"); } }
private void InsertForm() { using (RiskManagementEntities db = new RiskManagementEntities()) { Users us = new Users(); us.RoleID = 3; us.Username = txtUsername.Text; us.Password = txtPassword.Text; us.Email = txtEmail.Text; us.Name = txtName.Text; us.Family = txtFamily.Text; if (ddlUser.SelectedValue != "-1") { us.SupervisorUserId = Convert.ToInt32(ddlUser.SelectedValue); } db.Users.AddObject(us); db.SaveChanges(); } }
private void InsertForm() { if (cbAllUser.Checked == true) { var users = (from u in db.Users select u).ToList(); foreach (var user in users) { Messages p = new Messages() { Subject = txtTitle.Text, Body = txtBody.Text, SendDate = DateTime.Now, IsSendByAdmin = true, IsRead = false, UserId = user.UserID //UserId = Convert.ToInt32(ddlUser.SelectedValue) }; db.Messages.AddObject(p); } } else if (cbAllCompany.Checked == true) { var users = (from u in db.Users where u.RoleID == 2 select u).ToList(); foreach (var user in users) { Messages p = new Messages() { Subject = txtTitle.Text, Body = txtBody.Text, SendDate = DateTime.Now, IsSendByAdmin = true, IsRead = false, UserId = user.UserID //UserId = Convert.ToInt32(ddlUser.SelectedValue) }; db.Messages.AddObject(p); } } else if (cbAllSup.Checked == true) { var users = (from u in db.Users where u.RoleID == 3 select u).ToList(); foreach (var user in users) { Messages p = new Messages() { Subject = txtTitle.Text, Body = txtBody.Text, SendDate = DateTime.Now, IsSendByAdmin = true, IsRead = false, UserId = user.UserID //UserId = Convert.ToInt32(ddlUser.SelectedValue) }; db.Messages.AddObject(p); } } else { Messages p = new Messages() { Subject = txtTitle.Text, Body = txtBody.Text, SendDate = DateTime.Now, IsSendByAdmin = true, IsRead = false, UserId = Convert.ToInt32(ddlUser.SelectedValue) }; db.Messages.AddObject(p); } db.SaveChanges(); }
protected void btnInsert_Click(object sender, EventArgs e) { string script = "alert('خطا')"; try { //string QS = Request.QueryString["Id"].ToString(); int UserID = Convert.ToInt32(HttpContext.Current.User.Identity.Name); using (RiskManagementEntities db = new RiskManagementEntities()) { foreach (GridViewRow r in grdRisks.Rows) { HiddenField hfRisk = (HiddenField)(r.FindControl("hfRisk")); int RiskID = Convert.ToInt32(hfRisk.Value); DropDownList ddlProb = (DropDownList)r.FindControl("ddlProb"); DropDownList ddlInt = (DropDownList)r.FindControl("ddlInt"); int RiskIntensityID = Convert.ToInt32(ddlInt.SelectedValue); int RiskProbabilityID = Convert.ToInt32(ddlProb.SelectedValue); var n = (from ru in db.UserRisks where ru.RiskID == RiskID select ru).FirstOrDefault(); if (n == null) { UserRisks u = new UserRisks() { UserID_Company = UserID, RiskID = RiskID, RiskIntensityID_AfterCO = RiskIntensityID, RiskProbabilityID_AfterCO = RiskProbabilityID, IsCheckByAdmin = false, IsCheckBySup = false, CreationDate = DateTime.Now, StatusId = 1, }; db.UserRisks.AddObject(u); } else { //if (n.StatusId == 1) //{ n.RiskIntensityID_AfterCO = RiskIntensityID; n.RiskProbabilityID_AfterCO = RiskProbabilityID; n.LastModifationDate = DateTime.Now; //} //else //{ // script = // "alert('ریسک های این مرحله پیش از این توسط ناظر بررسی شده است و امکان تغییر وجود ندارد');"; // break; //} } script = "alert('ثبت اطلاعات با موفقیت انجام شد');"; } db.SaveChanges(); } System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Test5", script, true); } catch (Exception exception) { script = "alert('در فرآیند ثبت اطلاعات خطایی رخ داده است. لطفا مجددا اطلاعات را وارد نمایید.');"; System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Test", script, true); } }