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