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(); } } }
protected void grdTable_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { HiddenField hfUserRiskID = (HiddenField)e.Row.FindControl("hfUserRiskID"); int userRiskID = int.Parse(hfUserRiskID.Value.ToString()); UserRisks userRisk = db.UserRisks.Where(u => u.UserRiskID == userRiskID).FirstOrDefault(); if (userRisk.StatusId == 1) { e.Row.BackColor = System.Drawing.Color.LightBlue; } else if (userRisk.StatusId == 2) { e.Row.BackColor = System.Drawing.Color.LightGreen; } else if (userRisk.StatusId == 3) { e.Row.BackColor = System.Drawing.Color.OrangeRed; } else if (userRisk.StatusId == 4) { e.Row.BackColor = System.Drawing.Color.LightGray; } } }
private void LoadLabels(int userRiskId) { UserRisks userRisk = db.UserRisks.Where(current => current.UserRiskID == userRiskId).FirstOrDefault(); Risks risk = db.Risks.Where(current => current.RiskID == userRisk.RiskID && current.IsAcceptedByAdmin == true).FirstOrDefault(); Stages stage = db.Stages.Where(current => current.StageID == risk.StageID).FirstOrDefault(); Acts act = db.Acts.Where(current => current.ActID == stage.ActID).FirstOrDefault(); Operations operation = db.Operations.Where(current => current.OperationID == act.OperationID).FirstOrDefault(); OperationGroups operationGroup = db.OperationGroups.Where(current => current.OperationGroupID == operation.OperationGroupID).FirstOrDefault(); lblProject.Text = operationGroup.OperationGroupTitle; lblOperation.Text = operation.OperationTitle; lblAct.Text = act.ActTitle; lblStage.Text = stage.StageTitle; ViewState["stageId"] = stage.StageID; LoadRiskgrd(stage.StageID); }
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); } }