protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (clsPCASRequest objPCASRequest = new clsPCASRequest())
{
objPCASRequest.PCASCode = Request.QueryString["pcascode"].ToString();
objPCASRequest.Fill();
lblPCASCode.Text = Request.QueryString["pcascode"].ToString();
lblReason.Text = objPCASRequest.Reason;
lblRequestor.Text = clsEmployee.GetName(objPCASRequest.CreatedBy);
lblPayeeName.Text = clsEmployee.GetName(objPCASRequest.RequestedBy);
lblDataFundsNeeded.Text = objPCASRequest.DateNeeded.ToString("MM/dd/yyyy");
lblClassification.Text = clsPCASClassfication.GetName(objPCASRequest.Classification);
lblFiledOB.Text = objPCASRequest.OBCode.ToString().Trim().Length == 0 ? "Not Applicable" : objPCASRequest.OBCode;
lblChargeType.Text = clsPCASChargeType.GetName(objPCASRequest.ChargeTypeCode);
if (objPCASRequest.ChargeTypeCode == "1")
{
lblChargeTo.Text = clsRC.GetRCName(objPCASRequest.RCCode);
}
else if (objPCASRequest.ChargeTypeCode == "2")
{
lblChargeTo.Text = clsRC.GetRCName(objPCASRequest.RCCode);
}
else if (objPCASRequest.ChargeTypeCode == "3")
{
lblChargeTo.Text = clsDepartment.GetName(objPCASRequest.SchoolCode);
}
lblRemarks.Text = objPCASRequest.Remarks;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (clsPCASRequest objPCASRequest = new clsPCASRequest())
{
objPCASRequest.PCASCode = Request.QueryString["pcascode"].ToString();
objPCASRequest.Fill();
lblPCASCode.Text = Request.QueryString["pcascode"].ToString();
lblReason.Text = objPCASRequest.Reason;
lblRequestor.Text = clsEmployee.GetName(objPCASRequest.CreatedBy);
lblPayeeName.Text = clsEmployee.GetName(objPCASRequest.RequestedBy);
lblDataFundsNeeded.Text = objPCASRequest.DateNeeded.ToString("MM/dd/yyyy");
lblClassification.Text = clsPCASClassfication.GetName(objPCASRequest.Classification);
lblFiledOB.Text = objPCASRequest.OBCode.ToString().Trim().Length == 0 ? "Not Applicable" : objPCASRequest.OBCode;
lblChargeType.Text = clsPCASChargeType.GetName(objPCASRequest.ChargeTypeCode);
if (objPCASRequest.ChargeTypeCode == "1")
{
lblChargeTo.Text = clsRC.GetRCName(objPCASRequest.RCCode);
}
else if (objPCASRequest.ChargeTypeCode == "2")
{
lblChargeTo.Text = clsRC.GetRCName(objPCASRequest.RCCode);
}
else if (objPCASRequest.ChargeTypeCode == "3")
{
lblChargeTo.Text = clsDepartment.GetName(objPCASRequest.SchoolCode);
}
lblRemarks.Text = objPCASRequest.Remarks;
//lblCashier.Text=clsEmployee.GetName(clsPCASRequestCustodian.GetUsername(Request.QueryString["pcascode"].ToString()));
lblApprover.Text = clsPCASApproval.GetNextApproverUserName(Request.QueryString["pcascode"].ToString());
ddlAssignedCustodian.DataSource = clsPCASCustodianFPC.GetDSL();
ddlAssignedCustodian.DataValueField = "pvalue";
ddlAssignedCustodian.DataTextField = "ptext";
ddlAssignedCustodian.DataBind();
try
{
ddlAssignedCustodian.SelectedValue = clsPCASRequestCustodian.GetUsername(Request.QueryString["pcascode"].ToString());
}
catch
{ }
ddlFinalApprover.DataSource = clsModuleApprover.GetDSLFinanceApprover("PETTYFPC3", "3");
ddlFinalApprover.DataValueField = "pvalue";
ddlFinalApprover.DataTextField = "ptext";
ddlFinalApprover.DataBind();
try
{
ddlFinalApprover.SelectedValue = clsPCASApproval.GetFinalFPCApproverUserName(Request.QueryString["pcascode"].ToString());
}
catch
{ }
}
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
string strPurpose = "0";
if (chkTransportation.Checked == true && chkOthers.Checked == true)
{
strPurpose = "3";
}
else if (chkTransportation.Checked == true && chkOthers.Checked == false)
{
strPurpose = "1";
}
else if (chkTransportation.Checked == false && chkOthers.Checked == true)
{
strPurpose = "2";
}
else
{
strPurpose = "0";
}
if (strPurpose != "0")
{
if (ValidateAmount() == false)
{
}
else
{
using (clsPCASRequest objPCASRequest = new clsPCASRequest())
{
objPCASRequest.RequestedBy = ddlExecutive.SelectedValue.ToString();
objPCASRequest.IsExecutive = "1";
objPCASRequest.Reason = txtReason.Text;
objPCASRequest.DateNeeded = dtpDateFromNeeded.SelectedDate;
objPCASRequest.Classification = strPurpose;
objPCASRequest.ChargeTypeCode = ddlChargeType.SelectedValue.ToString();
if (ddlChargeType.SelectedValue.ToString() == "1")
{
objPCASRequest.Others = "";
objPCASRequest.SchoolCode = "";
objPCASRequest.RCCode = clsDepartmentRC.GetRCcode(clsEmployee.GetDepartmentCode(Request.Cookies["Speedo"]["UserName"].ToString()));
}
else if (ddlChargeType.SelectedValue.ToString() == "2")
{
objPCASRequest.Others = "";
objPCASRequest.SchoolCode = "";
objPCASRequest.RCCode = ddlMainChargeTo.SelectedValue.ToString();
}
else if (ddlChargeType.SelectedValue.ToString() == "3")
{
objPCASRequest.Others = "";
objPCASRequest.RCCode = "";
objPCASRequest.SchoolCode = ddlMainChargeTo.SelectedValue.ToString();
}
else if (ddlChargeType.SelectedValue.ToString() == "4")
{
objPCASRequest.Others = txtAppOthers.Text;
objPCASRequest.SchoolCode = "";
objPCASRequest.RCCode = "";
}
objPCASRequest.PCASStat = "P";
objPCASRequest.OBCode = "";
objPCASRequest.CreatedBy = Request.Cookies["Speedo"]["UserName"].ToString();
objPCASRequest.ModifyBy = Request.Cookies["Speedo"]["UserName"].ToString();
objPCASRequest.Remarks = txtRemarks.Text;
if (objPCASRequest.Insert() > 0)
{
DataTable tblCart1 = ViewState["CartItems"] as DataTable;
foreach (DataRow drw in tblCart1.Rows)
{
using (clsPCASRequestDetails objRequestDetails = new clsPCASRequestDetails())
{
objRequestDetails.PCascode = clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString());
objRequestDetails.ItemName = drw["itemdesc"].ToString();
objRequestDetails.Amount = Convert.ToDouble(drw["amount"]);
objRequestDetails.Insert();
}
}
DataTable tblApprovers = new DataTable();
tblApprovers.Columns.Add("PCASCode");
tblApprovers.Columns.Add("Username");
tblApprovers.Columns.Add("ApproverOrder");
tblApprovers.Columns.Add("ApproverType");
tblApprovers.Columns.Add("StatusCode");
int intCount = 0;
if (ddlChargeType.SelectedValue.ToString() == "2")
{
intCount++;
DataRow drNewRow = tblApprovers.NewRow();
drNewRow["PCASCode"] = clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString());
drNewRow["Username"] = ddlRequestEndorser.SelectedValue.ToString();
drNewRow["ApproverOrder"] = intCount;
drNewRow["ApproverType"] = "E";
drNewRow["StatusCode"] = "0";
tblApprovers.Rows.Add(drNewRow);
}
intCount++;
DataRow drNewRowAH = tblApprovers.NewRow();
drNewRowAH["PCASCode"] = clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString());
drNewRowAH["Username"] = ddlHeadApprover.SelectedValue.ToString();
drNewRowAH["ApproverOrder"] = intCount;
drNewRowAH["ApproverType"] = "H";
drNewRowAH["StatusCode"] = "0";
tblApprovers.Rows.Add(drNewRowAH);
intCount++;
DataRow drNewRowDH = tblApprovers.NewRow();
drNewRowDH["PCASCode"] = clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString());
drNewRowDH["Username"] = ddlDivisionHead.SelectedValue.ToString();
drNewRowDH["ApproverOrder"] = intCount;
drNewRowDH["ApproverType"] = "D";
drNewRowDH["StatusCode"] = "0";
tblApprovers.Rows.Add(drNewRowDH);
int intFCount = 0;
foreach (DataRow drwFPCApprover in clsPCASFPCApprover.GetDSGMainForm().Rows)
{
intCount++;
intFCount++;
DataRow drNewRowFPC = tblApprovers.NewRow();
drNewRowFPC["PCASCode"] = clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString());
drNewRowFPC["Username"] = drwFPCApprover["fpcaname"].ToString();
drNewRowFPC["ApproverOrder"] = intCount;
drNewRowFPC["ApproverType"] = "F" + intFCount.ToString();
drNewRowFPC["StatusCode"] = "0";
tblApprovers.Rows.Add(drNewRowFPC);
}
using (clsPCASApproval objApproval = new clsPCASApproval())
{
objApproval.Insert(tblApprovers);
}
clsPCASRequest.SendEmailNotification("Requestor", clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString()), Request.Cookies["Speedo"]["UserName"].ToString(), ddlHeadApprover.SelectedValue.ToString());
if (ddlChargeType.SelectedValue.ToString() == "2")
{
clsPCASRequest.SendEmailNotification("Approver", clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString()), Request.Cookies["Speedo"]["UserName"].ToString(), ddlRequestEndorser.SelectedValue.ToString());
}
else
{
clsPCASRequest.SendEmailNotification("Approver", clsPCASRequest.GetLastCreatedRequest(Request.Cookies["Speedo"]["UserName"].ToString()), Request.Cookies["Speedo"]["UserName"].ToString(), ddlHeadApprover.SelectedValue.ToString());
}
Response.Redirect("PettyCashRequestMenu.aspx");
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (clsPCASRequest objPCASRequest = new clsPCASRequest())
{
objPCASRequest.PCASCode = Request.QueryString["pcascode"].ToString();
objPCASRequest.Fill();
lblPCASCode.Text = Request.QueryString["pcascode"].ToString();
lblReason.Text = objPCASRequest.Reason;
lblRequestor.Text = clsEmployee.GetName(objPCASRequest.CreatedBy);
lblPayeeName.Text = clsEmployee.GetName(objPCASRequest.RequestedBy);
lblDataFundsNeeded.Text = objPCASRequest.DateNeeded.ToString("MM/dd/yyyy");
lblClassification.Text = clsPCASClassfication.GetName(objPCASRequest.Classification);
lblFiledOB.Text = objPCASRequest.OBCode.ToString().Trim().Length == 0 ? "Not Applicable" : objPCASRequest.OBCode;
lblChargeType.Text = clsPCASChargeType.GetName(objPCASRequest.ChargeTypeCode);
if (objPCASRequest.ChargeTypeCode == "1")
{
lblChargeTo.Text = clsRC.GetRCName(objPCASRequest.RCCode);
}
else if (objPCASRequest.ChargeTypeCode == "2")
{
lblChargeTo.Text = clsRC.GetRCName(objPCASRequest.RCCode);
}
else if (objPCASRequest.ChargeTypeCode == "3")
{
//lblChargeTo.Text = clsDepartment.GetName(objPCASRequest.SchoolCode);
lblChargeTo.Text = clsSchool.GetSchoolName(objPCASRequest.SchoolCode);
}
else if (objPCASRequest.ChargeTypeCode == "4")
{
lblChargeTo.Text = objPCASRequest.Others;
}
}
if (clsPCASRequest.GetPCASStatus(Request.QueryString["pcascode"].ToString()) == "A" && clsPCASRequest.GetPCASIsIssued(Request.QueryString["pcascode"].ToString()) == "F")
{
btnTagasIssued.Visible = false;
btnTagASReady.Visible = true;
btnPrint.Visible = false;
}
else if (clsPCASRequest.GetPCASStatus(Request.QueryString["pcascode"].ToString()) == "A" && clsPCASRequest.GetPCASIsIssued(Request.QueryString["pcascode"].ToString()) == "R")
{
btnTagasIssued.Visible = true;
btnTagASReady.Visible = false;
btnPrint.Visible = false;
}
else if (clsPCASRequest.GetPCASStatus(Request.QueryString["pcascode"].ToString()) == "A" && clsPCASRequest.GetPCASIsIssued(Request.QueryString["pcascode"].ToString()) == "I")
{
btnTagasIssued.Visible = false;
btnTagASReady.Visible = false;
btnPrint.Visible = true;
}
if (clsPCASRequest.GetPCASIsIssued(Request.QueryString["pcascode"].ToString()) == "F")
{
trCustodian.Visible = true;
}
else
{
trCustodian.Visible = false;
}
ddlCustodian.DataSource = clsPCASCustodianFPC.GetDSL();
ddlCustodian.DataValueField = "pvalue";
ddlCustodian.DataTextField = "ptext";
ddlCustodian.DataBind();
try
{
ddlCustodian.SelectedValue = clsPCASRequestCustodian.GetUsername(Request.QueryString["pcascode"].ToString());
}
catch
{ }
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (clsPCASApproval.GetApproverType(Request.Cookies["Speedo"]["UserName"].ToString(), Request.QueryString["pcascode"].ToString()) == "F1" || clsPCASApproval.GetApproverType(Request.Cookies["Speedo"]["UserName"].ToString(), Request.QueryString["pcascode"].ToString()) == "F2" || clsPCASApproval.GetApproverType(Request.Cookies["Speedo"]["UserName"].ToString(), Request.QueryString["pcascode"].ToString()) == "F3")
{
trFPC1.Visible = true;
trFPC2.Visible = true;
trFPC3.Visible = true;
trAssignedCashier.Visible = true;
btnApprove.Visible = false;
btnApprove2.Visible = false;
btnSaveAndApprove.Visible = true;
btnSaveAndApprove2.Visible = true;
trFPCD1.Visible = true;
trFPCD2.Visible = true;
trFPCFinalApprover.Visible = true;
if (clsPCASApproval.GetApproverType(Request.Cookies["Speedo"]["UserName"].ToString(), Request.QueryString["pcascode"].ToString()) == "F3")
{
ddlFPCFinalApprover.Enabled = false;
}
}
else
{
trFPCD1.Visible = false;
trFPCD2.Visible = false;
}
MakeCart();
using (clsPCASRequest objPCASRequest = new clsPCASRequest())
{
objPCASRequest.PCASCode = Request.QueryString["pcascode"].ToString();
objPCASRequest.Fill();
lblPCASCode.Text = Request.QueryString["pcascode"].ToString();
lblReason.Text = objPCASRequest.Reason;
lblRequestor.Text = clsEmployee.GetName(objPCASRequest.CreatedBy);
lblPayeeName.Text = clsEmployee.GetName(objPCASRequest.RequestedBy);
lblDataFundsNeeded.Text = objPCASRequest.DateNeeded.ToString("MM/dd/yyyy");
lblClassification.Text = clsPCASClassfication.GetName(objPCASRequest.Classification);
lblFiledOB.Text = objPCASRequest.OBCode.ToString().Trim().Length == 0 ? "Not Applicable" : objPCASRequest.OBCode;
lblChargeType.Text = clsPCASChargeType.GetName(objPCASRequest.ChargeTypeCode);
if (objPCASRequest.ChargeTypeCode == "1")
{
lblChargeTo.Text = clsRC.GetRCName(objPCASRequest.RCCode);
}
else if (objPCASRequest.ChargeTypeCode == "2")
{
lblChargeTo.Text = clsRC.GetRCName(objPCASRequest.RCCode);
}
else if (objPCASRequest.ChargeTypeCode == "3")
{
//lblChargeTo.Text = clsDepartment.GetName(objPCASRequest.SchoolCode);
lblChargeTo.Text = clsSchool.GetSchoolName(objPCASRequest.SchoolCode);
}
else if (objPCASRequest.ChargeTypeCode == "4")
{
lblChargeTo.Text = objPCASRequest.Others;
}
lblRemarks.Text = objPCASRequest.Remarks;
txtApprovedRFA.Text = objPCASRequest.ApprovedRFA.ToString();
txtAmountAllocated.Text = objPCASRequest.AmountAllocated.ToString();
txtNet.Text = objPCASRequest.NetAmount.ToString();
txtRequestAmount.Text = objPCASRequest.RequestAmount.ToString();
txtRemainingBudget.Text = objPCASRequest.RemainingBudget.ToString();
ddlCustodian.DataSource = clsPCASCustodianFPC.GetDSL();
ddlCustodian.DataValueField = "pvalue";
ddlCustodian.DataTextField = "ptext";
ddlCustodian.DataBind();
ddlFPCFinalApprover.DataSource = clsModuleApprover.GetDSLFinanceApprover("PETTYFPC3", "3");
ddlFPCFinalApprover.DataValueField = "pvalue";
ddlFPCFinalApprover.DataTextField = "ptext";
ddlFPCFinalApprover.DataBind();
try
{
ddlCustodian.SelectedValue = clsPCASRequestCustodian.GetUsername(Request.QueryString["pcascode"].ToString());
}
catch
{ }
try
{
ddlFPCFinalApprover.SelectedValue = clsPCASApproval.GetFinalFPCApproverUserName(Request.QueryString["pcascode"].ToString());
}
catch
{ }
ddlSchool.DataSource = clsFinanceAccountDueFrom.GetDSLAccountDueFrom();
ddlSchool.DataValueField = "pvalue";
ddlSchool.DataTextField = "ptext";
ddlSchool.DataBind();
ddlRcCode.DataSource = clsRC.GetDdlDs();
ddlRcCode.DataValueField = "pvalue";
ddlRcCode.DataTextField = "ptext";
ddlRcCode.DataBind();
ddlAccountExpenses.DataSource = clsFinanceAccountExpenses.GetDSLAccountExpenses();
ddlAccountExpenses.DataValueField = "pvalue";
ddlAccountExpenses.DataTextField = "ptext";
ddlAccountExpenses.DataBind();
this.LoadDetails();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
clsSpeedo.Authenticate();
btnBack.Attributes.Add("onClick", "javascript:history.back(); return false;");
if (!clsPCASRequest.AuthenticateAccess(Request.Cookies["Speedo"]["UserName"], Request.QueryString["pcascode"].ToString()))
{
if (!clsSystemModule.HasAccess("PETTYC", Request.Cookies["Speedo"]["UserName"].ToString()))
{
Response.Redirect("~/AccessDenied.aspx");
}
}
clsPCASRequest objPCASRequest = new clsPCASRequest();
objPCASRequest.PCASCode = Request.QueryString["pcascode"];
objPCASRequest.Fill();
if (!Page.IsPostBack)
{
if (objPCASRequest.PCASStat != "P")
{
if (clsPCASApproval.CountDisapprove(objPCASRequest.PCASCode) == 0)
{
if (clsPCASApproval.CountForApproval(objPCASRequest.PCASCode, "E") == 0)
{
if (clsPCASApproval.CountForApproval(objPCASRequest.PCASCode, "A") == 0)
{
//Report
CrystalReportViewer1.Height = 600;
ConnectionInfo ConnInfo = new ConnectionInfo();
{
ConnInfo.ServerName = "hades";
ConnInfo.DatabaseName = "MySTIHQ";
ConnInfo.UserID = "usermystihq";
ConnInfo.Password = "******";
}
foreach (TableLogOnInfo cnInfo in this.CrystalReportViewer1.LogOnInfo)
{
cnInfo.ConnectionInfo = ConnInfo;
}
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
paramField.ParameterFieldName = "pcascode";
if (Request.QueryString["pcascode"] != null || Request.QueryString["pcascode"] != "")
{
discreteVal.Value = Request.QueryString["pcascode"];
}
paramField.CurrentValues.Add(discreteVal);
paramFields.Add(paramField);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
CrystalReportViewer1.PrintMode = CrystalDecisions.Web.PrintMode.Pdf;
}
else
{
Response.Redirect("~/AccessDenied.aspx");
}
}
else
{
Response.Redirect("~/AccessDenied.aspx");
}
}
else
{
Response.Redirect("~/AccessDenied.aspx");
}
}
else
{
Response.Redirect("~/AccessDenied.aspx");
}
}
}
