protected void btnUpload_Click(object sender, EventArgs e) { try { using (CsvReader csv = new CsvReader(new StreamReader(fileUpload.FileContent), true)) { int count = 0; DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter orderTA = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); while (csv.ReadNextRecord()) { string fullAddress = csv[0] + csv[1] + csv[2] + csv[3] + csv[4] + csv[5]; IEnumerator iEnumerator = orderTA.InsertAndReturn(false, (int)Session[WebConstants.Session.REG_DEPT_ID], (int)Session[WebConstants.Session.REG_CO_ID], WebConstants.Default.NOT_SET, WebConstants.Default.NOT_SET, WebConstants.Default.NOT_SET, DateTime.Now, 0, DateTime.Now.AddYears(1), false, "", csv[0], csv[1], csv[2], csv[3], csv[4], csv[5], fullAddress, "", false, false, false, null, null, null, null, (int)Session[WebConstants.Session.REG_USER_ID], DateTime.Now, (int)Session[WebConstants.Session.REG_USER_ID], DateTime.Now).GetEnumerator(); if (iEnumerator.MoveNext()) { count++; } } SetInfoMessage(count + " folders added to the system."); } } catch { SetErrorMessage("Error processing the file. Please check its contents. File should be CSV and in the format shown below"); } }
protected void btnNext_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(this.tbAssembleHeader.Text)) { Company.un_co_detailsRow dr = GetCompany(); if (dr != null && dr.Isflg_autosaveNull() == false && dr.flg_autosave) { if (isValidAssemble(tbAssembleHeader.Text)) { int deptId = int.Parse(hfDeptId.Value); int deptOrderId = int.Parse(Request[WebConstants.Request.DEPT_ORDER_ID]); DepartmentOrderDetailTableAdapters.DepartmentOrderAssemblePtTableAdapter tableAdapter = new DepartmentOrderDetailTableAdapters.DepartmentOrderAssemblePtTableAdapter(); tableAdapter.Insert(deptId, loggedInUserCoId, deptOrderId, tbAssembleHeader.Text, tbAssembleDesc.Text, loggedInUserId); if (tableAdapter.GetAllAssemblePts(deptId, loggedInUserCoId, deptOrderId).Rows.Count > 1) { DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter orderTA = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); orderTA.UpdateMultiAssemblePoints(true, loggedInUserId, deptOrderId); } Response.Redirect("~/Orders/AddOrderRequirements.aspx?" + WebConstants.Request.DEPT_ORDER_ID + "=" + Request[WebConstants.Request.DEPT_ORDER_ID]); } } else SetErrorMessage(WebConstants.Messages.Error.NEXT_WARNING_COMPANYAUTOSAVE); } else if (this.gvAssemble.Rows.Count > 0) { Response.Redirect("~/Orders/AddOrderRequirements.aspx?" + WebConstants.Request.DEPT_ORDER_ID + "=" + Request[WebConstants.Request.DEPT_ORDER_ID]); } else SetErrorMessage(WebConstants.Messages.Error.NEXT_WARNING_ENTERRECORD); }
public static DepartmentOrder.DepartmentOrderRowRow GetDepartmentOrder(int deptOrderId) { DepartmentOrder.DepartmentOrderRowRow dataRow = null; DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter da = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); IEnumerator iEnumerator = da.GetDepartmentOrderById(deptOrderId).GetEnumerator(); if (iEnumerator.MoveNext()) { dataRow = (DepartmentOrder.DepartmentOrderRowRow)iEnumerator.Current; } return dataRow; }
protected void btnSave_Click(object sender, EventArgs e) { setDefaultValues(); DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter da = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); IEnumerator iEnumerator = da.InsertAndReturn(false, int.Parse(ddlDepartment.SelectedValue), loggedInUserCoId, tbOrderRef.Text, tbOrderClientRef.Text, tbOrderSMS.Text, getCreatedDate(), getEstWork(), getReviewDate(), cbDocClient.Checked, tbAddressNo.Text, tbAddress1.Text, tbAddress2.Text, tbAddress3.Text, tbAddress4.Text, tbAddress5.Text, tbPostalCode.Text, getFullAddress(), tbDesc.Text, cbMultiEmerExits.Checked, cbAssemPts.Checked, false, null,tbDescOfWork.Text,getEstNumOfOperatives(),ddlRiskTaking.SelectedValue, loggedInUserId, DateTime.Now, loggedInUserId, DateTime.Now).GetEnumerator(); if (iEnumerator.MoveNext()) { DepartmentOrder.DepartmentOrderRowRow dataRow = (DepartmentOrder.DepartmentOrderRowRow)iEnumerator.Current; Response.Redirect("~/Orders/AddOrderPeople.aspx?" + WebConstants.Request.DEPT_ORDER_ID + "=" + dataRow.sequence); } }
protected void btnAddExit_Click(object sender, EventArgs e) { if (isValidExit(tbExitHeader.Text)) { int deptId = (int)Session[WebConstants.Session.DEPT_ID]; int deptOrderId = int.Parse(Request[WebConstants.Request.DEPT_ORDER_ID]); DepartmentOrderDetailTableAdapters.DepartmentOrderEmergencyExitTableAdapter tableAdapter = new DepartmentOrderDetailTableAdapters.DepartmentOrderEmergencyExitTableAdapter(); tableAdapter.Insert(deptId,loggedInUserCoId,deptOrderId, tbExitHeader.Text, "", loggedInUserId); if (tableAdapter.GetAllEmergencyExits(deptId, loggedInUserCoId, deptOrderId).Rows.Count > 1) { DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter orderTA = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); orderTA.UpdateMultiEmergencyExits(true, loggedInUserId, deptOrderId); } gvExit.DataBind(); tbExitHeader.Text = ""; } }
protected void btnAddAssemble_Click(object sender, EventArgs e) { if (isValidAssemble(tbAssembleHeader.Text)) { int deptId = int.Parse(hfDeptId.Value); int deptOrderId = int.Parse(Request[WebConstants.Request.DEPT_ORDER_ID]); DepartmentOrderDetailTableAdapters.DepartmentOrderAssemblePtTableAdapter tableAdapter = new DepartmentOrderDetailTableAdapters.DepartmentOrderAssemblePtTableAdapter(); tableAdapter.Insert(deptId, loggedInUserCoId, deptOrderId, tbAssembleHeader.Text, tbAssembleDesc.Text, loggedInUserId); if (tableAdapter.GetAllAssemblePts(deptId, loggedInUserCoId, deptOrderId).Rows.Count > 1) { DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter orderTA = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); orderTA.UpdateMultiAssemblePoints(true, loggedInUserId, deptOrderId); } gvAssemble.DataBind(); tbAssembleHeader.Text = ""; tbAssembleDesc.Text = ""; btnAddAssemble.Focus(); } }
protected void btnUpload_Click(object sender, EventArgs e) { using (CsvReader csv = new CsvReader(new StreamReader(fileUpload.FileContent), true)) { int count = 0; DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter orderTA = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); int fieldCount = csv.FieldCount; string[] headers = csv.GetFieldHeaders(); while (csv.ReadNextRecord()) { string fullAddress = csv["address_line1"] + " " + csv["address_line2"] + csv["address_line3"] + csv["address_line4"] + csv["address_line5"] + csv["address_post_code"]; IEnumerator iEnumerator = orderTA.InsertAndReturn(false, int.Parse(ddlDepartments.SelectedValue), loggedInUserCoId, WebConstants.Default.NOT_SET, WebConstants.Default.NOT_SET, WebConstants.Default.NOT_SET, DateTime.Now, 0, DateTime.Now.AddYears(1), false, "", csv["address_line1"], csv["address_line2"], csv["address_line3"], csv["address_line4"], csv["address_line5"], csv["address_post_code"], fullAddress, "", false,false, false, null,null,null,null,loggedInUserId, DateTime.Now, loggedInUserId, DateTime.Now).GetEnumerator(); if (iEnumerator.MoveNext()) { count++; } } SetInfoMessage(count + " folders added to the system."); } }
private DataTable getDepartmentOrder(int DepartmentOrderId) { DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter tableAdaptor = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); DataTable dt = tableAdaptor.GetDepartmentOrderById(DepartmentOrderId); return dt; }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter ta = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); if (e.CommandName.Equals("CancelOrder")) { int orderId = int.Parse(e.CommandArgument.ToString()); ta.UpdateCancel(loggedInUserId,orderId,true,DateTime.Now); SetInfoMessage(WebConstants.Messages.Information.ORDER_CANCELLED); GridView1.DataBind(); } else if (e.CommandName.Equals("UncancelOrder")) { int orderId = int.Parse(e.CommandArgument.ToString()); ta.UpdateCancel(loggedInUserId,orderId,false,null); SetInfoMessage(WebConstants.Messages.Information.ORDER_UNCANCELLED); GridView1.DataBind(); } else if (e.CommandName.Equals("EditOrder")) { int orderId = int.Parse(e.CommandArgument.ToString()); Response.Redirect("~/Orders/AddOrder.aspx?" + WebConstants.Request.DEPT_ORDER_ID + "=" + orderId); } }
protected void btnCopy_Click(object sender, EventArgs e) { DepartmentOrder.DepartmentOrderRowRow order = DatabaseUtility.GetDepartmentOrder(int.Parse(hfSourceOrderId.Value)); if (order != null) { Nullable<bool> flgDocToClient = null; Nullable<int> estWork = null; Nullable<bool> multiEmerExits = null; Nullable<bool> multiAssemPts = null; Nullable<bool> flgCancelled = null; Nullable<DateTime> dateCancelled = null; Nullable<int> estNumOfOperatives = null; if (order.Isflg_order_doc_to_clientNull() == false) flgDocToClient = order.flg_order_doc_to_client; if (order.Isorder_est_of_worksNull() == false) estWork = order.order_est_of_works; if (order.Isflg_multi_emer_exitsNull() == false) multiEmerExits = order.flg_multi_emer_exits; if (order.Isflg_multi_assem_pointsNull() == false) multiAssemPts = order.flg_multi_assem_points; if (order.Isflg_cancelledNull() == false) flgCancelled = order.flg_cancelled; if (order.Isdate_cancelledNull() == false) dateCancelled = order.date_cancelled; if (order.Isest_num_of_operativesNull() == false) estNumOfOperatives = order.est_num_of_operatives; DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter da = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); IEnumerator iEnum = da.InsertAndReturn(false, order.dept_id, order.co_id, order.order_ref, order.order_client_ref, order.order_sms, DateTime.Now, estWork, DateTime.Now.AddYears(1), flgDocToClient, tbAddressNo.Text,tbAddress1.Text,tbAddress2.Text,tbAddress3.Text, tbAddress4.Text,tbAddress5.Text,tbPostalCode.Text,getFullAddress(),(order.Isorder_descNull()) ? null : order.order_desc, multiEmerExits, multiAssemPts, flgCancelled, dateCancelled,(order.Isdesc_of_workNull()) ? null : order.desc_of_work,estNumOfOperatives, (order.Isrisk_takingNull())?null:order.risk_taking,loggedInUserId, DateTime.Now, loggedInUserId, DateTime.Now).GetEnumerator(); if (iEnum.MoveNext()) { DepartmentOrder.DepartmentOrderRowRow newOrder = (DepartmentOrder.DepartmentOrderRowRow)iEnum.Current; //copy persons DepartmentOrderPersonTableAdapters.DepartmentOrderPersonEntityTableAdapter personTA = new DepartmentOrderPersonTableAdapters.DepartmentOrderPersonEntityTableAdapter(); IEnumerator iEPerson = personTA.GetAllOrderPersonsByOrderId(order.dept_id, order.co_id, order.sequence).GetEnumerator(); while (iEPerson.MoveNext()) { DepartmentOrderPerson.DepartmentOrderPersonEntityRow personDR = (DepartmentOrderPerson.DepartmentOrderPersonEntityRow)iEPerson.Current; Nullable<bool> flgSupervisor = null; Nullable<bool> flgFirstAider = null; Nullable<bool> flgFireWarden = null; string personName = (personDR.Isname_descNull()) ? null : personDR.name_desc; if (personDR.Issuperrvisor_checkNull() == false) flgSupervisor = Convert.ToBoolean(personDR.superrvisor_check); if (personDR.Isfirstaiderr_checkNull() == false) flgFirstAider = Convert.ToBoolean(personDR.firstaiderr_check); if (personDR.Isfirewardenn_checkNull() == false) flgFireWarden = Convert.ToBoolean(personDR.firewardenn_check); personTA.Insert(personDR.dept_id, personDR.co_id, newOrder.sequence, personName, loggedInUserId, flgSupervisor, flgFirstAider, flgFireWarden,false); } //copy hazards DepartmentOrderDetailTableAdapters.DepartmentOrderHazardTableAdapter hazaradTA = new DepartmentOrderDetailTableAdapters.DepartmentOrderHazardTableAdapter(); IEnumerator iEHazard = hazaradTA.GetAllHazards(order.dept_id, order.co_id, order.sequence).GetEnumerator(); while (iEHazard.MoveNext()) { DepartmentOrderDetail.DepartmentOrderHazardRow hazardDR = (DepartmentOrderDetail.DepartmentOrderHazardRow)iEHazard.Current; hazaradTA.Insert(order.dept_id, order.co_id, newOrder.sequence, hazardDR.hazard_desc, loggedInUserId); } //copy sequence of work DepartmentOrderDetailTableAdapters.DepartmentOrderWorkTableAdapter workTA = new DepartmentOrderDetailTableAdapters.DepartmentOrderWorkTableAdapter(); IEnumerator iEWork = workTA.GetAllWorks(order.dept_id, order.co_id, order.sequence).GetEnumerator(); while (iEWork.MoveNext()) { DepartmentOrderDetail.DepartmentOrderWorkRow workDR = (DepartmentOrderDetail.DepartmentOrderWorkRow)iEWork.Current; workTA.Insert(order.dept_id, order.co_id, newOrder.sequence, workDR.work_desc, loggedInUserId); } //copy plats and tools DepartmentOrderDetailTableAdapters.DepartmentOrderToolTableAdapter toolTA = new DepartmentOrderDetailTableAdapters.DepartmentOrderToolTableAdapter(); IEnumerator iETool = toolTA.GetAllDepartmentTool(order.dept_id, order.co_id, order.sequence).GetEnumerator(); while (iETool.MoveNext()) { DepartmentOrderDetail.DepartmentOrderToolRow toolDR = (DepartmentOrderDetail.DepartmentOrderToolRow)iETool.Current; toolTA.Insert(order.dept_id, order.co_id, newOrder.sequence, toolDR.tool_desc, loggedInUserId); } //copy PPE DepartmentOrderDetailTableAdapters.DepartmentOrderPPETableAdapter ppeTA = new DepartmentOrderDetailTableAdapters.DepartmentOrderPPETableAdapter(); IEnumerator iEPPE = ppeTA.GetAllPPE(order.dept_id, order.co_id, order.sequence).GetEnumerator(); while (iEPPE.MoveNext()) { DepartmentOrderDetail.DepartmentOrderPPERow ppeDR = (DepartmentOrderDetail.DepartmentOrderPPERow)iEPPE.Current; ppeTA.Insert(order.dept_id, order.co_id, newOrder.sequence, ppeDR.ppe_desc, loggedInUserId); } //copy Emergency DepartmentOrderDetailTableAdapters.DepartmentOrderEmergencyExitTableAdapter emergencyTA = new DepartmentOrderDetailTableAdapters.DepartmentOrderEmergencyExitTableAdapter(); IEnumerator iEEmergency = emergencyTA.GetAllEmergencyExits(order.dept_id, order.co_id, order.sequence).GetEnumerator(); while (iEEmergency.MoveNext()) { DepartmentOrderDetail.DepartmentOrderEmergencyExitRow emergencyDR = (DepartmentOrderDetail.DepartmentOrderEmergencyExitRow)iEEmergency.Current; emergencyTA.Insert(order.dept_id, order.co_id, newOrder.sequence, emergencyDR.emer_exit_title, null, loggedInUserId); } //copy Requirements DepartmentOrderDetailTableAdapters.DepartmentOrderRequirementTableAdapter requirementTA = new DepartmentOrderDetailTableAdapters.DepartmentOrderRequirementTableAdapter(); IEnumerator iERequirements = requirementTA.GetAllRequirements(order.dept_id,order.co_id,order.sequence).GetEnumerator(); while(iERequirements.MoveNext()) { DepartmentOrderDetail.DepartmentOrderRequirementRow requirementDR = (DepartmentOrderDetail.DepartmentOrderRequirementRow)iERequirements.Current; requirementTA.Insert(order.dept_id,order.co_id,newOrder.sequence,requirementDR.requirement_header,null,loggedInUserId); } //copy Aspects DepartmentOrderDetailTableAdapters.DepartmentOrderKeyAspectsTableAdapter aspectsTA = new DepartmentOrderDetailTableAdapters.DepartmentOrderKeyAspectsTableAdapter(); IEnumerator iEAspects = aspectsTA.GetAllKeyAspects(order.dept_id,order.co_id,order.sequence).GetEnumerator(); while(iEAspects.MoveNext()) { DepartmentOrderDetail.DepartmentOrderKeyAspectsRow aspectsDR = (DepartmentOrderDetail.DepartmentOrderKeyAspectsRow)iEAspects.Current; aspectsTA.Insert(order.dept_id,order.co_id,newOrder.sequence,aspectsDR.key_aspect_header,null,loggedInUserId); } //copy Docs DepartmentOrderDocTableAdapters.DepartmentOrderDocTableAdapter docTA = new DepartmentOrderDocTableAdapters.DepartmentOrderDocTableAdapter(); IEnumerator iEDocs = docTA.GetAllDocs(order.co_id,order.dept_id,order.sequence).GetEnumerator(); while(iEDocs.MoveNext()) { DepartmentOrderDoc.DepartmentOrderDocEntityRow docDR = (DepartmentOrderDoc.DepartmentOrderDocEntityRow)iEDocs.Current; docTA.Insert(newOrder.sequence,docDR.doc_id,order.dept_id,order.co_id,false); } } } GridView1.DataBind(); }
protected void DeleteDepartmentOrder(int deptOrderId) { DataTable department = getDepartmentOrder(deptOrderId); if (department == null) { SetErrorMessage(WebConstants.Messages.Error.INVALID_ID); } else { try { DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter tableAdapter = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); tableAdapter.Delete(deptOrderId); SetInfoMessage(WebConstants.Messages.Information.RECORD_DELETED); GridView1.DataBind(); } catch { SetErrorMessage(WebConstants.Messages.Error.CONNECTION_ERROR); } } }
private void GenerateFolder() { hlDoc.Visible = false; Image4.Visible = false; Image5.Visible = false; List<DocumentType> docTypes = new List<DocumentType>(); for (int i=0;i<rptDocTypes.Items.Count;i++) { RepeaterItem item = rptDocTypes.Items[i]; CheckBox cb = (CheckBox)item.FindControl("cbDocType"); if (cb.Checked == true) { DocumentType docType = new DocumentType(); docType.DeptOrderId = int.Parse(Request[WebConstants.Request.DEPT_ORDER_ID]); docType.Id = int.Parse(((HiddenField)item.FindControl("hfId")).Value); docType.Name = cb.Text; docType.Type = ((HiddenField)item.FindControl("hfFieldType")).Value; docType.GeneratorClass = ((HiddenField)item.FindControl("hfGeneratorClass")).Value; docType.CoId = int.Parse(((HiddenField)item.FindControl("hfCoId")).Value); docType.DeptId = int.Parse(((HiddenField)item.FindControl("hfDeptId")).Value); docType.IncludeBlankPage = cbBlankPage.Checked; HiddenField hfIsLandScape = (HiddenField)item.FindControl("hfIsLandScape"); if (hfIsLandScape.Value.Length > 0 && bool.Parse(hfIsLandScape.Value) == true) docType.IsLandScape = true; else docType.IsLandScape = false; docType.Number = null; if (docType.Type.Equals("int")) { NumericBox nb = (NumericBox)item.FindControl("nbNumOfPrints"); if (nb.Text.Length == 0) { SetErrorMessage("Number of Copies for " + docType.Name + " must be specified"); return; } else { docType.Number = int.Parse(nb.Text); } } else if (docType.Type.Equals("detail")) { DepartmentOrderDocTableAdapters.DepartmentOrderDocTableAdapter ta = new DepartmentOrderDocTableAdapters.DepartmentOrderDocTableAdapter(); IEnumerator ie = ta.GetDocsByType(loggedInUserCoId, (int)Session[WebConstants.Session.DEPT_ID], int.Parse(Request[WebConstants.Request.DEPT_ORDER_ID]), docType.Id).GetEnumerator(); bool hasData = false; while (ie.MoveNext()) { DepartmentOrderDoc.DepartmentOrderDocEntityRow dr = (DepartmentOrderDoc.DepartmentOrderDocEntityRow)ie.Current; docType.DocList.Add(dr.doc_id, dr.doc_name); hasData = true; } if (hasData == false) { SetErrorMessage("Atleast one document against document type " + docType.Name + " must be selected"); return; } } docTypes.Add(docType); } else { bool required = bool.Parse(((HiddenField)item.FindControl("hfRequired")).Value); if (required) { SetErrorMessage("Document type " + cb.Text + " must be selected"); return; } } } if (docTypes.Count == 0) { SetErrorMessage(WebConstants.Messages.Error.SELECT_ATLEAST_ONE_DOCTYPE); } else { DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter ta = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); ta.UpdateOrderDetails(null, DateTime.Parse(dtClient.Text), cbRegister.Checked, cbClosed.Checked, null, loggedInUserId, int.Parse(Request[WebConstants.Request.DEPT_ORDER_ID])); FolderGenerator folderGenerator = new FolderGenerator(docTypes); if (folderGenerator.Generate()) { string completePath = "~/Folders/" + folderGenerator.fileName; DepartmentOrderDetailTableAdapters.DepartmentOrderLogTableAdapter logTA = new DepartmentOrderDetailTableAdapters.DepartmentOrderLogTableAdapter(); logTA.Insert(int.Parse(Request[WebConstants.Request.DEPT_ORDER_ID]), loggedInUserCoId, (int)Session[WebConstants.Session.DEPT_ID], loggedInUserId, DateTime.Now, completePath, false); ClientScript.RegisterStartupScript(this.GetType(), "redirect", "window.open(\"../Folders/" + folderGenerator.fileName + "\");",true); hlDoc.Visible = true; Image4.Visible = true; Image5.Visible = true; hlDoc.NavigateUrl = completePath; } else { SetErrorMessage(WebConstants.Messages.Error.DOC_NOT_GENERATED); } } }
protected void gvAssemble_RowDeleting(object sender, GridViewDeleteEventArgs e) { int deptId = int.Parse(hfDeptId.Value); int deptOrderId = int.Parse(Request[WebConstants.Request.DEPT_ORDER_ID]); e.Cancel = true; int sequence = (int)e.Keys["sequence"]; DepartmentOrderDetailTableAdapters.DepartmentOrderAssemblePtTableAdapter tableAdapter = new DepartmentOrderDetailTableAdapters.DepartmentOrderAssemblePtTableAdapter(); tableAdapter.Delete(loggedInUserId, sequence); if (tableAdapter.GetAllAssemblePts(deptId, loggedInUserCoId, deptOrderId).Rows.Count <= 1) { DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter orderTA = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); orderTA.UpdateMultiAssemblePoints(false, loggedInUserId, deptOrderId); } gvAssemble.DataBind(); btnAddAssemble.Focus(); }
protected void gvExit_RowDeleting(object sender, GridViewDeleteEventArgs e) { int deptId = (int)Session[WebConstants.Session.DEPT_ID]; int deptOrderId = int.Parse(Request[WebConstants.Request.DEPT_ORDER_ID]); e.Cancel = true; int sequence = (int)e.Keys["sequence"]; DepartmentOrderDetailTableAdapters.DepartmentOrderEmergencyExitTableAdapter tableAdapter = new DepartmentOrderDetailTableAdapters.DepartmentOrderEmergencyExitTableAdapter(); tableAdapter.Delete(loggedInUserId, sequence); if (tableAdapter.GetAllEmergencyExits(deptId, loggedInUserCoId, deptOrderId).Rows.Count <= 1) { DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter orderTA = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); orderTA.UpdateMultiEmergencyExits(false, loggedInUserId, deptId); } gvExit.DataBind(); btnAddExit.Focus(); }
private void Update(bool cancel, Nullable<DateTime> cancelDateTime) { setDefaultValues(); DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter da = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); da.Update(false, int.Parse(ddlDepartment.SelectedValue), loggedInUserCoId, tbOrderRef.Text, tbOrderClientRef.Text, getCreatedDate(), getEstWork(),getEstNumOfOperatives(), getReviewDate(), cbDocClient.Checked, tbAddressNo.Text, tbAddress1.Text, tbAddress2.Text, tbAddress3.Text, tbAddress4.Text, tbAddress5.Text, tbPostalCode.Text, getFullAddress(), tbDesc.Text,tbDescOfWork.Text, cbMultiEmerExits.Checked, cbAssemPts.Checked, cancel, cancelDateTime, loggedInUserId, DateTime.Now,ddlRiskTaking.SelectedValue, int.Parse(Request[WebConstants.Request.DEPT_ORDER_ID])); Response.Redirect("~/Orders/AddOrderPeople.aspx?" + WebConstants.Request.DEPT_ORDER_ID + "=" + Request[WebConstants.Request.DEPT_ORDER_ID]); }
private void preSaveDepartmentOrder() { setDefaultValues(); DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter da = new DepartmentOrderTableAdapters.DepartmentOrderRowTableAdapter(); IEnumerator iEnumerator = da.InsertAndReturn(false,firstDepartmentId, loggedInUserCoId, tbOrderRef.Text, tbOrderClientRef.Text, tbOrderSMS.Text, DateTime.Now, getEstWork(), DateTime.Now.AddYears(1), cbDocClient.Checked, tbPopupFlat.Text, tbPopupAddress1.Text, tbPopupAddress2.Text, tbPopupAddress3.Text, tbPopupAddress4.Text, tbPopupAddress5.Text, tbPopupPostCode.Text, getPopupFullAddress(), tbDesc.Text, cbMultiEmerExits.Checked, cbAssemPts.Checked, false, null,tbDescOfWork.Text,getEstNumOfOperatives(),ddlRiskTaking.SelectedValue, loggedInUserId, DateTime.Now, loggedInUserId, DateTime.Now).GetEnumerator(); if (iEnumerator.MoveNext()) { DepartmentOrder.DepartmentOrderRowRow dataRow = (DepartmentOrder.DepartmentOrderRowRow)iEnumerator.Current; Response.Redirect("~/Orders/AddOrder.aspx?" + WebConstants.Request.DEPT_ORDER_ID + "=" + dataRow.sequence); } }