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>";
}
}
}
