public bool InsertWOroles(int worl_WOnum, int worl_uid, string worl_proj, string worl_role, bool worl_aprvl, bool worl_email) { WorkOrder.WOroleDataTable RolesDT = new WorkOrder.WOroleDataTable(); WorkOrder.WOroleRow roleRow = RolesDT.NewWOroleRow(); int indexnum = Convert.ToInt32(RolesAdapter.MaxRoleIndexNum()); if (indexnum == null) { indexnum = 1; } else { indexnum++; } roleRow.worl_index = indexnum; roleRow.worl_WOnum = worl_WOnum; roleRow.worl_proj = worl_proj; roleRow.worl_uid = worl_uid; roleRow.worl_role = worl_role; roleRow.worl_aprvl = Convert.ToBoolean(worl_aprvl); roleRow.worl_email = Convert.ToBoolean(worl_email); RolesDT.AddWOroleRow(roleRow); int rowsAffected = RolesAdapter.Update(RolesDT); return(rowsAffected == 1); }
public bool UpdateRoles(int worl_WOnum, string worl_proj, int worl_uid, string worl_role, bool worl_aprvl, int Original_worl_index, bool worl_email) { int worl_index = Original_worl_index; WorkOrder.WOroleDataTable roles = RolesAdapter.GetRoleByIndexNum(Original_worl_index); WorkOrder.WOroleRow roleRow = roles[0]; int rowsAffected = RolesAdapter.UpdateRoles(worl_index, roleRow.worl_WOnum, roleRow.worl_proj, roleRow.worl_uid, roleRow.worl_role, worl_aprvl, worl_email, Original_worl_index); return(rowsAffected == 1); }
protected void Page_Load(object sender, EventArgs e) { ScriptManager SM = ((ScriptManager)(Master.FindControl("ScriptManager1"))); SM.RegisterAsyncPostBackControl(btnAddParticipant); SM.RegisterAsyncPostBackControl(FormView2); WorkOrderBLL woLogic = new WorkOrderBLL(); WorkOrder.WorkOrderDataTable WrkOrds = woLogic.GetWorkOrdersByWOnumProj(Convert.ToInt32(Request.QueryString["word_WOnum"]), Request.QueryString["word_Proj"].ToString()); WorkOrder.WorkOrderRow WrkOrd = WrkOrds[0]; ls_proj = Request.QueryString["word_Proj"]; li_wonum = Convert.ToInt32(Request.QueryString["word_WOnum"]); RolesBLL roleLogic = new RolesBLL(); if (!IsPostBack) { if ((WrkOrd.word_Status == "IMPL" && WrkOrd.word_statFlag == 1) || (WrkOrd.word_Status == "GONG")) // && { if (!(WrkOrd.word_Status == "GONG" && roleLogic.IsUserApprover(Convert.ToInt32(User.Identity.Name.Substring(User.Identity.Name.IndexOf("\\") + 1)), li_wonum, ls_proj))) // AND IsUserPMorUp?RoleBLL { FormView1.DefaultMode = FormViewMode.ReadOnly; FormView1.DataSourceID = ObjectDataSource2.ID; FormView1.DataBind(); ddlParticipant.Enabled = false; ddlParticipant.Visible = false; ddlRole.Enabled = false; ddlRole.Visible = false; btnAddParticipant.Visible = false; lblParticipant.Visible = false; lblRole.Visible = false; GridView2.Enabled = false; GridView2.Visible = false; ((LinkButton)(FormView1.FindControl("RespondButton"))).Visible = false; } else { ((LinkButton)(FormView1.FindControl("Approvals"))).Visible = true; } } bool lb_rtn = false; WorkOrderTableAdapters.WOroleTableAdapter roleAdapter = new WorkOrderTableAdapters.WOroleTableAdapter(); WorkOrder.WOroleDataTable roleDT = roleAdapter.GetWOroleByWOproj(li_wonum, ls_proj); foreach (DataRow roleRow in roleDT) { if (roleRow["worl_uid"].ToString() == WrkOrd.word_Author.ToString()) { lb_rtn = true; break; } } if (!lb_rtn) { lb_rtn = roleLogic.InsertWOroles(li_wonum, Convert.ToInt32(WrkOrd.word_Author), ls_proj, "AUTH", false, true); } lb_rtn = false; foreach (DataRow roleRow in roleDT) { if (roleRow["worl_uid"].ToString() == WrkOrd.word_BusnOwner.ToString()) { lb_rtn = true; break; } } if (!lb_rtn) { lb_rtn = roleLogic.InsertWOroles(li_wonum, Convert.ToInt32(WrkOrd.word_BusnOwner), ls_proj, "BOWN", false, true); } lb_rtn = false; foreach (DataRow roleRow in roleDT) { if (roleRow["worl_uid"].ToString() == WrkOrd.word_PMorSME.ToString()) { lb_rtn = true; break; } } if (!lb_rtn) { lb_rtn = roleLogic.InsertWOroles(li_wonum, Convert.ToInt32(WrkOrd.word_PMorSME), ls_proj, "PM", false, true); } lb_rtn = false; //GridView2.DataBind(); } woResponseBLL responseLogic = new woResponseBLL(); if (responseLogic.GetWOresponseCountByWOandProj(li_wonum, ls_proj) > 0) { FormView2.Visible = true; } else { FormView2.Visible = false; } }