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