//protected void gvContactDetails_RowDataBound(object sender, GridViewRowEventArgs e) //{ // try // { // if (e.Row.RowType == DataControlRowType.DataRow) // { // (e.Row.FindControl("lblSerial") as Label).Text = (((this.gvContactDetails.PageIndex * this.gvContactDetails.PageSize) + e.Row.RowIndex) + 1).ToString(); // //string str = (e.Row.Cells[1].Controls[0] as LinkButton).Text; // //str = str.Replace("\'", "\\\'"); // //(e.Row.FindControl("ibtnDeleteContact") as ImageButton).Attributes.Add("OnClick", string.Concat("return confirm(\'Are you sure you want to delete \\\'", str, "\\\'?\');")); // ////(e.Row.FindControl("ibtnDeleteContact") as ImageButton).Visible = false; // } // } // catch (Exception exception1) // { // ErrorLog.LogErrorMessageToDB("AddEditOrderAcceptanceCheckList.aspx", "", "gvContactDetails_RowDataBound", exception1.Message.ToString(), new ACEConnection()); // throw; // } //} protected void gvOrderAcceptanceParticularsLists_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Cells[1].Visible = false; e.Row.Cells[3].Visible = false; OrderAcceptanceParticularsListDL rlDL = new OrderAcceptanceParticularsListDL(); rlDL.GetOrderAcceptanceParticularsListByParticularsID(Convert.ToInt32(hfOrderAcceptanceCheckListID.Value), Convert.ToInt32(e.Row.Cells[1].Text)); e.Row.Cells[3].Text = rlDL.OrderAcceptanceParticularsListID.ToString(); RadioButton rbYes = (RadioButton)e.Row.FindControl("rbCheckYes"); RadioButton rbNo = (RadioButton)e.Row.FindControl("rbCheckNo"); TextBox txtRemarks = (TextBox)e.Row.FindControl("txtRemarks"); if (e.Row.Cells[2].Text.ToLower() == "price") { rbYes.Text = "AGREEABLE"; rbNo.Text = "AGREEABLE"; } if (e.Row.Cells[2].Text.ToLower() == "quantity") { rbYes.Text = "OPEN ORDER"; rbNo.Text = "CLOSED"; } if (e.Row.Cells[2].Text.ToLower() != "price" && e.Row.Cells[2].Text.ToLower() != "quantity") { rbYes.Text = "YES"; rbNo.Text = "NO"; } rbYes.Checked = rlDL.StatusYes; rbNo.Checked = rlDL.StatusNo; txtRemarks.Text = rlDL.Remarks; } if (e.Row.RowType == DataControlRowType.Header) { e.Row.Cells[1].Visible = false; e.Row.Cells[3].Visible = false; } } catch (Exception ex) { ErrorLog.LogErrorMessageToDB("AddEditOrderAcceptanceCheckList.aspx", "", "gvOrderAcceptanceParticularsList_RowDataBound", ex.Message.ToString(), new ACEConnection()); throw; } }
/// <summary> /// Load the Contact Drop Down List /// </summary> private void LoadContactDropDown() { try { // Load Contact ddlContact.Items.Clear(); ddlContact.DataSource = new ContactDL().GetContactList(Convert.ToInt32(hfCompanyID.Value)).Tables[0]; ddlContact.DataTextField = "FName"; ddlContact.DataValueField = "ContactID"; ddlContact.DataBind(); ddlContact.Items.Insert(0, "--Select One--"); ddlContact.Items[0].Value = ""; ddlReviewedBy.Items.Clear(); ddlReviewedBy.DataSource = new EmployeeDL().GetEmployeeListByCompanyID(Convert.ToInt32(hfCompanyID.Value)).Tables[0]; ddlReviewedBy.DataTextField = "EmployeeName"; ddlReviewedBy.DataValueField = "EmployeeID"; ddlReviewedBy.DataBind(); ddlReviewedBy.Items.Insert(0, "--Select One--"); ddlReviewedBy.Items[0].Value = ""; ddlApprovedBy.Items.Clear(); ddlApprovedBy.DataSource = new EmployeeDL().GetEmployeeListByCompanyID(Convert.ToInt32(hfCompanyID.Value)).Tables[0]; ddlApprovedBy.DataTextField = "EmployeeName"; ddlApprovedBy.DataValueField = "EmployeeID"; ddlApprovedBy.DataBind(); ddlApprovedBy.Items.Insert(0, "--Select One--"); ddlApprovedBy.Items[0].Value = ""; OrderAcceptanceParticularsListDL rlDL = new OrderAcceptanceParticularsListDL(); gvOrderAcceptanceParticularsList.DataSource = rlDL.GetParticularsList().Tables[0]; gvOrderAcceptanceParticularsList.DataBind(); } catch (Exception ex) { ErrorLog.LogErrorMessageToDB("AddEditOrderAcceptanceCheckList.aspx", "", "LoadContactDropDown", ex.Message.ToString(), new ACEConnection()); } }
protected void btnOrderAcceptanceCheckListAdd_Click(object sender, ImageClickEventArgs e) { try { string dtFormat = _dateFormat; DateTime dTime; OrderAcceptanceChecklistDL _currentOrderAcceptanceCheckList = new OrderAcceptanceChecklistDL(); bool bl = hfOrderAcceptanceCheckListID.Value.ToString() == "0"; _currentOrderAcceptanceCheckList.AddEditOption = !bl ? 1 : 0; _currentOrderAcceptanceCheckList.OrderAcceptanceCheckListID = Convert.ToInt32(hfOrderAcceptanceCheckListID.Value.ToString()); _currentOrderAcceptanceCheckList.ContactID = Convert.ToInt32(ddlContact.SelectedValue); dTime = DateTime.ParseExact(txtPODate.Text, dtFormat, null); _currentOrderAcceptanceCheckList.QuotationDate = dTime; _currentOrderAcceptanceCheckList.PartDescription = txtPartDescription.Text; _currentOrderAcceptanceCheckList.PONO = txtPONo.Text; dTime = DateTime.ParseExact(txtPODate.Text, dtFormat, null); _currentOrderAcceptanceCheckList.PODate = dTime; _currentOrderAcceptanceCheckList.POAmendRef = txtPOAmendRef.Text; _currentOrderAcceptanceCheckList.DrawingNo_Issue = txtDrawingNo_Issue.Text; _currentOrderAcceptanceCheckList.QuotationRef = txtQuotationRef.Text; if (rbFPO.Checked) { _currentOrderAcceptanceCheckList.NatureOfReview = rbFPO.Text; } if (rbRPO.Checked) { _currentOrderAcceptanceCheckList.NatureOfReview = rbRPO.Text; } if (rbAmend.Checked) { _currentOrderAcceptanceCheckList.NatureOfReview = rbAmend.Text; } if (rbCheck1.Checked) { _currentOrderAcceptanceCheckList.CheckForOption1 = true; } if (rbCheck2.Checked) { _currentOrderAcceptanceCheckList.CheckForOption2 = true; } if (rbCheck3.Checked) { _currentOrderAcceptanceCheckList.CheckForOption3 = true; } if (rbCheck4.Checked) { _currentOrderAcceptanceCheckList.CheckForOption4 = true; } _currentOrderAcceptanceCheckList.Comments = txtComments.Text; if (rbToBeResolved.Checked) { _currentOrderAcceptanceCheckList.ReviewStatus = rbToBeResolved.Text; } if (rbNotToBeResolved.Checked) { _currentOrderAcceptanceCheckList.ReviewStatus = rbNotToBeResolved.Text; } if (rbAccepted.Checked) { _currentOrderAcceptanceCheckList.ReviewStatus = rbAccepted.Text; } if (rbNotAccepted.Checked) { _currentOrderAcceptanceCheckList.ReviewStatus = rbNotAccepted.Text; } if (ddlReviewedBy.SelectedValue != "") { _currentOrderAcceptanceCheckList.ReviewedByID = Convert.ToInt32(ddlReviewedBy.SelectedValue); } if (txtReviewedDate.Text != null || txtReviewedDate.Text != "") { dTime = DateTime.ParseExact(txtReviewedDate.Text, dtFormat, null); _currentOrderAcceptanceCheckList.ReviewedDate = dTime; } if (ddlApprovedBy.SelectedValue != "") { _currentOrderAcceptanceCheckList.ApprovedByID = Convert.ToInt32(ddlApprovedBy.SelectedValue); _currentOrderAcceptanceCheckList.ApprovedDate = dTime; } _currentOrderAcceptanceCheckList.AuditDate = dTime; _currentOrderAcceptanceCheckList.AuditID = Convert.ToInt32(hfUserID.Value); _currentOrderAcceptanceCheckList.ScreenMode = ScreenMode.Add; TransactionResult transactionResult = _currentOrderAcceptanceCheckList.Commit(); bl = transactionResult.Status != TransactionStatus.Success; if (!bl) { hfOrderAcceptanceCheckListID.Value = _currentOrderAcceptanceCheckList.OrderAcceptanceCheckListID.ToString(); OrderAcceptanceParticularsListDL listDL; foreach (GridViewRow innerRow in gvOrderAcceptanceParticularsList.Rows) { listDL = new OrderAcceptanceParticularsListDL(); if (innerRow.Cells[3].Text.ToString() == "") { innerRow.Cells[3].Text = "0"; } bool b2 = innerRow.Cells[3].Text.ToString() == "0"; listDL.AddEditOption = !b2 ? 1 : 0; listDL.OrderAcceptanceParticularsListID = Convert.ToInt32(innerRow.Cells[3].Text.ToString()); listDL.OrderAcceptanceCheckListID = Convert.ToInt32(hfOrderAcceptanceCheckListID.Value.ToString()); listDL.ParticularsID = Convert.ToInt32(innerRow.Cells[1].Text.ToString()); RadioButton rbYes = (RadioButton)innerRow.Cells[4].FindControl("rbCheckYes"); RadioButton rbNo = (RadioButton)innerRow.Cells[4].FindControl("rbCheckNo"); TextBox txtRemarks = (TextBox)innerRow.Cells[5].FindControl("txtRemarks"); listDL.StatusYes = rbYes.Checked; listDL.StatusNo = rbNo.Checked; listDL.Remarks = txtRemarks.Text; listDL.ScreenMode = ScreenMode.Add; listDL.Commit(); } GetOrderAcceptanceCheckListDetails(Convert.ToInt32(hfOrderAcceptanceCheckListID.Value)); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(string.Concat("<script>alert(\'", transactionResult.Message.ToString(), ".\');")); stringBuilder.Append("</script>"); ScriptManager.RegisterStartupScript(base.Page, typeof(string), "MyScript", stringBuilder.ToString(), false); } else { //txtAvailablecount.Text = "0"; //lblOrderAcceptanceCheckListID.Text = "0"; } } catch (Exception exception1) { ErrorLog.LogErrorMessageToDB("ManageOrderAcceptanceCheckList.aspx", "", "btnOrderAcceptanceCheckListAdd_Click", exception1.Message.ToString(), new ACEConnection()); throw; } }
private void GetOrderAcceptanceCheckListDetails(int OrderAcceptanceCheckListID) { try { OrderAcceptanceChecklistDL _currentOrderAcceptanceCheckList = new OrderAcceptanceChecklistDL(); _currentOrderAcceptanceCheckList.GetOrderAcceptanceCheckListByOrderAcceptanceCheckListID(Convert.ToInt32(hfOrderAcceptanceCheckListID.Value.ToString())); ddlContact.SelectedValue = _currentOrderAcceptanceCheckList.ContactID.ToString(); txtPartDescription.Text = _currentOrderAcceptanceCheckList.PartDescription; txtPONo.Text = _currentOrderAcceptanceCheckList.PONO; txtPODate.Text = _currentOrderAcceptanceCheckList.PODate.ToString(); txtPOAmendRef.Text = _currentOrderAcceptanceCheckList.POAmendRef; txtDrawingNo_Issue.Text = _currentOrderAcceptanceCheckList.DrawingNo_Issue; txtQuotationRef.Text = _currentOrderAcceptanceCheckList.QuotationRef; if (_currentOrderAcceptanceCheckList.NatureOfReview.ToString() == "FIRST PURCHASE ORDER") { rbFPO.Checked = true; } if (_currentOrderAcceptanceCheckList.NatureOfReview.ToString() == "REGULAR PURCHASE ORDER") { rbRPO.Checked = true; } if (_currentOrderAcceptanceCheckList.NatureOfReview.ToString() == "AMENDMENTS") { rbAmend.Checked = true; } if (_currentOrderAcceptanceCheckList.CheckForOption1) { rbCheck1.Checked = true; } if (_currentOrderAcceptanceCheckList.CheckForOption2) { rbCheck2.Checked = true; } if (_currentOrderAcceptanceCheckList.CheckForOption3) { rbCheck3.Checked = true; } if (_currentOrderAcceptanceCheckList.CheckForOption4) { rbCheck4.Checked = true; } txtComments.Text = _currentOrderAcceptanceCheckList.Comments; if (_currentOrderAcceptanceCheckList.ReviewStatus == "TO BE RESOLVED") { rbToBeResolved.Checked = true; } if (_currentOrderAcceptanceCheckList.ReviewStatus == "NOT TO BE RESOLVED") { rbToBeResolved.Checked = true; } if (_currentOrderAcceptanceCheckList.ReviewStatus == "ACCEPTED") { rbToBeResolved.Checked = true; } if (_currentOrderAcceptanceCheckList.ReviewStatus == "NOT ACCEPTED") { rbToBeResolved.Checked = true; } txtReviewedDate.Text = _currentOrderAcceptanceCheckList.ReviewedDate.ToString(); ddlReviewedBy.SelectedValue = _currentOrderAcceptanceCheckList.ReviewedByID.ToString(); ddlApprovedBy.SelectedValue = _currentOrderAcceptanceCheckList.ApprovedByID.ToString(); OrderAcceptanceParticularsListDL rlDL = new OrderAcceptanceParticularsListDL(); gvOrderAcceptanceParticularsList.DataSource = rlDL.GetParticularsList().Tables[0]; gvOrderAcceptanceParticularsList.DataBind(); } catch (Exception ex) { ErrorLog.LogErrorMessageToDB("AddEditOrderAcceptanceCheckList.aspx", "", "GetOrderAcceptanceCheckListDetails(int OrderAcceptanceCheckListID)", ex.Message, new ACEConnection()); } }