protected void LoadRFPInfo() { using (clsRFPRequest objRFPRequest = new clsRFPRequest()) { objRFPRequest.ControlNumber = Request.QueryString["ControlNumber"]; objRFPRequest.Fill(); txtControlNumber.Text = objRFPRequest.ControlNumber; txtRequestor.Text = objRFPRequest.PayeeName; ddlRequestType.SelectedValue = objRFPRequest.RequestCode; txtIntended.Text = objRFPRequest.RequestFor; txtProjectTitle.Text = objRFPRequest.ProjectTitle; txtRFANumber.Text = objRFPRequest.RFANumber.Trim(); dtpDateNeeded.Date = objRFPRequest.DateNeeded; txtSupportingDocuments.Text = objRFPRequest.SupportingDoument; txtRemarks.Text = objRFPRequest.Remarks; ddlEndorsedBy1.SelectedValue = (objRFPRequest.EndorsedBy1 != "") ? objRFPRequest.EndorsedBy1 : ""; if (objRFPRequest.EndorsedBy2.Trim() != "") { trEndorseBy2.Visible = true; btbAddEndorser2.Visible = false; ddlEndorsedBy2.SelectedValue = objRFPRequest.EndorsedBy2; } ddlAuthorized.SelectedValue = objRFPRequest.AuthorizedBy; LoadDetails(); } }
protected void Page_Load(object sender, EventArgs e) { clsSpeedo.Authenticate(); if (!Page.IsPostBack) { MakeCart(); LoadDDLs(); using (clsRFPRequest objRFPRequest = new clsRFPRequest()) { objRFPRequest.ControlNumber = Request.QueryString["ControlNumber"]; objRFPRequest.Fill(); if (objRFPRequest.Status != "2") { Response.Redirect("../../AccessDenied.aspx"); } if (objRFPRequest.EndorsedBy1.Trim() != string.Empty && objRFPRequest.EndorsedBy2.Trim() == string.Empty) { if (objRFPRequest.EndorsedStatus1.Trim() == "2") { LoadRFPInfo(); } else { Response.Redirect("../../AccessDenied.aspx"); } } if (objRFPRequest.EndorsedBy1.Trim() != string.Empty && objRFPRequest.EndorsedBy2.Trim() != string.Empty) { if (objRFPRequest.EndorsedStatus1.Trim() == "2" && objRFPRequest.EndorsedStatus2.Trim() == "2") { LoadRFPInfo(); } else { Response.Redirect("../../AccessDenied.aspx"); } } if (objRFPRequest.EndorsedBy1.Trim() == string.Empty && objRFPRequest.EndorsedBy2.Trim() == string.Empty) { if (objRFPRequest.AuthorizeStatus.Trim() == "2") { LoadRFPInfo(); } else { Response.Redirect("../../AccessDenied.aspx"); } } } ValidateRequestForField(); } }
protected void btnCancel_Click(object sender, EventArgs e) { using (clsRFPRequest objRequest = new clsRFPRequest()) { objRequest.ControlNumber = Request.QueryString["ControlNumber"]; objRequest.Fill(); if (objRequest.Status == "2") { if (clsRFPRequest.Cancel(objRequest.ControlNumber) > 0) { Response.Redirect("RFPMenu.aspx"); } } } }
private void LoadDetails() { using (clsRFPRequest objRequest = new clsRFPRequest()) { objRequest.ControlNumber = Request.QueryString["ControlNumber"]; objRequest.Fill(); lblControlNumber.Text = objRequest.ControlNumber; lblPayee.Text = objRequest.PayeeName; lblRequestedBy.Text = clsEmployee.GetName(objRequest.CreatedBy); lblRequestType.Text = clsRFPRequestType.GetRequestTypeName(objRequest.RequestCode); //lblRequestFor.Text = objRequest.RequestFor; lblProjectTitle.Text = objRequest.ProjectTitle; lblReferenceRFANo.Text = objRequest.RFANumber; lblDateCheckNeeded.Text = objRequest.DateNeeded.ToLongDateString().ToString(); lblDateCreated.Text = objRequest.CreatedOn.ToLongDateString().ToString(); lblSupportingDocuments.Text = objRequest.SupportingDoument; lblRemarks.Text = objRequest.Remarks; lblEndorsers.Text = objRequest.EndorsedStatus1 == "1"?clsEmployee.GetName(objRequest.EndorsedBy1):"" + " <br/>" + objRequest.EndorsedStatus2 == "1"?clsEmployee.GetName(objRequest.EndorsedBy2):""; if (lblEndorsers.Text.Trim().Length == 0) { trEndorsers.Visible = false; } if (objRequest.Status == "1") { lblStatus.Text = "( Already been approved )"; lblStatus.Visible = true; } else if (objRequest.Status == "2") { lblStatus.Text = "( For Approval )"; } else if (objRequest.Status == "3") { lblStatus.Text = "( Already been cancelled )"; lblStatus.Visible = true; } else if (objRequest.Status == "M") { lblStatus.Text = "( Already been tag for manual approval )"; lblStatus.Visible = true; } else if (objRequest.Status == "0") { } else { lblStatus.Text = "( Already been disapproved )"; } } }
private void LoadDetails() { using (clsRFPRequest objRequest = new clsRFPRequest()) { string strStatus = ""; objRequest.ControlNumber = Request.QueryString["ControlNumber"]; objRequest.Fill(); lblControlNumber.Text = objRequest.ControlNumber; lblPayee.Text = objRequest.PayeeName; lblRequestType.Text = clsRFPRequestType.GetRequestTypeName(objRequest.RequestCode); lblRequestedBy.Text = clsEmployee.GetName(objRequest.CreatedBy); lblProjectTitle.Text = objRequest.ProjectTitle; lblReferenceRFANo.Text = objRequest.RFANumber; lblDateCheckNeeded.Text = objRequest.DateNeeded.ToLongDateString().ToString(); lblDateCreated.Text = objRequest.CreatedOn.ToLongDateString().ToString(); lblSupportingDocuments.Text = objRequest.SupportingDoument; lblRemarks.Text = objRequest.Remarks; if (objRequest.Status == "1") { lblStatus.Text = "( Approved )"; if (objRequest.CreatedBy == Request.Cookies["Speedo"]["UserName"]) { btnPrint.Visible = true; } } if (objRequest.Status == "M") { lblStatus.Text = "( Manual Approval )"; if (objRequest.CreatedBy == Request.Cookies["Speedo"]["UserName"]) { btnPrint.Visible = true; } } if (objRequest.Status == "0") { lblStatus.Text = "( Disapproved )"; if (objRequest.CreatedBy == Request.Cookies["Speedo"]["UserName"]) { btnPrint.Visible = false; } } } }
protected void SaveData(string pSaveType) { string strPayee = ""; if (ddlRequestType.SelectedValue == "08") { if (txtIntended.Text.Trim() == string.Empty) { divError.Visible = true; lblErrMsg.Text = "Unable to send your request.<br>" + "<table>" + "<tr>" + "<td style='vertical-align:top;'><b>Reason:</b></td>" + "<td>You need to specify the <b>Request For</b> is you choose the request type: <b>Others</b>.</td>" + "</tr>" + "</table>"; return; } } if (!this.ValidateApprovers()) { divError.Visible = true; lblErrMsg.Text = "Unable to send your request.<br>" + "<table>" + "<tr>" + "<td style='vertical-align:top;'><b>Reason:</b></td>" + "<td>You need to select your respective approver only <b>Once</b>.</td>" + "</tr>" + "</table>"; return; } if (dgItems.Items.Count == 0) { divError.Visible = true; lblErrMsg.Text = "Unable to send your request.<br>" + "<table>" + "<tr>" + "<td style='vertical-align:top;'><b>Reason:</b></td>" + "<td>You need to include at least one item to request. Make sure to click <b>Add New Item</b> button to include your requested item.</td>" + "</tr>" + "</table>"; } if (txtProjectTitle.Text.Length <= 0) { divError.Visible = true; lblErrMsg.Text = "Unable to send your request.<br>" + "<table>" + "<tr>" + "<td style='vertical-align:top;'><b>Reason:</b></td>" + "<td>You need to fill up the <b>Project Title</b> field to continue.</td>" + "</tr>" + "</table>"; return; } else { DataTable tblItems = ViewState["Cart"] as DataTable; clsRFPRequest financerequest = new clsRFPRequest(); financerequest.ControlNumber = Request.QueryString["ControlNumber"]; financerequest.RequestCode = ddlRequestType.SelectedValue.ToString().Trim(); financerequest.RequestFor = GetRequestFor(); financerequest.ProjectTitle = txtProjectTitle.Text.Trim(); financerequest.DateNeeded = dtpDateNeeded.Date; financerequest.RFANumber = txtRFANumber.Text.Trim(); financerequest.PayeeName = txtRequestor.Text; financerequest.SupportingDoument = txtSupportingDocuments.Text.Trim(); financerequest.Remarks = txtRemarks.Text.Trim(); if (trEndorseBy2.Visible == true) { //validating Endorsers if (ddlEndorsedBy1.SelectedValue == "" && ddlEndorsedBy2.SelectedValue != "") { financerequest.EndorsedBy1 = ddlEndorsedBy2.SelectedValue; financerequest.EndorsedDate1 = DateTime.Parse("1/1/1990"); financerequest.EndorsedStatus1 = (ddlEndorsedBy2.SelectedValue != "") ? "2" : ""; financerequest.EndorsedBy2 = ""; financerequest.EndorsedDate2 = DateTime.Parse("1/1/1990"); financerequest.EndorsedStatus2 = ""; } else { financerequest.EndorsedBy1 = (ddlEndorsedBy1.SelectedValue != "") ? ddlEndorsedBy1.SelectedValue : ""; financerequest.EndorsedDate1 = DateTime.Parse("1/1/1990"); financerequest.EndorsedStatus1 = (ddlEndorsedBy1.SelectedValue != "") ? "2" : ""; financerequest.EndorsedBy2 = (ddlEndorsedBy2.SelectedValue != "") ? ddlEndorsedBy2.SelectedValue : ""; financerequest.EndorsedDate2 = DateTime.Parse("1/1/1990"); financerequest.EndorsedStatus2 = (ddlEndorsedBy2.SelectedValue != "") ? "2" : ""; } } else { financerequest.EndorsedBy1 = (ddlEndorsedBy1.SelectedValue != "") ? ddlEndorsedBy1.SelectedValue : ""; financerequest.EndorsedDate1 = DateTime.Parse("1/1/1990"); financerequest.EndorsedStatus1 = (ddlEndorsedBy1.SelectedValue != "") ? "2" : ""; financerequest.EndorsedBy2 = ""; financerequest.EndorsedDate2 = DateTime.Parse("1/1/1990"); financerequest.EndorsedStatus2 = ""; } financerequest.AuthorizedBy = ddlAuthorized.SelectedValue; financerequest.AuthorizedByDate = DateTime.Parse("1/1/1990"); financerequest.AuthorizeStatus = "2"; financerequest.Status = "2"; financerequest.CreatedBy = Request.Cookies["Speedo"]["UserName"]; financerequest.CreatedOn = DateTime.Now; financerequest.ModifyBy = Request.Cookies["Speedo"]["UserName"]; financerequest.ModifyOn = DateTime.Parse("1/1/1990"); if (financerequest.Update(tblItems, pSaveType) >= 0) { if (pSaveType == "SAVE") { Response.Redirect("RFPMenu.aspx"); } else { Response.Redirect("RFPPrint.aspx?ControlNumber=" + txtControlNumber.Text + ""); } } else { divError.Visible = true; lblErrMsg.Text = "Unable to send your request.<br>" + "<table>" + "<tr>" + "<td style='vertical-align:top;'><b>Reason:</b></td>" + "<td>An error occured uing saving. Please make sure you have filled out all the necessary fields.</td>" + "</tr>" + "</table>"; } } }