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