public AffidavitDetailsDTO GetAffidavitDetailsByCustId(int CustId) { AffidavitDetailsDTO affidavitDetails = new AffidavitDetailsDTO(); AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<affidavitdetail>>() .GetSingle(item => item.Affidavit_CustID == CustId), affidavitDetails); return affidavitDetails; }
public int SaveAffidavitDetails(AffidavitDetailsDTO affidavitdetail) { affidavitdetail affidavitdetailEntity = new affidavitdetail(); using (TransactionScope transactionScope = new TransactionScope()) { AutoMapper.Mapper.Map(affidavitdetail, affidavitdetailEntity); if (affidavitdetail.AffidavitDetailsId == 0) { ESalesUnityContainer.Container.Resolve<IGenericRepository<affidavitdetail>>().Save(affidavitdetailEntity); } transactionScope.Complete(); } return affidavitdetailEntity.AffidavitDetailsId; }
public int UpdateAffidavitDetails(AffidavitDetailsDTO AffidavitDetails) { affidavitdetail affidavitDetailsEntity = new affidavitdetail(); int affidavitDetailsId; using (TransactionScope transactionScope = new TransactionScope()) { AutoMapper.Mapper.Map(AffidavitDetails, affidavitDetailsEntity); ESalesUnityContainer.Container.Resolve<IGenericRepository<affidavitdetail>>().Update(affidavitDetailsEntity); affidavitDetailsId = AffidavitDetails.AffidavitDetailsId; transactionScope.Complete(); } return affidavitDetailsId; }
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 }); }
private void GetAndSetAffidavitDetails() { AffidavitDetailsDTO affidavitDetail = ESalesUnityContainer.Container.Resolve<IAffidavitDetails>() .GetAffidavitDetailsByCustId(Convert.ToInt32(ViewState[Globals.StateMgmtVariables.CUSTOMERID])); if (affidavitDetail.AffidavitExpiryDate > DateTime.Now) { ucMessageBox.ShowMessage("Affidavit Already submitted"); } else { if (affidavitDetail.Affidavit_CustID > 0) { affidavitDetail.AffidavitSubmitDate = DateTime.Now; affidavitDetail.AffidavitExpiryDate = DateTime.Now.AddYears(1); int result = ESalesUnityContainer.Container.Resolve<IAffidavitDetails>().UpdateAffidavitDetails(affidavitDetail); if (result > 0) { ucMessageBox.ShowMessage("Affidavit Saved Successfully"); } } else { AffidavitDetailsDTO affidavitDetails = new AffidavitDetailsDTO(); affidavitDetails.Affidavit_CustID = Convert.ToInt32(ViewState[Globals.StateMgmtVariables.CUSTOMERID]); affidavitDetails.AffidavitCreatedBy = GetCurrentUserId(); affidavitDetails.AffidavitCreatedDate = DateTime.Now; affidavitDetails.AffidavitSubmitDate = DateTime.Now; affidavitDetails.AffidavitExpiryDate = DateTime.Now.AddYears(1); affidavitDetails.AffidavitIsSubmitted = 1; int result = ESalesUnityContainer.Container.Resolve<IAffidavitDetails>().SaveAffidavitDetails(affidavitDetails); if (result > 0) { ucMessageBox.ShowMessage("Affidavit Saved Successfully"); FillGridWithCustomerDetails(txtCustomerCode.Text.Trim(), txtPANNo.Text.Trim()); } } } }