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;
}
}
