/// <summary>
/// We have parsed the 'General' element so now parse the items
/// within this section noting that we terminate parsing when we reach the end
/// of the section.
/// </summary>
/// <param name="xmlElement"></param>
protected void ReadGeneral(XmlSimpleElement xmlSimpleElement)
{
foreach (XmlSimpleElement childElement in xmlSimpleElement.ChildElements)
{
switch (childElement.TagName)
{
case V_GENERAL_AUTHOR:
_author = childElement.Text;
break;
case V_GENERAL_TYPE:
_reportType = (eReportType)childElement.TextAsInt;
break;
case V_GENERAL_NAME:
_name = childElement.Text;
break;
case V_GENERAL_DESCRIPTION:
_description = childElement.Text;
break;
case V_GENERAL_VERSION:
_currentVersion = childElement.Text;
break;
default:
break;
}
}
}
private string GenerateBodyText(XmlDocument doc, eReportType reportType, string reportUrl)
{
string companyName = System.Configuration.ConfigurationManager.AppSettings["CompanyName"];
string addressLine1 = System.Configuration.ConfigurationManager.AppSettings["Address1.Line1"];
string addressLine2 = System.Configuration.ConfigurationManager.AppSettings["Address1.Line2"];
string addressLine3 = System.Configuration.ConfigurationManager.AppSettings["Address1.Line3"];
string companyLogoImageName = System.Configuration.ConfigurationManager.AppSettings["CompanyLogoImageName"];
XslCompiledTransform transformer = new XslCompiledTransform();
transformer.Load(HttpContext.Current.Server.MapPath(@"~/xsl/reportType.xsl"));
XmlUrlResolver resolver = new XmlUrlResolver();
XPathNavigator navigator = doc.CreateNavigator();
XsltArgumentList args = new XsltArgumentList();
args.AddParam("WebServer", "", Orchestrator.Globals.Configuration.WebServer);
args.AddParam("ReportType", "", Utilities.UnCamelCase(Enum.GetName(typeof(eReportType), reportType)));
args.AddParam("ReportUrl", "", reportUrl);
args.AddParam("CompanyName", "", companyName);
args.AddParam("AddressLine1", "", addressLine1);
args.AddParam("AddressLine2", "", addressLine2);
args.AddParam("AddressLine3", "", addressLine3);
args.AddParam("CompanyLogoImageName", "", "cid:" + companyLogoImageName);
StringWriter sw = new StringWriter();
transformer.Transform(navigator, args, sw);
string content = sw.GetStringBuilder().ToString();
return(content);
}
private void LoadPILReport()
{
NameValueCollection reportParams = new NameValueCollection();
DataSet dsPIL = null;
string OrderIDs = string.Empty;
bool isPalletNetwork = false;
foreach (GridDataItem item in grdOrders.SelectedItems)
{
isPalletNetwork = (bool)item.OwnerTableView.DataKeyValues[item.ItemIndex]["IsPalletNetwork"];
OrderIDs += item.OwnerTableView.DataKeyValues[item.ItemIndex]["OrderID"].ToString();
OrderIDs += ",";
}
Orchestrator.Facade.ICollectDropLoadOrder facLoadOrder = new Orchestrator.Facade.CollectDrop();
if (OrderIDs.Length > 0)
{
#region Pop-up Report
eReportType reportType = eReportType.PIL;
dsPIL = facLoadOrder.GetPILData(OrderIDs.ToString());
DataView dvPIL;
if (isPalletNetwork)
{
reportType = Orchestrator.Globals.Configuration.PalletNetworkLabelID;
//Need to duplicate the rows for the Pallteforce labels
dsPIL.Tables[0].Merge(dsPIL.Tables[0].Copy(), true);
dvPIL = new DataView(dsPIL.Tables[0], string.Empty, "OrderId, PalletCount", DataViewRowState.CurrentRows);
}
else
{
dvPIL = new DataView(dsPIL.Tables[0]);
}
//-------------------------------------------------------------------------------------
// Load Report Section
//-------------------------------------------------------------------------------------
Session[Orchestrator.Globals.Constants.ReportTypeSessionVariable] = reportType;
Session[Orchestrator.Globals.Constants.ReportParamsSessionVariable] = reportParams;
Session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable] = dvPIL;
Session[Orchestrator.Globals.Constants.ReportDataSessionSortVariable] = String.Empty;
Session[Orchestrator.Globals.Constants.ReportDataMemberSessionVariable] = "Table";
// Show the user control
Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", "<script language=\"javascript\">window.open('" + Page.ResolveClientUrl("../reports/reportviewer.aspx?wiz=true") + "');</script>");
#endregion
}
}
void btnCreatePIL_Click(object sender, EventArgs e)
{
NameValueCollection reportParams = new NameValueCollection();
DataSet dsPIL = null;
Orchestrator.Facade.ICollectDropLoadOrder facLoadOrder = new Orchestrator.Facade.CollectDrop();
if (OrderID != -1)
{
#region Pop-up Report
eReportType reportType = eReportType.PIL;
dsPIL = facLoadOrder.GetPILData(OrderID.ToString());
DataView dvPIL;
if ((bool)dsPIL.Tables[0].Rows[0]["IsPalletNetwork"])
{
reportType = Globals.Configuration.PalletNetworkLabelID;
//Need to duplicate the rows for the Pallteforce labels
dsPIL.Tables[0].Merge(dsPIL.Tables[0].Copy(), true);
dvPIL = new DataView(dsPIL.Tables[0], string.Empty, "OrderId, PalletCount", DataViewRowState.CurrentRows);
}
else
{
dvPIL = new DataView(dsPIL.Tables[0]);
}
//-------------------------------------------------------------------------------------
// Load Report Section
//-------------------------------------------------------------------------------------
Session[Orchestrator.Globals.Constants.ReportTypeSessionVariable] = reportType;
Session[Orchestrator.Globals.Constants.ReportParamsSessionVariable] = reportParams;
Session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable] = dvPIL;
Session[Orchestrator.Globals.Constants.ReportDataSessionSortVariable] = String.Empty;
Session[Orchestrator.Globals.Constants.ReportDataMemberSessionVariable] = "Table";
//string url = this.Request.Url.AbsoluteUri;
//if (url.LastIndexOf("&action") > 0)
// url = url.Remove(url.LastIndexOf("&action"));
//Response.Redirect(url + "&action=pil");
Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", "window.open('" + Page.ResolveClientUrl("../reports/reportviewer.aspx?wiz=true") + "');", true);
#endregion
}
}
private ReportBase GetCurrentActiveReport(out eReportType reportType)
{
var session = HttpContext.Current.Session;
ReportBase activeReport = null;
bool enforceDataExistence;
reportType = (eReportType)session[Orchestrator.Globals.Constants.ReportTypeSessionVariable];
activeReport = Orchestrator.Reports.Utilities.GetActiveReport(reportType, string.Empty, out enforceDataExistence);
if (activeReport != null)
{
DataView view = null;
DataSet ds = null;
var dse = session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable];
if (dse is DataView)
{
activeReport.DataSource = dse;
}
else
{
ds = (DataSet)session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable];
}
var sortExpression = (string)session[Orchestrator.Globals.Constants.ReportDataSessionSortVariable];
if (sortExpression.Length > 0 && dse is DataSet)
{
view = new DataView(ds.Tables[0]);
view.Sort = sortExpression;
activeReport.DataSource = view;
}
else if (dse is DataSet)
{
activeReport.DataSource = ds;
}
activeReport.DataMember = (string)session[Orchestrator.Globals.Constants.ReportDataMemberSessionVariable];
activeReport.Document.Printer.PrinterName = string.Empty;
activeReport.Document.Printer.PaperKind = System.Drawing.Printing.PaperKind.A4;
activeReport.Run(false);
}
return(activeReport);
}
public void btnResend_Click(object sender, EventArgs e)
{
int count = int.MinValue;
long transactionId = long.MinValue;
string faxNumber = string.Empty;
eReportType reportType = 0;
InterFax.InterFax myInterFax;
count = dgFaxes.SelectedItems.Count;
if (count != 0)
{
// Should only have one select as this is multiple selects on the grid are not allowed.
foreach (ComponentArt.Web.UI.GridItem item in dgFaxes.SelectedItems)
{
transactionId = Convert.ToInt64(item["TransactionId"]);
faxNumber = item["FaxNumber"].ToString();
reportType = (eReportType)Enum.Parse(typeof(eReportType), item["Description"].ToString());
}
myInterFax = new InterFax.InterFax();
long returnedTransactionId = myInterFax.ReSendFax(Configuration.InterFaxUserName, Configuration.InterFaxPassword, transactionId, faxNumber);
if (returnedTransactionId > 0)
{
Facade.IAudit facAudit = new Facade.Audit();
facAudit.FaxSent(reportType, returnedTransactionId, faxNumber, ((Entities.CustomPrincipal)Page.User).UserName);
lblConfirmation.Text = "The fax was resent.";
// Cause the data to be updated.
BindFaxData();
}
else
{
lblConfirmation.Text = "The fax was not resent.";
Orchestrator.Logging.ApplicationLog.WriteError("Orchestrator.WebUI.adminstration.audit.sentFaxes.ResendFax", "Fax resend failed: " + returnedTransactionId);
}
lblConfirmation.Visible = true;
}
}
private int SaveReportPdf(eReportType reportType, byte[] bytes, string userName)
{
var uploaderPath = Globals.Configuration.OrchestratorServerUploaderPdfsPath;
if (string.IsNullOrEmpty(uploaderPath))
{
throw new ApplicationException("Cannot email report: the OrchestratorServerUploaderPdfsPath setting has not been configured.");
}
if (!Directory.Exists(uploaderPath))
{
Directory.CreateDirectory(uploaderPath);
}
var sendNowPath = Path.Combine(uploaderPath, "sendnow");
if (!Directory.Exists(sendNowPath))
{
Directory.CreateDirectory(sendNowPath);
}
var fileName = string.Format("EmailedReport_{0}_{1}_{2:yyyyMMddHHmmss}.pdf", Enum.GetName(typeof(eReportType), reportType), userName, DateTime.Now);
var fileNameAndPath = Globals.Configuration.ScanFormSendNow ? Path.Combine(sendNowPath, fileName) : Path.Combine(uploaderPath, fileName);
File.WriteAllBytes(fileNameAndPath, bytes);
var facForm = new Facade.Form();
var bookingForm = new Entities.Scan
{
ScannedDateTime = DateTime.Today,
FormTypeId = eFormTypeId.EmailedReport,
ScannedFormPDF = fileName,
IsAppend = false,
IsUploaded = false,
};
var scannedFormID = facForm.Create(bookingForm, userName);
return(scannedFormID);
}
void btnPIL_Click(object sender, EventArgs e)
{
NameValueCollection reportParams = new NameValueCollection();
DataSet dsPIL = null;
Orchestrator.Facade.ICollectDropLoadOrder facLoadOrder = new Orchestrator.Facade.CollectDrop();
if (OrderID > 0)
{
#region Pop-up Report
eReportType reportType = eReportType.PIL;
dsPIL = facLoadOrder.GetPILData(OrderID.ToString());
DataView dvPIL;
if ((bool)dsPIL.Tables[0].Rows[0]["IsPalletNetwork"])
{
reportType = Globals.Configuration.PalletNetworkLabelID;;
//Need to duplicate the rows for the Pallteforce labels
dsPIL.Tables[0].Merge(dsPIL.Tables[0].Copy(), true);
dvPIL = new DataView(dsPIL.Tables[0], string.Empty, "OrderId, PalletCount", DataViewRowState.CurrentRows);
}
else
{
dvPIL = new DataView(dsPIL.Tables[0]);
}
Session[Orchestrator.Globals.Constants.ReportTypeSessionVariable] = reportType;
Session[Orchestrator.Globals.Constants.ReportParamsSessionVariable] = reportParams;
Session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable] = dvPIL;
Session[Orchestrator.Globals.Constants.ReportDataSessionSortVariable] = String.Empty;
Session[Orchestrator.Globals.Constants.ReportDataMemberSessionVariable] = "Table";
// Show the user control
Page.ClientScript.RegisterStartupScript(this.GetType(), "onload", "<script language=\"javascript\">window.open('" + Page.ResolveClientUrl("../reports/reportviewer.aspx?wiz=true") + "');</script>");
#endregion
}
}
/// <summary>
/// Load Report Depending On Invoice Type
/// </summary>
private ReportBase LoadReport()
{
// Configure the Session variables used to pass data to the report
NameValueCollection reportParams = new NameValueCollection();
//-------------------------------------------------------------------------------------
// Job/Collect-Drops/References/Demurrages Section
//-------------------------------------------------------------------------------------
Facade.IInvoice facInv = new Facade.Invoice();
DataSet dsInv = null;
if (m_isUpdate)
{
dsInv = facInv.GetJobsForInvoiceId(Convert.ToInt32(lblInvoiceNo.Text));
}
else
{
dsInv = facInv.GetJobsToInvoice(m_jobIdCSV);
}
reportParams.Add("JobIds", m_jobIdCSV);
reportParams.Add("ExtraIds", m_extraIdCSV);
//-------------------------------------------------------------------------------------
// Param Section
//-------------------------------------------------------------------------------------
// Fuel Type & Rate
eInvoiceDisplayMethod fuelType;
decimal newRate = 0;
if (chkIncludeFuelSurcharge.Checked)
{
reportParams.Add("Fuel", "Include");
// Pass The New Rate To Report if so...
newRate = Convert.ToDecimal(txtFuelSurchargeRate.Text);
reportParams.Add("FuelRate", newRate.ToString());
// Pass FuelSurchargeType
fuelType = (eInvoiceDisplayMethod)Enum.Parse(typeof(eInvoiceDisplayMethod), rdoFuelSurchargeType.SelectedValue);
reportParams.Add("FuelType", fuelType.ToString());
}
// Override
if (chkOverride.Checked)
{
reportParams.Add("Override", "Include");
reportParams.Add("OverrideVAT", txtOverrideVAT.Text);
reportParams.Add("OverrideNET", txtOverrideNetAmount.Text);
reportParams.Add("OverrideGross", txtOverrideGrossAmount.Text);
reportParams.Add("OverrideReason", txtOverrideReason.Text);
}
// PODs
if (chkIncludePODs.Checked)
{
reportParams.Add("PODs", "Include");
}
// References
if (chkIncludeReferences.Checked)
{
reportParams.Add("References", "Include");
}
// Job
if (chkJobDetails.Checked)
{
reportParams.Add("JobDetails", "Include");
// Demuragge
if (chkIncludeDemurrage.Checked)
{
reportParams.Add("Demurrage", "Include");
// Demurrage Type
try
{
eInvoiceDisplayMethod demurrageType = (eInvoiceDisplayMethod)Enum.Parse(typeof(eInvoiceDisplayMethod), rdoDemurrageType.SelectedValue);
reportParams.Add("DemurrageType", demurrageType.ToString());
}
catch (Exception) { }
}
}
if (pnlExtras.Visible)
{
reportParams.Add("ExtraIds", Convert.ToString(ViewState["ExtraIdCSV"]));
reportParams.Add("Extras", "Include");
}
// Extra details
if (chkExtraDetails.Visible && chkExtraDetails.Checked)
{
reportParams.Add("ExtraDetail", "include");
}
// Self Bill Invoice Number
if ((eInvoiceType)Enum.Parse(typeof(eInvoiceType), lblInvoiceType.Text) == eInvoiceType.SelfBill)
{
reportParams.Add("InvoiceType", "SelfBill");
reportParams.Add("SelfBillInvoiceNumber", txtClientSelfBillInvoiceNumber.Text);
}
else
{
reportParams.Add("InvoiceType", "Normal");
}
// Client Name & Id
if (m_isUpdate)
{
Facade.IInvoice facClient = new Facade.Invoice();
DataSet ds = facClient.GetClientForInvoiceId(Convert.ToInt32(lblInvoiceNo.Text));
try
{
reportParams.Add("Client", Convert.ToString(ds.Tables[0].Rows[0]["Client"]));
reportParams.Add("ClientId", Convert.ToString(ds.Tables[0].Rows[0]["ClientId"]));
m_clientId = int.Parse(ds.Tables[0].Rows[0]["ClientId"].ToString());
if (!chkPostToExchequer.Checked)
{
btnSendToAccounts.Visible = true;
pnlInvoiceDeleted.Visible = true;
}
}
catch
{
}
}
else
{
if (Convert.ToString(Session["ClientName"]) != "")
{
reportParams.Add("Client", Convert.ToString(Session["ClientName"]));
}
if (Convert.ToString(Session["ClientId"]) != "")
{
reportParams.Add("ClientId", Convert.ToString(Session["ClientId"]));
}
if (m_clientId == 0)
{
m_clientId = int.Parse(Session["ClientId"].ToString());
}
else
{
Facade.IOrganisation facOrg = new Facade.Organisation();
Entities.Organisation enOrg = new Entities.Organisation();
enOrg = facOrg.GetForIdentityId(m_clientId);
reportParams.Add("Client", enOrg.OrganisationName.ToString());
reportParams.Add("ClientId", m_clientId.ToString());
}
}
// Date Range
if (Convert.ToDateTime(Session["StartDate"]).Date != DateTime.MinValue)
{
reportParams.Add("startDate", Convert.ToDateTime(Session["StartDate"]).ToString("dd/MM/yy"));
}
if (Convert.ToDateTime(Session["EndDate"]).Date != DateTime.MinValue)
{
reportParams.Add("endDate", Convert.ToDateTime(Session["EndDate"]).ToString("dd/MM/yy"));
}
// Invoice Id
if (lblInvoiceNo.Text != "To Be Issued ... (This invoice has not yet been saved, add invoice to allocate Invoice No.)")
{
reportParams.Add("invoiceId", lblInvoiceNo.Text);
}
else
{
reportParams.Add("invoiceId", "0");
}
// Posted To Accounts
if (chkPostToExchequer.Checked)
{
reportParams.Add("Accounts", "true");
}
int vatNo = 0;
decimal vatRate = 0.00M;
// VAT Rate
facInv.GetVatRateForVatType(eVATType.Standard, dteInvoiceDate.SelectedDate.Value, out vatNo, out vatRate);
reportParams.Add("VATrate", vatRate.ToString());
// Invoice Date
reportParams.Add("InvoiceDate", dteInvoiceDate.SelectedDate.Value.ToShortDateString());
//-------------------------------------------------------------------------------------
// Load Report Section
//-------------------------------------------------------------------------------------
Session[Orchestrator.Globals.Constants.ReportTypeSessionVariable] = eReportType.Invoice;
Session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable] = dsInv;
Session[Orchestrator.Globals.Constants.ReportDataSessionSortVariable] = rdoSortType.SelectedItem.Text.Replace(" ", "");
Session[Orchestrator.Globals.Constants.ReportDataMemberSessionVariable] = "Table";
Session[Orchestrator.Globals.Constants.ReportParamsSessionVariable] = reportParams;
Orchestrator.Reports.ReportBase activeReport = null;
eReportType reportType = 0;
reportType = (eReportType)Session[Orchestrator.Globals.Constants.ReportTypeSessionVariable];
try
{
activeReport = new Orchestrator.Reports.Invoicing.rptInvoice();
}
catch (NullReferenceException e)
{
Response.Write(e.Message);
Response.Flush();
return(null);
}
if (activeReport != null)
{
try
{
ApplicationLog.WriteTrace("Getting Data From Session Variable");
DataView view = null;
DataSet ds = (DataSet)Session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable];
string sortExpression = (string)Session[Orchestrator.Globals.Constants.ReportDataSessionSortVariable];
ApplicationLog.WriteTrace("sortExpression ::" + sortExpression);
try
{
if (sortExpression.Length > 0)
{
view = new DataView(ds.Tables[0]);
view.Sort = sortExpression;
activeReport.DataSource = view;
}
else
{
activeReport.DataSource = ds;
}
activeReport.DataMember = (string)Session[Orchestrator.Globals.Constants.ReportDataMemberSessionVariable];
}
catch (Exception eX)
{
this.Trace.Write("Err1:" + eX.Message);
ApplicationLog.WriteTrace("GetReport :: Err1:" + eX.Message);
}
activeReport.Document.Printer.PrinterName = string.Empty;
activeReport.Document.Printer.PaperKind = System.Drawing.Printing.PaperKind.A4;
//activeReport.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4;
//activeReport.PrintWidth = activeReport.PageSettings.PaperWidth - (activeReport.PageSettings.Margins.Right + activeReport.PageSettings.Margins.Left);
activeReport.Run(false);
}
catch (Exception e)
{
Response.Write(e.Message);
Response.Flush();
return(null);
}
}
Session[Orchestrator.Globals.Constants.ReportSessionVariable] = activeReport;
return(activeReport);
}
private void btnGetReport_Click(object sender, EventArgs e)
{
if (!base.ProcessValidationFormControls())
{
return;
}
int?DepartmentID = ucEmployeeFilter1.DepartmentID;
if (DepartmentID == -1)
{
DepartmentID = null;
}
int?DesignationID = ucEmployeeFilter1.DesignationID;
if (DesignationID == -1)
{
DesignationID = null;
}
int?LocationID = ucEmployeeFilter1.LocationID;
if (LocationID == -1)
{
LocationID = null;
}
int?EmployementTypeID = ucEmployeeFilter1.EmploymentType - 1;
if (EmployementTypeID == -1)
{
EmployementTypeID = null;
}
var ds = (new DAL.Payroll.EmployeeAttendanceDAL()).GetEmployeeAttendanceData(ucEmployeeFilter1.DateFrom, ucEmployeeFilter1.DateTo,
DepartmentID, DesignationID, LocationID, EmployementTypeID);
eReportType ReportType = (eReportType)cmbType.SelectedIndex;
switch (ReportType)
{
case eReportType.LateComing:
ds = ds.Where(r => r.LateIn).ToList();
break;
case eReportType.EarlyGoing:
ds = ds.Where(r => r.EarlyGoing).ToList();
break;
case eReportType.MissedPunch:
ds = ds.Where(r => r.MissedPunch).ToList();
break;
}
var filteredEmployees = (from r in ds
group r by r.EmployeeID into gr
select gr.Key);
DataTable dt = new DataTable("dsReport" + DateTime.Now.Ticks.ToString());
dt.Columns.Add("EmployeeNoPrefix", typeof(string));
dt.Columns.Add("EmployeeNo", typeof(int));
dt.Columns.Add("EmployeeName", typeof(string));
//dt.Columns.Add("DepartmentName", typeof(string));
//dt.Columns.Add("DesignationName", typeof(string));
//dt.Columns.Add("LocationName", typeof(string));
//dt.Columns.Add("EmployementType", typeof(string));
for (DateTime r = ucEmployeeFilter1.DateFrom; r <= ucEmployeeFilter1.DateTo; r = r.AddDays(1))
{
string dtname = r.ToString("ddMMyyyy");
dt.Columns.Add("ShiftName" + dtname, typeof(string));
if (ReportType != eReportType.EarlyGoing)
{
dt.Columns.Add("DTIN" + dtname, typeof(TimeSpan));
}
if (ReportType != eReportType.LateComing)
{
dt.Columns.Add("DTOUT" + dtname, typeof(TimeSpan));
}
}
foreach (var emp in filteredEmployees)
{
var Employee = dsEmployeeLookup.Find(r => r.EmployeeID == emp);
if (Employee == null || Employee.EmployeeID == -1)
{
continue;
}
DataRow dr = dt.Rows.Add();
//dr["EmployeeID"] = emp;
dr["EmployeeName"] = Employee.EmployeeName;
dr["EmployeeNoPrefix"] = Employee.EmployeeNoPrefix;
dr["EmployeeNo"] = Employee.EmployeeNo;
//dr["DepartmentName"] = Employee.Department;
//dr["DesignationName"] = Employee.Designation;
//dr["LocationName"] = Employee.Location;
//dr["EmployementType"] = Employee.EmployementType;
for (DateTime date = ucEmployeeFilter1.DateFrom; date <= ucEmployeeFilter1.DateTo; date = date.AddDays(1))
{
var attendances = ds.Where(r => r.EmployeeID == emp && r.Day == date);
foreach (var attendance in attendances)
{
if (attendance != null)
{
dr["ShiftName" + date.ToString("ddMMyyyy")] = attendance.EmployeeShiftName;
if (attendance.InTime != null && ReportType != eReportType.EarlyGoing)
{
dr["DTIN" + date.ToString("ddMMyyyy")] = attendance.InTime;
}
if (attendance.OutTime != null && ReportType != eReportType.LateComing)
{
dr["DTOUT" + date.ToString("ddMMyyyy")] = attendance.OutTime;
}
}
}
}
}
dt.DefaultView.Sort = "EmployeeNo";
ClearGrid();
gridControlData.DataSource = dt;//.DefaultView.ToTable();
txtNofRecords.EditValue = dt.Rows.Count;
GridBand EmployeeBand = new DevExpress.XtraGrid.Views.BandedGrid.GridBand()
{
Name = "EmployeeBand",
Caption = "Employee",
MinWidth = 100,
};
EmployeeBand.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridViewData.Bands.Add(EmployeeBand);
BandedGridColumn myGridColumn = null;
myGridColumn = gridViewData.Columns["EmployeeNoPrefix"];
myGridColumn.Caption = "Prefix";
myGridColumn.MinWidth = 70;
myGridColumn.MaxWidth = 100;
//myGridColumn.SortIndex = 0;
myGridColumn.OwnerBand = EmployeeBand;
myGridColumn.Width = 100;
myGridColumn.Visible = false;
myGridColumn = gridViewData.Columns["EmployeeNo"];
myGridColumn.Caption = "No.";
myGridColumn.MinWidth = 70;
myGridColumn.MaxWidth = 100;
//myGridColumn.SortIndex = 0;
myGridColumn.OwnerBand = EmployeeBand;
myGridColumn.Width = 100;
myGridColumn.Visible = true;
myGridColumn = gridViewData.Columns["EmployeeName"];
myGridColumn.Caption = "Name";
myGridColumn.MinWidth = 200;
//myGridColumn.MaxWidth = 500;
myGridColumn.OwnerBand = EmployeeBand;
myGridColumn.Visible = true;
myGridColumn.Width = 1000;
//myGridColumn = gridViewData.Columns["DepartmentName"];
//myGridColumn.Caption = "Department";
//myGridColumn.MinWidth = 100;
//myGridColumn.MaxWidth = 300;
//myGridColumn.OwnerBand = EmployeeBand;
//myGridColumn.Visible = false;
//myGridColumn = gridViewData.Columns["DesignationName"];
//myGridColumn.Caption = "Designation";
//myGridColumn.MinWidth = 100;
//myGridColumn.MaxWidth = 300;
//myGridColumn.OwnerBand = EmployeeBand;
//myGridColumn.Visible = false;
//myGridColumn = gridViewData.Columns["LocationName"];
//myGridColumn.Caption = "Location";
//myGridColumn.MinWidth = 100;
//myGridColumn.MaxWidth = 300;
//myGridColumn.OwnerBand = EmployeeBand;
//myGridColumn.Visible = false;
//myGridColumn = gridViewData.Columns["EmployementType"];
//myGridColumn.Caption = "Employement Type";
//myGridColumn.MinWidth = 70;
//myGridColumn.MaxWidth = 200;
//myGridColumn.OwnerBand = EmployeeBand;
//myGridColumn.Visible = false;
int ColumnIndex = 0;
for (DateTime r = ucEmployeeFilter1.DateFrom; r <= ucEmployeeFilter1.DateTo; r = r.AddDays(1))
{
string dtname = r.ToString("ddMMyyyy");
//--
GridBand DateBand = new GridBand()
{
Name = "DateBand" + dtname,
Caption = r.ToString("dd-MM-yyyy"),
};
DateBand.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridViewData.Bands.Add(DateBand);
//--
BandedGridColumn column = null;
Color AlternateBackColor = Color.WhiteSmoke;
column = gridViewData.Columns["ShiftName" + dtname];
column.Caption = "Shift";
column.MinWidth = 75;
column.MaxWidth = 300;
column.OwnerBand = DateBand;
column.Width = 100;
column.Visible = ShowShift;
if ((ColumnIndex % 2 == 0))
{
column.AppearanceCell.BackColor = AlternateBackColor;
}
if (ReportType != eReportType.EarlyGoing)
{
column = gridViewData.Columns["DTIN" + dtname];
column.Caption = "In";
column.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
column.DisplayFormat.FormatString = "hh\\:mm";
column.MinWidth = 55;
column.MaxWidth = 100;
column.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
column.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
column.OwnerBand = DateBand;
column.Width = 100;
column.Visible = true;
if ((ColumnIndex % 2 == 0))
{
column.AppearanceCell.BackColor = AlternateBackColor;
}
}
if (ReportType != eReportType.LateComing)
{
column = gridViewData.Columns["DTOUT" + dtname];
column.Caption = "Out";
column.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
column.DisplayFormat.FormatString = "hh\\:mm";
column.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
column.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
column.OwnerBand = DateBand;
column.MinWidth = 55;
column.MaxWidth = 100;
column.Width = 100;
column.Visible = true;
if ((ColumnIndex % 2 == 0))
{
column.AppearanceCell.BackColor = AlternateBackColor;
}
}
if (ReportType == eReportType.LateComing || ReportType == eReportType.EarlyGoing)
{
DateBand.Width = 100;
}
else
{
DateBand.Width = 200;
}
ColumnIndex++;
}
//--
gridControlData.RefreshDataSource();
gridViewData.BestFitColumns();
}
private ReportBase GetReport(HttpSessionState session, TraceContext trace, string reportParametersSessionKey, out bool noData)
{
ReportBase activeReport = null;
noData = false;
eReportType reportType = 0;
bool enforceDataExistence = false;
bool useReportParametersKey = !string.IsNullOrWhiteSpace(reportParametersSessionKey);
Hashtable htReportInformation = null;
try
{
if (useReportParametersKey)
{
htReportInformation = (Hashtable)session[reportParametersSessionKey];
reportType = (eReportType)htReportInformation[Orchestrator.Globals.Constants.ReportTypeSessionVariable];
}
else
{
reportType = (eReportType)session[Orchestrator.Globals.Constants.ReportTypeSessionVariable];
}
activeReport = Orchestrator.Reports.Utilities.GetActiveReport(reportType, reportParametersSessionKey, out enforceDataExistence);
}
catch (Exception ex)
{
Utilities.LastError = ex;
return(null);
}
if (activeReport != null)
{
try
{
ApplicationLog.WriteTrace("Getting Data From Session Variable");
DataView view = null;
var sortExpression = string.Empty;
object ds = null;
if (useReportParametersKey)
{
if (htReportInformation[Orchestrator.Globals.Constants.ReportDataSessionTableVariable] is DataSet)
{
ds = (DataSet)htReportInformation[Orchestrator.Globals.Constants.ReportDataSessionTableVariable];
}
else
{
ds = htReportInformation[Orchestrator.Globals.Constants.ReportDataSessionTableVariable];
}
sortExpression = (string)htReportInformation[Orchestrator.Globals.Constants.ReportDataSessionSortVariable];
}
else
{
if (session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable] is DataSet)
{
ds = (DataSet)session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable];
}
else
{
ds = session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable];
}
sortExpression = (string)session[Orchestrator.Globals.Constants.ReportDataSessionSortVariable];
}
ApplicationLog.WriteTrace("sortExpression ::" + sortExpression);
try
{
if (sortExpression.Length > 0)
{
if (ds is DataSet)
{
view = new DataView(((DataSet)ds).Tables[0]);
}
view.Sort = sortExpression;
activeReport.DataSource = view;
}
else
{
activeReport.DataSource = ds;
}
if (enforceDataExistence && ds != null && ds is DataSet && ((DataSet)ds).Tables.Count > 0 && ((DataSet)ds).Tables[0].Rows.Count == 0)
{
noData = true;
return(null);
}
if (useReportParametersKey)
{
activeReport.DataMember = (string)htReportInformation[Orchestrator.Globals.Constants.ReportDataMemberSessionVariable];
}
else
{
activeReport.DataMember = (string)session[Orchestrator.Globals.Constants.ReportDataMemberSessionVariable];
}
}
catch (Exception eX)
{
Utilities.LastError = eX;
trace.Write("Err1:" + eX.Message);
ApplicationLog.WriteTrace("GetReport :: Err1:" + eX.Message);
}
activeReport.SetReportCulture();
activeReport.Run(false);
}
catch (Exception e)
{
Utilities.LastError = e;
return(null);
}
}
trace.Write("Returning Report");
ApplicationLog.WriteTrace("GetReport :: Returning Report");
return(activeReport);
}
