private void LoadDetails()
{
using (clsCATARequest objCATARequest = new clsCATARequest())
{
objCATARequest.CataCode = Request.QueryString["catacode"];
objCATARequest.Fill();
lblCATANo.Text = objCATARequest.CataCode;
lblPayee.Text = clsEmployee.GetName(objCATARequest.RequestedBy);
lblRequestOn.Text = objCATARequest.CreateOn.ToString();
lblDaeNeeded.Text = objCATARequest.DateNeeded.ToShortDateString();
lblAcquiremode.Text = (objCATARequest.AcquireMode == "P") ? "For Pickup" : "For Deposit";
lblChargedToSchool.Text = clsSchool.GetSchoolName(objCATARequest.SchoolCode);
lblChargedToRC.Text = clsRC.GetRCName(objCATARequest.RcCode);
lblChargedToOthers.Text = objCATARequest.Other;
lblFrom.Text = objCATARequest.LocationFrom;
lblTo.Text = objCATARequest.LocationTo;
lblDays.Text = objCATARequest.NumberOfDays.ToString();
lblDepartureDate.Text = objCATARequest.Departure.ToShortDateString();
lblDepartureTime.Text = objCATARequest.Departure.ToShortTimeString();
lblArrivalDate.Text = objCATARequest.Arrival.ToShortDateString();
lblArrivalTime.Text = objCATARequest.Arrival.ToShortTimeString();
lblPurpose.Text = objCATARequest.TripPurpose;
strHotelName = objCATARequest.HotelName;
strPayee = objCATARequest.RequestedBy;
lblOBCode.Text = objCATARequest.ObCode;
}
}
protected void Page_Load(object sender, EventArgs e)
{
clsSpeedo.Authenticate();
btnBack.Attributes.Add("onClick", "javascript:history.back(); return false;");
if (!clsCATARequest.AuthenticateAccess(Request.Cookies["Speedo"]["UserName"], Request.QueryString["catacode"].ToString()))
{
if (!clsSystemModule.HasAccess("023", Request.Cookies["Speedo"]["UserName"].ToString()))
{
Response.Redirect("~/AccessDenied.aspx");
}
}
clsCATARequest objCataRequest = new clsCATARequest();
objCataRequest.CataCode = Request.QueryString["catacode"];
objCataRequest.Fill();
if (!Page.IsPostBack)
{
if (objCataRequest.Status != "0")
{
if (clsCATAApproval.CountDisapprove(objCataRequest.CataCode) == 0)
{
if (clsCATAApproval.CountForApproval(objCataRequest.CataCode, "E") == 0)
{
if (clsCATAApproval.CountForApproval(objCataRequest.CataCode, "A") == 0)
{
//Report
//CrystalReportViewer1.Height = 600;
//ConnectionInfo ConnInfo = new ConnectionInfo();
//{
// ConnInfo.ServerName = "hades";
// ConnInfo.DatabaseName = "mystihq";
// ConnInfo.UserID = "usermystihq";
// ConnInfo.Password = "******";
//}
//CrystalReportViewer1.Height = 600;
//ConnectionInfo ConnInfo = new ConnectionInfo();
//{
// ConnInfo.ServerName = "medusa";
// ConnInfo.DatabaseName = "mystihq_20151119";
// ConnInfo.UserID = "sa";
// ConnInfo.Password = "******";
//}
//Report
CrystalReportViewer1.Height = 600;
ConnectionInfo ConnInfo = new ConnectionInfo();
{
ConnInfo.ServerName = "hades";
ConnInfo.DatabaseName = "mystihq";
ConnInfo.UserID = "sa";
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 = "catacode";
if (Request.QueryString["catacode"] != null || Request.QueryString["catacode"] != "")
{
discreteVal.Value = Request.QueryString["catacode"];
}
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");
}
}
}
public void LoadCATAParticulars()
{
string strWrite = "";
double dblTotal = 0;
using (clsCATARequest objCATARequest = new clsCATARequest())
{
objCATARequest.CataCode = Request.QueryString["catacode"];
objCATARequest.Fill();
strHotelName = objCATARequest.HotelName;
}
DataTable tblCATAType = clsCATAType.GetDSLUsed(lblCATANo.Text);
{
foreach (DataRow drw in tblCATAType.Rows)
{
strWrite += "<tr>" +
"<td class='GridRowsGray' style='text-align:left;padding:3'><b>" + drw["pText"].ToString() + "</b></td>" +
"</tr>";
DataTable tblRequestDetails = clsCATADetails.GetCATADetails(drw["pValue"].ToString(), lblCATANo.Text);
{
foreach (DataRow drwDetails in tblRequestDetails.Rows)
{
if (drw["pValue"].ToString() == "01")
{
strWrite += "<tr>" +
"<td class='GridRows'>" +
"<table width='90%'>" +
"<tr>" +
"<td style='width:60%;text-align:left;text-indent:150px;'>" + clsCATASubtype.GetName(drwDetails["SubTypeCode"].ToString()) + " : " + strHotelName + " (Rate/Day: " + string.Format("{0:n2}", double.Parse(clsCATASettings.GetAmount("01", drwDetails["SubTypeCode"].ToString(), clsEmployee.GetJobGrade(strPayee)))) + ")</td>" +
"<td style='width:40%;text-align: right;'>" + string.Format("{0:n2}", double.Parse(drwDetails["Amount"].ToString())) + "</td>" +
"</tr>" +
"</table>" +
"</td>" +
"</tr>" +
"<tr>";
//"<td td class='GridRows'>" +
// "<table width='90%'>" +
// "<tr>" +
// "<td style='width:60%;text-indent:250px;'>Rate/Day:</td>" +
// "<td style='width:40%;text-align: right: padding-right:150px;'>" + string.Format("{0:n2}", double.Parse(clsCATASettings.GetAmount("01", drwDetails["SubTypeCode"].ToString(), clsEmployee.GetJobGrade(strPayee)))) + "</td>" +
// "</tr>" +
// "</table>" +
// "</td>" +
//"</tr>";
}
else
{
strWrite += "<tr>" +
"<td class='GridRows'>" +
"<table width='90%'>" +
"<tr>" +
"<td style='width:60%;text-align:left;text-indent:150px;'>" + clsCATASubtype.GetName(drwDetails["SubTypeCode"].ToString()) + "</td>" +
"<td style='width:40%;text-align: right;'>" + string.Format("{0:n2}", double.Parse(drwDetails["Amount"].ToString())) + "</td>" +
"</tr>" +
"</table>" +
"</td>" +
"</tr>";
}
dblTotal = dblTotal + Convert.ToDouble(drwDetails["Amount"].ToString());
}
}
}
}
DataTable tblIncidentals = clsCATAIncedental.GetDSGMainForm(Request.QueryString["catacode"]);
{
if (tblIncidentals.Rows.Count != 0)
{
strWrite += "<tr>" +
"<td class='GridRowsGray' style='text-align:left;padding:3'><b>Incidentals</b></td>" +
"</tr>";
foreach (DataRow drwIncidentals in tblIncidentals.Rows)
{
strWrite += "<tr>" +
"<td class='GridRows'>" +
"<table width='90%'>" +
"<tr>" +
"<td style='width:60%;text-align:left;text-indent:150px;'>" + drwIncidentals["incdental"].ToString() + "</td>" +
"<td style='width:40%;text-align: right;'>" + string.Format("{0:n2}", double.Parse(drwIncidentals["Amount"].ToString())) + "</td>" +
"</tr>" +
"</table>" +
"</td>" +
"</tr>";
dblTotal = dblTotal + Convert.ToDouble(drwIncidentals["Amount"].ToString());
}
}
strWrite += "<tr>" +
"<td class='GridRowsGray'>" +
"<table width='90%'>" +
"<tr>" +
"<td style='width:60%;text-align:left;'><b>TOTAL</b></td>" +
"<td style='width:40%;text-align: right;'><b>P " + string.Format("{0:n2}", dblTotal) + "</b></td>" +
"</tr>" +
"</table>" +
"</td>" +
"</tr>";
}
Response.Write(strWrite);
}
protected void Save(string strType)
{
divError.Visible = false;
if (ValidateDate() == false)
{
return;
}
if (ValidateApprovers() == false)
{
return;
}
DataTable tblRepresentation = ViewState["CartRepresentation"] as DataTable;
DataTable tblIncidental = ViewState["CartIncedentals"] as DataTable;
CATASum();
clsCATARequest CataRequest = new clsCATARequest();
CataRequest.SchoolCode = (ddlSchool.SelectedValue.ToString() != "") ? ddlSchool.SelectedValue.ToString() : string.Empty;
CataRequest.RcCode = (ddlRc.SelectedValue.ToString() != "") ? ddlRc.SelectedValue.ToString() : string.Empty;
CataRequest.Other = (txtOthers.Text.Trim() != "") ? txtOthers.Text.Trim() : string.Empty;
CataRequest.LocationFrom = txtDestinationFrom.Text.Trim();
CataRequest.LocationTo = txtDestinationTo.Text.Trim();
CataRequest.NumberOfDays = double.Parse(txtDays.Text.Trim());
CataRequest.Departure = clsDateTime.CombineDateTime(dtDateDeparture.SelectedDate, dtTimeDeparture.SelectedTime);
CataRequest.Arrival = clsDateTime.CombineDateTime(dtDateArrival.SelectedDate, dtTimeArrival.SelectedTime);
CataRequest.HotelName = txtHotelName.Text.Trim();
CataRequest.TripPurpose = txtPurpose.Text.Trim();
CataRequest.DateNeeded = dtDateCheckNeeded.SelectedDate;
CataRequest.AcquireMode = ddlAcquiremode.SelectedValue.ToString();
CataRequest.CataAmount = double.Parse(string.Format("{0:0.00}", double.Parse(txtTotalCATAAmount.Text.Trim())));
CataRequest.RequestedBy = ddlExecutive.SelectedValue.ToString();
CataRequest.ObCode = "";
DataTable tblApprovers = new DataTable();
tblApprovers.Columns.Add("Username");
tblApprovers.Columns.Add("ApproverOrder");
tblApprovers.Columns.Add("ApproverType");
tblApprovers.Columns.Add("StatusCode");
int intCount = 0;
if (ddlEndorsedBy1.SelectedValue != string.Empty)
{
intCount++;
DataRow drNewRow = tblApprovers.NewRow();
drNewRow["Username"] = ddlEndorsedBy1.SelectedValue;
drNewRow["ApproverOrder"] = intCount;
drNewRow["ApproverType"] = "E";
drNewRow["StatusCode"] = hdnUsername.Value == ddlEndorsedBy1.SelectedValue ? "1" : "0";
tblApprovers.Rows.Add(drNewRow);
}
if (ddlEndorsedBy2.SelectedValue != string.Empty)
{
intCount++;
DataRow drNewRow = tblApprovers.NewRow();
drNewRow["Username"] = ddlEndorsedBy2.SelectedValue;
drNewRow["ApproverOrder"] = intCount;
drNewRow["ApproverType"] = "E";
drNewRow["StatusCode"] = hdnUsername.Value == ddlEndorsedBy2.SelectedValue ? "1" : "0";
tblApprovers.Rows.Add(drNewRow);
}
intCount++;
DataRow drNewRow1 = tblApprovers.NewRow();
drNewRow1["Username"] = ddlDivisionHead.SelectedValue.ToString();
drNewRow1["ApproverOrder"] = intCount;
drNewRow1["ApproverType"] = "A";
drNewRow1["StatusCode"] = hdnUsername.Value == ddlDivisionHead.SelectedValue.ToString() ? "1" : "0";
tblApprovers.Rows.Add(drNewRow1);
if (ddlAuthorizeby2.SelectedValue != string.Empty)
{
intCount++;
DataRow drNewRow = tblApprovers.NewRow();
drNewRow["Username"] = ddlAuthorizeby2.SelectedValue;
drNewRow["ApproverOrder"] = intCount;
drNewRow["ApproverType"] = "A";
drNewRow["StatusCode"] = hdnUsername.Value == ddlAuthorizeby2.SelectedValue ? "1" : "0";
tblApprovers.Rows.Add(drNewRow);
}
foreach (DataRow drFinanceApprover in clsCATAFinanceApprovers.GetDSG().Rows)
{
intCount++;
DataRow drNewRow = tblApprovers.NewRow();
drNewRow["Username"] = drFinanceApprover["aprvname"].ToString();
drNewRow["ApproverOrder"] = intCount;
drNewRow["ApproverType"] = "F";
drNewRow["StatusCode"] = "0";
tblApprovers.Rows.Add(drNewRow);
}
CataRequest.Status = strType == "Edit" ? "0" : "1";
CataRequest.CreateBy = Request.Cookies["Speedo"]["UserName"];
CataRequest.CreateOn = DateTime.Now;
CataRequest.ModifyBy = Request.Cookies["Speedo"]["UserName"];
CataRequest.ModifyOn = DateTime.Now;
DataTable tblTerminalFee = new DataTable();
tblTerminalFee.Columns.Add("TerminalFeeCode");
tblTerminalFee.Columns.Add("TerminalRate");
foreach (ListItem itm in cblTerminalFee.Items)
{
if (itm.Selected)
{
DataRow drTerminalFee = tblTerminalFee.NewRow();
drTerminalFee["TerminalFeeCode"] = itm.Value.ToInt();
drTerminalFee["TerminalRate"] = clsFinanceTerminalFee.GetAmount(itm.Value.ToInt());
tblTerminalFee.Rows.Add(drTerminalFee);
}
}
if (CataRequest.Insert(GetRequest(), tblApprovers, tblIncidental, tblRepresentation, tblTerminalFee) > 0)
{
EmptyTextBoxValues(this);
chkbAir.Checked = false;
chkbLand.Checked = false;
chkbSea.Checked = false;
dgIncedentals.DataSource = null;
dgIncedentals.DataBind();
dgRepresentation.DataSource = null;
dgRepresentation.DataBind();
Response.Redirect("FinanceCataMenu.aspx");
}
}