public static List <PreArrival> GetArrivalList()
{
System.Data.DataTable dt = new System.Data.DataTable();
ECX.DataAccess.SQLHelper.PopulateTable("", dt, "");
List <PreArrival> lst = new List <PreArrival>();
foreach (System.Data.DataRow dr in dt.Rows)
{
PreArrival a = new PreArrival();
ECX.DataAccess.Common.DataRow2Object(dr, a);
lst.Add(a);
}
return(lst);
}
protected void btnSave_Click(object sender, EventArgs e)
{
Guid ClientId;
try
{
ClientId = new Guid(this.ClientSelector1.ClientGUID.Value.ToString());
if (ClientId == Guid.Empty || ClientId == null)
{
Messages.SetMessage("Please enter Client ID.", WarehouseApplication.Messages.MessageType.Warning);
return;
}
}
catch
{
Messages.SetMessage("Please enter Client ID.", WarehouseApplication.Messages.MessageType.Warning);
return;
}
try
{
ValidateInputs();
BLL.PreArrival objPreArrival = new BLL.PreArrival();
objPreArrival.ClientId = ClientId;
objPreArrival.ClientName = this.ClientSelector1.lblMessage.Text.Replace(']', ' ').Replace('[', ' ').Trim();
objPreArrival.HasVoucher = chkHasVoucher.Checked;
objPreArrival.VoucherNumber = txtVoucherNo.Text.Trim();
objPreArrival.TruckPlateNumber = txtTruckPlateNo.Text.Trim();
objPreArrival.TrailerPlateNumber = txtTrailerPlateNo.Text.Trim();
objPreArrival.CodeType = "GRN";
objPreArrival.WorkflowTypeID = 1;
objPreArrival.WarehouseID = new Guid(HttpContext.Current.Session["CurrentWarehouse"].ToString());
objPreArrival.UserID = UserBLL.GetCurrentUser();
objPreArrival.CompleteCodeToReturn = "";
objPreArrival.IsTruckInCompound = chkIsTruckInCompound.Checked;
objPreArrival.Save();
//lblMessage.ForeColor = System.Drawing.Color.Green;
//lblMessage.Text = "Pre-Arrival registered successfully!";
Messages.SetMessage("Pre-arrival record saved successfully.", WarehouseApplication.Messages.MessageType.Success);
Clear();
btnNext.Enabled = true;
btnNext.BackColor = System.Drawing.ColorTranslator.FromHtml("#88AB2D");
Nullable <Guid> Id;
Id = objPreArrival.ArrivalId;
if (Id != null)
{
Session["CommodityRequestId"] = Id;
Session["ReportType"] = "PreArrival";
ScriptManager.RegisterStartupScript(this,
this.GetType(),
"ShowReport",
"<script type=\"text/javascript\">" +
string.Format("javascript:window.open(\"ReportViewer.aspx?id={0}\", \"_blank\",\"height=400px,width=600px,top=0,left=0,resizable=yes,scrollbars=yes\");", Guid.NewGuid()) +
"</script>",
false);
}
}
catch (Exception ex)
{
//lblMessage.ForeColor = System.Drawing.Color.Tomato;
//lblMessage.Text = "Failed to proceed, " + ex.Message.ToString();
Messages.SetMessage("Unexpected error. Please try again.", WarehouseApplication.Messages.MessageType.Error);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// DataTable dt = new DataTable();
ActiveReport rpt = null;
if (Session["ReportType"].ToString() == "PreArrival")
{
BLL.PreArrival objPreArrival = new BLL.PreArrival();
DataTable dt = objPreArrival.PopulatePreArrival(new Guid(Session["CommodityRequestId"].ToString()));
rpt = new rptTrackingReport();
rpt.DataSource = dt;
WebViewer1.Report = rpt;
Session["CommodityRequestId"] = null;
WebViewer1.Width = 600;
WebViewer1.Height = 400;
}
if (Session["ReportType"].ToString() == "GRN")
{
rpt = new rptGRNnew();
GRN_BL objGrnBl = new GRN_BL();
DataTable dt = objGrnBl.GetGRNReport(new Guid(Session["GRNId_GRN"].ToString()));
rpt.DataSource = dt;
WebViewer1.Report = rpt;
}
if (Session["ReportType"].ToString() != "DoNuthing")
{
if (Session["ReportType"].ToString() == "PUN")
{
rpt = new rptPUNReport();
rpt.DataSource = GINBussiness.PickupNoticeModel.PrintPUN(Session["PUNID"].ToString());
}
else if (Session["ReportType"].ToString() == "GIN")
{
rpt = new rptGINReport();
Session["GINID"] = ((GINModel)Session["GINMODEL"]).ID;
rpt.DataSource = GINBussiness.PickupNoticeModel.PrintGIN(Convert.ToBoolean(Session["EditModePrint"]), new Guid(Session["GINID"].ToString()));
}
else if (Session["ReportType"].ToString() == "PSA")
{
//----------Updated START ------ NOV 27 2013
// if it is redirected from search page
string statusx = "Unapproved PSA";
if (Request.QueryString["GINID"] == null)
{
rpt = new rptPSAReport(statusx);
Session["GINPSAID"] = ((GINModel)Session["GINMODEL"]).ID;
rpt.DataSource = GINBussiness.PickupNoticeModel.PrintPSA(new Guid(Session["GINPSAID"].ToString()));
}
else
{
statusx = (Convert.ToInt16(Request.QueryString["ST"]) % 11 == 0) ? "Approved" : "Unapproved PSA";
rpt = new rptPSAReport(statusx);
if (statusx.Equals("Approved"))
{
rpt.DataSource = GINBussiness.PickupNoticeModel.PrintPSA_Approved(new Guid(Request.QueryString["GINID"]));
}
else
{
rpt.DataSource = GINBussiness.PickupNoticeModel.PrintPSA(new Guid(Request.QueryString["GINID"]));
}
}
//----------Updated End ------ NOV 27 2013
}
else if (Session["ReportType"].ToString() == "ExpierdList")
{
rpt = new rptPickupNoticeExpiredList();
DataTable dt = new DataTable();
dt = PickupNoticeModel.SearchExpieredList(UserBLL.GetCurrentWarehouse(), Convert.ToDateTime(Session["ExpirationDateFrom"]), Convert.ToDateTime(Session["ExpirationDateTo"]));
if (dt.Rows.Count > 0)
{
rpt.DataSource = dt;
}
else
{
return;
}
}
else if (Session["ReportType"].ToString() == "ExpierdListAdmin")
{
rpt = new rptPickupNoticeExpiredList();
DataTable dt = new DataTable();
dt = PickupNoticeModel.SearchExpieredListAdmin(Convert.ToDateTime(Session["ExpirationDateFrom"]), Convert.ToDateTime(Session["ExpirationDateTo"]));
if (dt.Rows.Count > 0)
{
rpt.DataSource = dt;
}
else
{
return;
}
}
else if (Session["ReportType"].ToString() == "GINApproval")
{
rpt = new rptGINApproval();
rpt.DataSource = GINBussiness.GINModel.PrintGINApprovalReport(UserBLL.GetCurrentWarehouse(), new Guid(Session["SelectedLIC"].ToString()));
WebViewer1.Report = rpt;
rpt.PageSettings.Margins.Top = 0;
}
else if (Session["ReportType"].ToString() == "SampleTicket")
{
//rpt = new rptSampleTicketCoffeeNew();
//rpt.DataSource = SamplingBussiness.SamplingModel.GetSampleTicketReport(new Guid(Session["SampleId"].ToString()));
rpt = new rptSampleTicketCoffeeNew();
rpt.DataSource = SamplingBussiness.SamplingModel.GetSampleTicketReport(new Guid(Session["SampleId"].ToString()));
}
else if (Session["ReportType"].ToString() == "GradingResult")
{
rpt = new rptResultReport();
rpt.DataSource = GradingModel.GradingResultreport(Session["GradingCode"].ToString());
}
else if (Session["ReportType"].ToString() == "GradingResultNoDeposit")
{
rpt = new rptInspectionTestResult();
rpt.DataSource = GradingModel.GetInspectionTestResult(Session["GradingCode"].ToString(), UserBLL.GetCurrentWarehouse());
}
else if (Session["ReportType"].ToString() == "GradingCode")
{
rpt = new rptGenerate();
DataTable dt = new DataTable();
dt = GradingModel.printCode(new Guid(Session["GenerateCode"].ToString()), new Guid(Session["VoucherCommodityTypeID"].ToString()), new Guid(Session["CommodityID"].ToString()));
rpt.DataSource = dt;
}
else if (Session["ReportType"].ToString() == "GradingResultForSegrigation")
{
rpt = new Report.rptSegrigationGradingReport();
rpt.DataSource = GradingModel.GradingResultreportForSegrigation(Session["GradingCode"].ToString());
}
if (Session["ReportType"].ToString() != "GINApproval")
{
rpt.PageSettings.Margins.Top = 0;
rpt.PageSettings.Margins.Left = 0.4f;
rpt.PageSettings.Margins.Right = 0.4f;
WebViewer1.Report = rpt;
//rpt.Run(false);
//Response.ContentType = "application/pdf";
//Response.AddHeader("content-disposition", "inline; filename=MyPDF.PDF");
//// Create the PDF export object
//PdfExport pdf = new PdfExport();
//// Create a new memory stream that will hold the pdf output
//System.IO.MemoryStream memStream = new System.IO.MemoryStream();
//// Export the report to PDF:
//pdf.Export(rpt.Document, memStream);
//// Write the PDF stream out
//Response.BinaryWrite(memStream.ToArray());
//// Send all buffered content to the client
//Response.End();
}
}
}