protected bool ValidateAmount()
{
bool blnReturn = false;
double dblCartSumValidator = 0;
DataTable tblCartSUmValidator = ViewState["CartItems"] as DataTable;
foreach (DataRow drw in tblCartSUmValidator.Rows)
{
using (clsPCASRequestDetails objRequestDetails = new clsPCASRequestDetails())
{
dblCartSumValidator = dblCartSumValidator + Convert.ToDouble(drw["amount"]);
}
}
if (dblCartSumValidator <= 1000)
{
if (dgItems.Items.Count != 0)
{
blnReturn = true;
}
else
{
divError.Visible = true;
lblErrMsg.Text = "No items found.";
}
}
else
{
divError.Visible = true;
lblErrMsg.Text = "The PCAS Amount should not be greater than 1,000.00 Pesos.";
}
return(blnReturn);
}
protected void LoadDetails()
{
DataTable tblDetails = clsPCASRequestAllocation.GetDSGMainForm(Request.QueryString["pcascode"]);
ViewState["Cart"] = tblDetails;
DataTable tblCartdg = ViewState["Cartdg"] as DataTable;
foreach (DataRow drw in tblDetails.Rows)
{
DataRow drowCartdg = tblCartdg.NewRow();
drowCartdg["aexpname"] = drw["aexpname"];
string strChargedTo = "";
if (drw["schlcode"].ToString().Trim() != "")
{
strChargedTo = clsSchool.GetSchoolName(drw["schlcode"].ToString().Trim());
}
if (drw["rccode"].ToString().Trim() != "")
{
strChargedTo = clsRC.GetRCName(drw["rccode"].ToString().Trim());
}
if (drw["others"].ToString().Trim() != "")
{
strChargedTo = drw["others"].ToString().Trim();
}
double dblAmount = double.Parse(drw["amount"].ToString());
drowCartdg["chargeto"] = strChargedTo;
drowCartdg["amount"] = string.Format("{0:0,0.00}", dblAmount);
tblCartdg.Rows.Add(drowCartdg);
}
ViewState["Cartdg"] = tblCartdg;
dgItems.DataSource = tblCartdg;
dgItems.DataBind();
//added 2013-09-02
double dblCartSum = 0;
DataTable tblCartSUm = ViewState["Cart"] as DataTable;
foreach (DataRow drw in tblCartSUm.Rows)
{
using (clsPCASRequestDetails objRequestDetails = new clsPCASRequestDetails())
{
dblCartSum = dblCartSum + Convert.ToDouble(drw["amount"]);
}
}
//txtRequestAmount.Text = string.Format("{0:0,0.00}", dblCartSum);
txtRequestAmount.Text = string.Format("{0:0.00}", dblCartSum);
}
protected void dgItems_DeleteCommand(object source, DataGridCommandEventArgs e)
{
try
{
DataTable tblCart = ViewState["Cart"] as DataTable;
DataTable tblCartdg = ViewState["Cartdg"] as DataTable;
tblCart.Rows[e.Item.ItemIndex].Delete();
tblCartdg.Rows[e.Item.ItemIndex].Delete();
tblCart.AcceptChanges();
tblCartdg.AcceptChanges();
ViewState["Cartdg"] = tblCartdg;
ViewState["Cart"] = tblCart;
dgItems.DataSource = tblCartdg;
dgItems.DataBind();
//added 2013-09-02
double dblCartSum = 0;
DataTable tblCartSUm = ViewState["Cart"] as DataTable;
foreach (DataRow drw in tblCartSUm.Rows)
{
using (clsPCASRequestDetails objRequestDetails = new clsPCASRequestDetails())
{
dblCartSum = dblCartSum + Convert.ToDouble(drw["amount"]);
}
}
//txtRequestAmount.Text = string.Format("{0:0,0.00}", dblCartSum);
txtRequestAmount.Text = string.Format("{0:0.00}", dblCartSum);
//trNoRequest.Visible = dgItems.Items.Count == 0;
try
{
txtNet.Text = (Convert.ToDouble(txtApprovedRFA.Text) - Convert.ToDouble(txtAmountAllocated.Text)).ToString();
}
catch { }
try
{
//txtRemainingBudget.Text = (Convert.ToDouble(txtNet.Text) - Convert.ToDouble(txtRequestAmount.Text)).ToString();
}
catch { }
}
catch
{
Response.Redirect("PettyCashRequestCashierMenu.aspx");
}
}
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 btnSaveAdd_Click(object sender, EventArgs e)
{
try
{
if (dgItems.Items.Count <= 13)
{
DataTable tblCart = ViewState["Cart"] as DataTable;
DataRow drowCart = tblCart.NewRow();
double dblAmount = Convert.ToDouble(txtAmount.Text);
drowCart["aexpcode"] = ddlAccountExpenses.SelectedValue.ToString();
drowCart["schlcode"] = (ddlChargeTo.SelectedValue == "School") ? ddlSchool.SelectedValue.ToString() : "";
drowCart["rccode"] = (ddlChargeTo.SelectedValue == "Rc Group") ? ddlRcCode.SelectedValue.ToString() : "";
drowCart["others"] = (ddlChargeTo.SelectedValue == "Others") ? txtOthers.Text.Trim().ToString() : "";
drowCart["amount"] = string.Format("{0:0,0.00}", dblAmount);
tblCart.Rows.Add(drowCart);
//display in datagrid
DataTable tblCartdg = ViewState["Cartdg"] as DataTable;
DataRow drowCartdg = tblCartdg.NewRow();
drowCartdg["aexpname"] = clsFinanceAccountExpenses.GetAccountExpenseName(ddlAccountExpenses.SelectedValue.ToString());
string strChargedTo = "";
if (ddlChargeTo.SelectedValue == "School")
//{ strChargedTo = clsFinanceAccountDueFrom.GetDueFromName(ddlSchool.SelectedValue.ToString()); }
{
strChargedTo = clsFinanceAccountDueFrom.GetDueFromName(ddlSchool.SelectedValue.ToString());
}
if (ddlChargeTo.SelectedValue == "Rc Group")
{
strChargedTo = clsRC.GetRCName(ddlRcCode.SelectedValue.ToString());
}
if (ddlChargeTo.SelectedValue == "Others")
{
strChargedTo = txtOthers.Text.Trim();
}
drowCartdg["chargeto"] = strChargedTo;
drowCartdg["amount"] = string.Format("{0:0,0.00}", dblAmount);
tblCartdg.Rows.Add(drowCartdg);
dgItems.DataSource = tblCartdg;
dgItems.DataBind();
//add to temporary memory
ViewState["Cart"] = tblCart;
ViewState["Cartdg"] = tblCartdg;
//txtItemDescription.Text = "";
txtAmount.Text = "";
//added 2013-09-02
double dblCartSum = 0;
DataTable tblCartSUm = ViewState["Cart"] as DataTable;
foreach (DataRow drw in tblCartSUm.Rows)
{
using (clsPCASRequestDetails objRequestDetails = new clsPCASRequestDetails())
{
dblCartSum = dblCartSum + Convert.ToDouble(drw["amount"]);
}
}
//txtRequestAmount.Text = string.Format("{0:0,0.00}", dblCartSum);
txtRequestAmount.Text = string.Format("{0:0.00}", dblCartSum);
}
else
{
divError.Visible = true;
lblErrMsg.Text = "Unable to add item to request list.<br>" +
"<table>" +
"<tr>" +
"<td style='vertical-align:top;'><b>Reason:</b></td>" +
"<td>A maximum of <b>thirteen(13)</b> items can be added in request list.</td>" +
"</tr>" +
"</table>";
return;
}
try
{
txtNet.Text = (Convert.ToDouble(txtApprovedRFA.Text) - Convert.ToDouble(txtAmountAllocated.Text)).ToString();
}
catch { }
try
{
//txtRemainingBudget.Text = (Convert.ToDouble(txtNet.Text) - Convert.ToDouble(txtRequestAmount.Text)).ToString();
}
catch { }
}
catch
{
Response.Redirect("PettyCashRequestDetailsApprover.aspx");
}
}
