private static SMSRegistrationDTO InitializeSMSRegDetails(int custId, string message, string truckNumber)
{
SMSRegistrationDTO smsRegDetails = new SMSRegistrationDTO();
smsRegDetails.SMSReg_CustId = custId;
smsRegDetails.SMSReg_Msg = message;
smsRegDetails.SMSReg_TruckNo = truckNumber;
smsRegDetails.SMSReg_BookingStatus = false;
smsRegDetails.SMSReg_CreatedDate = DateTime.Now;
smsRegDetails.SMSReg_LastUpdatedDate = DateTime.Now;
smsRegDetails.SMSReg_Date = DateTime.Now.Date;
return smsRegDetails;
}
/// <summary>
/// Save And Update SMS Details
/// </summary>
/// <param name="smsDetails"></param>
/// <returns></returns>
public int SaveAndUpdateSMSDetails(SMSRegistrationDTO smsDetails)
{
int smsReg_Id = 0;
smsregistration smsRegistrationEntity = new smsregistration();
AutoMapper.Mapper.Map(smsDetails, smsRegistrationEntity);
if (smsDetails.SMSReg_Id == 0)
{
ESalesUnityContainer.Container.Resolve<IGenericRepository<smsregistration>>().Save(smsRegistrationEntity);
}
else
{
ESalesUnityContainer.Container.Resolve<IGenericRepository<smsregistration>>().Update(smsRegistrationEntity);
}
smsReg_Id = smsRegistrationEntity.SMSReg_Id;
//return the details
return smsReg_Id;
}
public void LoadReport(string Truckno)
{
SMSRegistrationDTO _smsRegistrationObj = new SMSRegistrationDTO();
_smsRegistrationObj = ESalesUnityContainer.Container.Resolve<ISMSService>().GetPreviousdDateSMSDetailsByTruckNo(Truckno);
SettlementOfAccountsDTO lastSettlementdetails = ESalesUnityContainer.Container.Resolve<ISettlementOfAccountsService>().GetLastSettlementOfAccountsByTruckNo(Truckno);
if (lastSettlementdetails.Account_Id > 0)
{
_smsRegistrationObj.SMSReg_Last_Settlement_CreatedDate = lastSettlementdetails.Account_CreatedDate.ToString();
_smsRegistrationObj.SMSReg_Last_Settlement_Dist = lastSettlementdetails.Account_Booking_Cust_District_Name;
}
AffidavitDetailsDTO _affidavitDetails = new AffidavitDetailsDTO();
_affidavitDetails = ESalesUnityContainer.Container.Resolve<IAffidavitDetails>().GetAffidavitDetailsByCustId(_smsRegistrationObj.SMSReg_CustId);
List<SMSRegistrationDTO> lstLoadingSMSBookingRpt = new List<SMSRegistrationDTO>();
lstLoadingSMSBookingRpt.Add(_smsRegistrationObj);
//Reset report viewer control
reportViewer.Reset();
//Initializes report viewer and set report as embedded resource
Common.SetReportEmbeddedResource(reportViewer, "TCESS.ESales.CommonLayer.Reports.Printingreport.rdlc");
ReportDataSource loadingSMSBookingDataSource = new ReportDataSource("dsSMSBookingReport", lstLoadingSMSBookingRpt);
reportViewer.LocalReport.DataSources.Add(loadingSMSBookingDataSource);
string affidavitStatus = string.Empty;
if (_affidavitDetails.Affidavit_CustID > 0)
{
affidavitStatus = "Yes";
}
else
{
affidavitStatus = "No";
}
ReportParameter Affidavit = new ReportParameter("Affidavit", affidavitStatus);
reportViewer.LocalReport.SetParameters(new ReportParameter[] { Affidavit });
}
/// <summary>
/// Get Booking Detail By SmsId
/// </summary>
/// <param name="smsId">Int32:smsId</param>
/// <returns></returns>
public BookingDTO GetBookingDetailBySmsId(int smsId)
{
SMSRegistrationDTO smsDetails = new SMSRegistrationDTO();
BookingDTO bookingDetails = new BookingDTO();
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<smsregistration>>()
.GetSingle(item => item.SMSReg_Id == smsId && item.SMSReg_BookingStatus == true && item.SMSReg_IsDeleted == false), smsDetails);
if (smsDetails.SMSReg_Id > 0)
{
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<booking>>()
.GetSingle(item => item.Booking_Id == smsDetails.SMSReg_Booking_Id && item.Booking_MoneyReceiptIssued == true
&& item.Booking_AccountSettled == false && item.Booking_IsDeleted == false), bookingDetails);
}
return bookingDetails;
}
/// <summary>
/// Set Report Parameters by bookingDetails and reportViewer
/// </summary>
/// <param name="bookingDetails"></param>
/// <param name="reportViewer"></param>
private void SetReportParameters(BookingDTO bookingDetails, ReportViewer reportViewer)
{
string truckRegNo = string.Empty;
string truckOwnerName = string.Empty;
string truckDriverName = string.Empty;
string truckOwnerShortAdd = string.Empty;
string truckDriverShortAdd = string.Empty;
BarcodeDTO b = new BarcodeDTO();
SMSRegistrationDTO smsDetail = new SMSRegistrationDTO();
smsDetail = ESalesUnityContainer.Container.Resolve<ISMSService>().GetSmsDetailsByBookingId(bookingDetails.Booking_Id);
ReportParameter loadingAdviceFor = new ReportParameter("LoadingAdviceFor", bookingDetails.Booking_MaterialType_MaterialName);
ReportParameter loadingAdviceNo = new ReportParameter("LoadingAdviceNo", bookingDetails.Booking_Agent_AgentShortName
+ "-" + bookingDetails.Booking_Id);
ReportParameter sNO = new ReportParameter("SNo", Convert.ToString(bookingDetails.Booking_Id));
ReportParameter bookingDate = new ReportParameter("BookingDate", Convert.ToDateTime(bookingDetails.Booking_Date).ToString("dd/MMM/yyyy"));
ReportParameter matTypeName = new ReportParameter("MatTypeName", bookingDetails.Booking_MaterialType_MaterialName);
ReportParameter matCode = new ReportParameter("MatCode", bookingDetails.Booking_MaterialType_Code);
ReportParameter custCode = new ReportParameter("CustCode", bookingDetails.Booking_Cust_Code);
ReportParameter smsId1 = new ReportParameter("SMSId1", Convert.ToString(smsDetail.SMSReg_Id));
ReportParameter smsId2 = new ReportParameter("SMSId2", Convert.ToString(smsDetail.SMSReg_Id));
if (bookingDetails.Booking_TruckType == true)
{
truckRegNo = bookingDetails.Booking_StandaloneTruck_RegNo;
truckOwnerName = bookingDetails.Booking_StandaloneTruck_OwnerName + ',' + bookingDetails.Booking_StandaloneTruck_OwnerShortAdd;
truckDriverName = bookingDetails.Booking_StandaloneTruck_DriverName + ',' + bookingDetails.Booking_StandaloneTruck_DriverShortAdd;
}
else
{
truckRegNo = bookingDetails.Booking_Truck_RegNo;
truckOwnerName = bookingDetails.Booking_Truck_OwnerName + ',' + bookingDetails.Booking_Truck_OwnerShortAdd;
truckDriverName = bookingDetails.Booking_Truck_DriverName + ',' + bookingDetails.Booking_Truck_DriverShortAdd;
}
ReportParameter truckNo = new ReportParameter("TruckNo", truckRegNo);
ReportParameter truckOwner = new ReportParameter("TruckOwner", truckOwnerName);
ReportParameter truckDriver = new ReportParameter("TruckDriver", truckDriverName);
ReportParameter custName = new ReportParameter("CustName", bookingDetails.Booking_Cust_UnitName);
ReportParameter address = new ReportParameter("Address", bookingDetails.Booking_Cust_UnitAddress);
ReportParameter district = new ReportParameter("District", bookingDetails.Booking_Cust_District_Name);
ReportParameter state = new ReportParameter("State", bookingDetails.Booking_Cust_State_Name);
ReportParameter approxQty = new ReportParameter("AppQty", Convert.ToString(bookingDetails.Booking_Qty) + " M");
CurrencyConvertor currencyConvertor = new CurrencyConvertor();
MoneyReceiptDTO moneyReceiptDetails = MasterList.GetMoneyReceiptById(0, bookingDetails.Booking_Id);
ReportParameter advanceAmount = new ReportParameter("AdvanceAmount",
Convert.ToString(moneyReceiptDetails.MoneyReceipt_AmountPaid));
ReportParameter amountInWords = new ReportParameter("AmountInWords",
currencyConvertor.Convertor(moneyReceiptDetails.MoneyReceipt_AmountPaid.ToString()));
ReportParameter moneyReceiptDate = new ReportParameter("MoneyReceiptDate",
Convert.ToDateTime(moneyReceiptDetails.MoneyReceipt_CreateDate).ToString("dd/MMM/yyyy"));
ReportParameter moneyReceiptSNo = new ReportParameter("MoneyReceiptSNo", Convert.ToString(moneyReceiptDetails.MoneyReceipt_Id));
GenerateBarcode(bookingDetails.Booking_Id.ToString(), ref b);
List<BarcodeDTO> barcodes = new List<BarcodeDTO>();
barcodes.Add(b);
reportViewer.LocalReport.DataSources.Clear();
reportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", barcodes));
reportViewer.LocalReport.SetParameters(new ReportParameter[] { loadingAdviceFor, loadingAdviceNo, sNO,
bookingDate, matTypeName, matCode, custCode, truckNo, truckOwner, truckDriver, custName, address, district, state,
approxQty, advanceAmount, amountInWords, moneyReceiptSNo, moneyReceiptDate, smsId1, smsId2});
}
private bool CheckExistence(int bookingId, int smsId)
{
SMSRegistrationDTO smsDetails = new SMSRegistrationDTO();
smsDetails = ESalesUnityContainer.Container.Resolve<ISMSService>().GetDetailsBySmsIdBookingId(bookingId, smsId);
if (smsDetails.SMSReg_Booking_Id > 0)
return true;
else
return false;
}
public SMSRegistrationDTO GetSmsDetailsByBookingId(int bookingId)
{
SMSRegistrationDTO smsDetails = new SMSRegistrationDTO();
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<smsregistration>>()
.GetSingle(item => item.booking.Booking_Id == bookingId), smsDetails);
return smsDetails;
}
/// <summary>
/// Get Yesterday SMS Details By truckNumber
/// </summary>
/// <param name="smsRegId">string:truckNumber</param>
/// <returns></returns>
public SMSRegistrationDTO GetPreviousdDateSMSDetailsByTruckNo(string truckNumber)
{
SMSRegistrationDTO SMSRegistrationDetails = new SMSRegistrationDTO();
DateTime PreviousDate = DateTime.Now.Date.AddDays(-1);
smsregistration SMSRegistrationDetailsEntity = ESalesUnityContainer.Container.Resolve<IGenericRepository<smsregistration>>()
.GetSingle(item => item.SMSReg_IsDeleted == false && item.SMSReg_BookingStatus == true
&& item.SMSReg_Date == PreviousDate && item.SMSReg_TruckNo == truckNumber);
AutoMapper.Mapper.Map(SMSRegistrationDetailsEntity, SMSRegistrationDetails);
return SMSRegistrationDetails;
}
/// <summary>
/// Get Todays SMS Details By smsRegId and Currentdate
/// </summary>
/// <param name="smsRegId">int32:smsRegId</param>
/// <param name="Currentdate">DateTime:Currentdate</param>
/// <returns></returns>
public SMSRegistrationDTO GetTodaysSMSDetailsById(int smsRegId, DateTime Currentdate)
{
SMSRegistrationDTO smsRegistrationDetails = new SMSRegistrationDTO();
smsregistration smsRegistrationDetailsEntity = ESalesUnityContainer.Container
.Resolve<IGenericRepository<smsregistration>>().GetSingle(item => item.SMSReg_IsDeleted == false
&& item.SMSReg_Date == Currentdate && item.SMSReg_Id == smsRegId);
AutoMapper.Mapper.Map(smsRegistrationDetailsEntity, smsRegistrationDetails);
//return the value
return smsRegistrationDetails;
}
protected string GetCustomerCode(string TruckNo)
{
if (!string.IsNullOrEmpty(TruckNo))
{
SMSRegistrationDTO _smsRegistrationObj = new SMSRegistrationDTO();
_smsRegistrationObj = ESalesUnityContainer.Container.Resolve<ISMSService>().GetPreviousdDateSMSDetailsByTruckNo(TruckNo);
return _smsRegistrationObj.SMSReg_Cust_Code == null ? Resources.Messages.NoRecordFound : _smsRegistrationObj.SMSReg_Cust_Code.ToString();
}
else
{
return Resources.Messages.NoRecordFound;
}
}
protected string GetSMSDate(string TruckNo)
{
if (!string.IsNullOrEmpty(TruckNo))
{
SMSRegistrationDTO _smsRegistrationObj = new SMSRegistrationDTO();
_smsRegistrationObj = ESalesUnityContainer.Container.Resolve<ISMSService>().GetPreviousdDateSMSDetailsByTruckNo(TruckNo);
if (_smsRegistrationObj.SMSReg_Id == 0)
grdViewTruck.Columns[9].Visible = false;
else
grdViewTruck.Columns[9].Visible = true;
return _smsRegistrationObj.SMSReg_Id == 0 ? Resources.Messages.NoRecordFound : DateTime.Now.Date.ToString("dd-MMM-yyyy");
}
else
{
grdViewTruck.Columns[9].Visible = false;
return Resources.Messages.NoRecordFound;
}
}
