protected void FormView1_ItemInserted(object sender, FormViewInsertedEventArgs e)
{
int rws = e.AffectedRows;
woPhaseBLL woPhaseLogic = new woPhaseBLL();
WorkOrderBLL woLogic = new WorkOrderBLL();
int wonum = (woLogic.GetMaxWOnum(e.Values[3].ToString()) - 1);
bool lb_rtn;
//SmtpEmail mailMessage = new SmtpEmail();
//bool lb_rtn = mailMessage.Send(e.Values["word_Author"].ToString(), e.Values["word_PMorSME"].ToString(), "Work Order Creation - " + e.Values[3].ToString()
// + " WO# " + wonum + " - " + e.Values["word_Title"].ToString(),
// "WO# " + wonum + " - " + e.Values["word_Title"].ToString() + " requires your attention." +
// " Log into the EBS Work Order Module for details. Please do not respond to this email.", wonum, 0, e.Values["word_Proj"].ToString());
// Insert a WOphase record, update the WOrole table and update the WorkOrder table record as well.
WorkOrder.WorkOrderDataTable WrkOrds = woLogic.GetWorkOrdersByWOnumProj(wonum, e.Values["word_Proj"].ToString());
WorkOrder.WorkOrderRow WrkOrd = WrkOrds[0];
int PhaseNum = woPhaseLogic.InsertPhaseRecord(wonum, WrkOrd.word_Proj, 0, DateTime.Now,
"IWOR", 0, Convert.ToInt32(User.Identity.Name.Substring(User.Identity.Name.IndexOf("\\") + 1)));
RolesBLL roleLogic = new RolesBLL();
lb_rtn = roleLogic.InsertWOroles(wonum, Convert.ToInt32(WrkOrd.word_Author), WrkOrd.word_Proj, "AUTH", false, true);
lb_rtn = roleLogic.InsertWOroles(wonum, Convert.ToInt32(WrkOrd.word_BusnOwner), WrkOrd.word_Proj, "BOWN", false, true);
lb_rtn = roleLogic.InsertWOroles(wonum, Convert.ToInt32(WrkOrd.word_PMorSME), WrkOrd.word_Proj, "PM", false, true);
DataView dv = (DataView)ObjectDataSource1.Select();
DataRow dr = (DataRow)dv.Table.Rows[0];
FormView fv = sender as FormView;
if (fv.CurrentMode == FormViewMode.Insert)
{
DropDownList DropDownListPhaseStat = (DropDownList)fv.Row.FindControl("DropDownListPhaseStat");
int PhaseStat = Convert.ToInt32(DropDownListPhaseStat.SelectedValue);
if (PhaseStat == 1)
{
int PhaseNumb = woPhaseLogic.InsertPhaseRecord(wonum, WrkOrd.word_Proj, 0, DateTime.Now,
"WORA", 0, Convert.ToInt32(User.Identity.Name.Substring(User.Identity.Name.IndexOf("\\") + 1)));
WrkOrd.word_Status = "WORA";
WrkOrd.word_statFlag = 0;
WrkOrd.word_StatNum = PhaseNumb;
//DateTimePicker DTimePicker = (DateTimePicker)fv.Row.FindControl("CalendarExtender1");
//string ls_val = DTimePicker.Value.ToString();
//TextBox TxtBxReqDate = (TextBox)fv.Row.FindControl("word_reqDueDateTextBox");
//TxtBxReqDate.Text = ls_val;
//WrkOrd.word_reqDueDate = Convert.ToDateTime(DTimePicker.Value.ToString());
lb_rtn = woLogic.UpdateWorkOrder(WrkOrd.word_WOnum, WrkOrd.word_Proj, WrkOrd.word_StatNum,
WrkOrd.word_Status, WrkOrd.word_statFlag, WrkOrd.word_Date, WrkOrd.word_Author,
WrkOrd.word_Title, WrkOrd.word_Doc.ToString(), WrkOrd.word_DocVer.ToString(), WrkOrd.word_Priority,
WrkOrd.word_Descr, WrkOrd.word_Justify, WrkOrd.word_Cmnts, WrkOrd.word_PMorSME,
WrkOrd.word_BusnOwner, WrkOrd.word_reqDueDate, WrkOrd.word_WOnum, WrkOrd.word_Proj);
}
}
Response.Redirect("~/WorkOrder/Default.aspx?word_Proj=" + WrkOrd.word_Proj.ToString());
}