private void rptGRN_ReportStart(object sender, EventArgs e)
{
if (HttpContext.Current.Session["GRNIDPrint"] == null)
{
throw new Exception("Session expired");
}
Guid GRNId = Guid.Empty;
GRNId = new Guid(HttpContext.Current.Session["GRNIDPrint"].ToString());
Guid GradingId = Guid.Empty;
GRNBLL objGRN = new GRNBLL();
objGRN = objGRN.GetbyGRN_Number(GRNId);
GradingId = objGRN.GradingId;
this.lblGRN_No.Text = objGRN.GRN_Number;
this.lblClient.Text = ClientBLL.GetClinetNameById(objGRN.ClientId);
this.lblCommodityGrade.Text = CommodityGradeBLL.GetCommodityGradeNameById(objGRN.CommodityGradeId);
this.lblWarehouse.Text = WarehouseBLL.GetWarehouseNameById(objGRN.WarehouseId);
this.lblOriginalQuantity.Text = objGRN.OriginalQuantity.ToString();
this.lblNetWeight.Text = objGRN.NetWeight.ToString();
this.lblDateDeposited.Text = objGRN.DateDeposited.ToShortDateString();
this.lblTimeDeposited.Text = objGRN.DateDeposited.ToShortTimeString();
this.lblNoBags.Text = objGRN.TotalNumberOfBags.ToString();
//Bag Type
BagTypeBLL objBt = new BagTypeBLL();
objBt.GetBagTypeById(objGRN.BagTypeId);
lblBagType.Text = objBt.BagTypeName;
//Driver Information
List <DriverInformationBLL> list = null;
DriverInformationBLL objDI = new DriverInformationBLL();
list = objDI.GetActiveDriverInformationByReceivigRequestId(objGRN.CommodityRecivingId);
if (list != null)
{
string driverName = "";
string plateNo = "";
string driverLicense = "";
string licensceIssuedPlace = "";
foreach (DriverInformationBLL o in list)
{
if (driverName == "")
{
driverName = o.DriverName;
}
else
{
driverName += "," + o.DriverName;
}
if (plateNo == "")
{
if (String.IsNullOrEmpty(o.TrailerPlateNumber) != true)
{
plateNo = o.PlateNumber + "-" + o.TrailerPlateNumber;
}
else
{
plateNo = o.PlateNumber;
}
}
else
{
if (String.IsNullOrEmpty(o.TrailerPlateNumber) != true)
{
plateNo += " , " + o.PlateNumber + "-" + o.TrailerPlateNumber;
}
else
{
plateNo += " , " + o.PlateNumber;
}
}
if (driverLicense == "")
{
driverLicense = o.LicenseNumber;
}
else
{
driverLicense += " , " + o.LicenseNumber;
}
if (licensceIssuedPlace == "")
{
licensceIssuedPlace = o.LicenseIssuedPlace;
}
else
{
licensceIssuedPlace += " , " + o.LicenseIssuedPlace;
}
}
this.lblDriverName.Text = driverName;
this.lblPlateNo.Text = plateNo;
this.lblDriverLicense.Text = driverLicense;
this.lblPlaceIssued.Text = licensceIssuedPlace;
}
// Scaling
ScalingBLL objScaling = new ScalingBLL();
objScaling = objScaling.GetById(objGRN.ScalingId);
if (objScaling != null)
{
if (objScaling.WeigherId != null)
{
try
{
this.lblWeigherName.Text = UserRightBLL.GetUserNameByUserId(objScaling.WeigherId);
}
catch
{
}
}
}
// Sampler
SamplerBLL objSampler = new SamplerBLL();
objSampler = objSampler.GetActiveSamplingSupBySamplingId(objGRN.SamplingTicketId);
if (objSampler != null)
{
this.lblSampler.Text = UserRightBLL.GetUserNameByUserId(objSampler.SamplerId);
}
//Graders
GradingByBLL objGrader = new GradingByBLL();
this.lblGrader.Text = objGrader.GetSupGraderNameByGradingId(objGRN.GradingId);
if (objGRN.ApprovedBy != null)
{
try
{
this.lblApprovedBy.Text = UserRightBLL.GetUserNameByUserId(objGRN.ApprovedBy);
}
catch
{
}
}
if (objGRN.ApprovedTimeStamp != null)
{
this.lblDateAproved.Text = objGRN.ApprovedTimeStamp.ToShortDateString();
}
rpt = new rptGrading(GradingId);
rptGS = new rptGRNService(GRNId);
this.txtDateGenerated.Text = DateTime.Now.ToString();
ScalingBLL objSacling = new ScalingBLL();
objSacling = objSacling.GetById(objGRN.ScalingId);
if (objSacling != null)
{
this.lblScaleTicketNo.Text = objSacling.ScaleTicketNumber;
}
this.subReport1.Report = rpt;
this.subReport2.Report = this.rptGS;
}
private void getData(DateTime from)
{
SLABLL o = new SLABLL();
List <SLABLL> list = null;
Guid Id = UserBLL.GetCurrentWarehouse();
list = o.GetSLA(Id, from, 0);
if (list != null)
{
var q = (from l in list
orderby l.objArrival.DateTimeRecived ascending
select new
{
VoucherNo = l.objVoucher.VoucherNo,
Client = ClientBLL.GetClinetNameById(l.objGRN.ClientId),
PlateNumber = l.objDriver.PlateNumber,
TrailerPlateNumber = l.objDriver.TrailerPlateNumber,
TotalNumberOfBags = l.objUnloading.TotalNumberOfBags,
ArrivalDate = l.objArrival.DateTimeRecived.ToShortDateString(),
//ArrivalDateSystem = l.objArrival.CreatedTimestamp ,
SampledDate = l.objSampling.GeneratedTimeStamp.ToShortDateString(),
ArrivalToSample = (l.objSampling.GeneratedTimeStamp.Date.Subtract(l.objArrival.DateTimeRecived.Date)).Days,
//Sampling Result
//SamplingResultDate = (l.objSamplingResult.CreatedTimestamp).ToShortDateString(),
SamplingResultDate = l.objSamplingResult.ResultReceivedDateTime.ToShortDateString(),
SamplingToResult = (l.objSamplingResult.ResultReceivedDateTime.Date.Subtract(l.objSampling.GeneratedTimeStamp.Date)).Days,
//Coding
CodingDate = l.objGrading.DateCoded.ToShortDateString(),
SamplingResultToCode = (l.objGrading.DateCoded.Date.Subtract(l.objSamplingResult.ResultReceivedDateTime.Date)).Days,
//Grading Result
GradeRecivedDate = l.objGradingResult.CreatedTimestamp.ToShortDateString(),
GradeToResult = (l.objGradingResult.GradeRecivedTimeStamp.Date.Subtract(l.objGrading.DateCoded.Date)).Days,
// GR to Client Acceptance
GradeClientResponse = ((DateTime)l.objGradingResult.ClientAcceptanceTimeStamp).ToShortDateString(),
GraderesultStatus = l.objGradingResult.Status,
GradingResultToCleintAcceptance = (((DateTime)l.objGradingResult.ClientAcceptanceTimeStamp).Date.Subtract(l.objGradingResult.GradeRecivedTimeStamp.Date)).Days,
GradingRecivedResultStatus = l.objGradingResult.Status,
GradeResultToClientresponse = (((DateTime)l.objGradingResult.ClientAcceptanceTimeStamp).Date.Subtract(l.objGradingResult.GradeRecivedTimeStamp.Date)).Days,
//Unloading
DateDeposited = l.objUnloading.DateDeposited.ToShortDateString(),
GradeClientResponsetoUnloading = l.objUnloading.DateDeposited.Date.Subtract(((DateTime)l.objGradingResult.ClientAcceptanceTimeStamp).Date).Days,
NoBags = l.objUnloading.TotalNumberOfBags,
//Scaling
DateWeighed = l.objScaling.DateWeighed.ToShortDateString(),
GradeClientResponsetoScaling = l.objScaling.DateWeighed.Date.Subtract(((DateTime)l.objGradingResult.ClientAcceptanceTimeStamp).Date).Days,
//GRN creation
GRN_Number = l.objGRN.GRN_Number,
GRNCreatedDate = l.objGRN.CreatedTimestamp.ToShortDateString(),
ScalingToGRN = l.objGRN.CreatedTimestamp.Date.Subtract(l.objScaling.DateWeighed.Date).Days,
//GRN Acceptance
GRNCleintResponse = l.objGRN.ClientAcceptedTimeStamp.ToShortDateString(),
GRNToCleintResponse = l.objGRN.ClientAcceptedTimeStamp.Date.Subtract(l.objGRN.CreatedTimestamp.Date).Days,
//Manager Approval
ManagerAppp = l.objGRN.ApprovedTimeStamp.ToShortDateString(),
GRNClientResponseToApproval = l.objGRN.ApprovedTimeStamp.Date.Subtract(l.objGRN.ClientAcceptedTimeStamp.Date).Days,
//From Arrival to GRN
FromArrivalToDeposit = l.objUnloading.DateDeposited.Date.Subtract(l.objArrival.DateTimeRecived.Date).Days,
ArrivalToGRNCreation = l.objGRN.CreatedTimestamp.Date.Subtract(l.objArrival.DateTimeRecived.Date).Days,
ArrivalToClientAccptance = l.objGRN.ClientAcceptedTimeStamp.Date.Subtract(l.objArrival.DateTimeRecived.Date).Days,
ArrivalToGRNApproval = l.objGRN.ApprovedTimeStamp.Date.Subtract(l.objArrival.DateTimeRecived.Date).Days
});
if (q != null)
{
if (q.Count() > 0)
{
str.Append("<table align='center' border='1' bordercolor='#000000' width='99%' class='reporttable1' cellspacing='0' cellpadding='0' style='font-size:10;'>");
str.Append("<tr style='color:#000000; font-weight:bold>' ");
//1
str.Append("<td>S.No");
str.Append("</td>");
//2
str.Append("<td>voucher.No");
str.Append("</td>");
//3
str.Append("<td>Company Name");
str.Append("</td>");
//4
str.Append("<td>Plate No.");
str.Append("</td>");
//5
str.Append("<td>Trailer Plate No.");
str.Append("</td>");
//6
str.Append("<td>No. Bags");
str.Append("</td>");
//7
str.Append("<td>Date of Arrival");
str.Append("</td>");
//8
str.Append("<td>Sampling Date");
str.Append("</td>");
//9
str.Append("<td>Arrival to Sampling ");
str.Append("</td>");
//10
str.Append("<td>Sampling Result Date ");
str.Append("</td>");
//11
str.Append("<td>Sampling To Sampling Result ");
str.Append("</td>");
//12
str.Append("<td>Date Coded ");
str.Append("</td>");
//13
str.Append("<td>Sampling Result To Code ");
str.Append("</td>");
//14
str.Append("<td>Grade Recieved Date ");
str.Append("</td>");
//15
str.Append("<td>Grading To Result");
str.Append("</td>");
//16
str.Append("<td>Grading Status");
str.Append("</td>");
//17
str.Append("<td>Grading Result Cleint Respons date");
str.Append("</td>");
//18
str.Append("<td>Grading Result To Cleint Respons");
str.Append("</td>");
//19
str.Append("<td>Date Deposited");
str.Append("</td>");
//20
str.Append("<td>Client Response to Unloading");
str.Append("</td>");
//21
str.Append("<td>DateWeighed");
str.Append("</td>");
//22
str.Append("<td>Client Response to Scaling");
str.Append("</td>");
//23
str.Append("<td>GRN Number ");
str.Append("</td>");
//24
str.Append("<td>GRN Created Date ");
str.Append("</td>");
//25
str.Append("<td>Scaling to GRN ");
str.Append("</td>");
//26
str.Append("<td>GRN Client Response ");
str.Append("</td>");
//27
str.Append("<td>GRN To Cleint Response ");
str.Append("</td>");
//28
str.Append("<td>GRN Approval date ");
str.Append("</td>");
//29
str.Append("<td>Cleint Response to Manger Approval ");
str.Append("</td>");
//29.1
str.Append("<td>Arrival to Deposit");
str.Append("</td>");
//30
str.Append("<td>Arrival To GRN ");
str.Append("</td>");
//31
str.Append("<td>Arrival To GRN Acceptance ");
str.Append("</td>");
//32
str.Append("<td>Arrival To GRN Approval ");
str.Append("</td>");
str.Append("</tr>");
int sno = 0;
foreach (var i in q)
{
sno++;
str.Append("<tr>");
//1
str.Append("<td>");
str.Append(sno.ToString());
str.Append("</td>");
//2
str.Append("<td>");
str.Append(i.VoucherNo.ToString());
str.Append("</td>");
//3
str.Append("<td>");
str.Append(i.Client.ToString());
str.Append("</td>");
//4
str.Append("<td>");
str.Append(i.PlateNumber.ToString());
str.Append("</td>");
//5
str.Append("<td>");
str.Append(i.TrailerPlateNumber.ToString());
str.Append("</td>");
//6
str.Append("<td>");
str.Append(i.TotalNumberOfBags.ToString());
str.Append("</td>");
//7
str.Append("<td>");
str.Append(i.ArrivalDate);
str.Append("</td>");
//8
str.Append("<td>");
str.Append(i.SampledDate);
str.Append("</td>");
//9
str.Append("<td>");
str.Append(i.ArrivalToSample);
str.Append("</td>");
//10
str.Append("<td>");
str.Append(i.SamplingResultDate);
str.Append("</td>");
//11
str.Append("<td>");
str.Append(i.SamplingToResult);
str.Append("</td>");
//12
str.Append("<td>");
str.Append(i.CodingDate);
str.Append("</td>");
//13
str.Append("<td>");
str.Append(i.SamplingResultToCode);
str.Append("</td>");
//14
str.Append("<td>");
str.Append(i.GradeRecivedDate);
str.Append("</td>");
//15
str.Append("<td>");
str.Append(i.GradeToResult);
str.Append("</td>");
//16
str.Append("<td>");
str.Append(i.GraderesultStatus);
str.Append("</td>");
//17
str.Append("<td>");
str.Append(i.GradeClientResponse);
str.Append("</td>");
//18
str.Append("<td>");
str.Append(i.GradingResultToCleintAcceptance);
str.Append("</td>");
//19
str.Append("<td>");
str.Append(i.DateDeposited);
str.Append("</td>");
//20
str.Append("<td>");
str.Append(i.GradeClientResponsetoUnloading);
str.Append("</td>");
//21
str.Append("<td>");
str.Append(i.DateWeighed);
str.Append("</td>");
//22
str.Append("<td>");
str.Append(i.GradeClientResponsetoScaling);
str.Append("</td>");
if (i.GRN_Number != "" && i.GRN_Number != null && DateTime.Parse(i.GRNCreatedDate) != DateTime.Parse("1/1/0001"))
{
//23
str.Append("<td>");
str.Append(i.GRN_Number);
str.Append("</td>");
//24
str.Append("<td>");
str.Append(i.GRNCreatedDate);
str.Append("</td>");
//25
str.Append("<td>");
str.Append(i.ScalingToGRN);
str.Append("</td>");
if (DateTime.Parse(i.GRNCleintResponse) != DateTime.Parse("1/1/0001"))
{
//26
str.Append("<td>");
str.Append(i.GRNCleintResponse);
str.Append("</td>");
//27
str.Append("<td>");
str.Append(i.GRNToCleintResponse);
str.Append("</td>");
}
else
{
str.Append("<td>");
str.Append(" ");
str.Append("</td>");
str.Append("<td>");
str.Append(" ");
str.Append("</td>");
}
if (DateTime.Parse("1/1/0001") != DateTime.Parse(i.ManagerAppp))
{
//28
str.Append("<td>");
str.Append(i.ManagerAppp);
str.Append("</td>");
//29
str.Append("<td>");
str.Append(i.GRNClientResponseToApproval);
str.Append("</td>");
}
else
{
str.Append("<td>");
str.Append(" ");
str.Append("</td>");
str.Append("<td>");
str.Append(" ");
str.Append("</td>");
}
//29.1
str.Append("<td>");
str.Append(i.FromArrivalToDeposit);
str.Append("</td>");
//30
if (DateTime.Parse(i.GRNCreatedDate) != DateTime.Parse("1/1/0001"))
{
str.Append("<td>");
str.Append(i.ArrivalToGRNCreation);
str.Append("</td>");
}
else
{
str.Append("<td>");
str.Append(" ");
str.Append("</td>");
}
if (DateTime.Parse(i.GRNCleintResponse) != DateTime.Parse("1/1/0001"))
{
//31
str.Append("<td>");
str.Append(i.ArrivalToClientAccptance);
str.Append("</td>");
}
else
{
str.Append("<td>");
str.Append(" ");
str.Append("</td>");
}
if (DateTime.Parse("1/1/0001") != DateTime.Parse(i.ManagerAppp))
{
//32
str.Append("<td>");
str.Append(i.ArrivalToGRNApproval);
str.Append("</td>");
}
else
{
str.Append("<td>");
str.Append(" ");
str.Append("</td>");
}
}
str.Append("</tr>");
}
str.Append("</table>".ToString());
}
}
}
}