/// <summary>
/// To Save Settlement Of Accounts
/// </summary>
/// <param name="settlementOfAcct"></param>
/// <returns></returns>
public int SaveSettlementOfAccounts(SettlementOfAccountsDTO settlementOfAcct)
{
settlementofaccount settlementOfAcctEntity = new settlementofaccount();
using (TransactionScope transactionScope = new TransactionScope())
{
AutoMapper.Mapper.Map(settlementOfAcct, settlementOfAcctEntity);
ESalesUnityContainer.Container.Resolve<IGenericRepository<settlementofaccount>>().Save(settlementOfAcctEntity);
BookingService bookingService = new BookingService();
BookingDTO bookingDetail = bookingService.GetBookingDetailByBookingId(settlementOfAcct.Account_Booking_Id, true);
//Set money receipt issued status flag to true and save booking details in database
bookingDetail.Booking_AccountSettled = true;
bookingDetail.Booking_AccountSettledDate = DateTime.Now.Date; // Added by ansharma on 26-Sep-2012
bookingService.SaveAndUpdateBookingDetail(bookingDetail);
transactionScope.Complete();
}
//return value
return settlementOfAcctEntity.Account_Id;
}
/// <summary>
/// Get Settlement Of Accounts By accountId
/// </summary>
/// <param name="accountId">Int32:accountId</param>
/// <returns></returns>
public SettlementOfAccountsDTO GetSettlementOfAccountsById(int accountId)
{
SettlementOfAccountsDTO settlementOfAcct = new SettlementOfAccountsDTO();
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<settlementofaccount>>()
.GetSingle(item => item.Account_Id == accountId && item.Account_IsDeleted == false), settlementOfAcct);
//return value
return settlementOfAcct;
}
private void SetReportParameters(SettlementOfAccountsDTO settlementOfAcct, ReportViewer reportViewer)
{
string truckRegNo = string.Empty;
decimal grossAmount = settlementOfAcct.Account_Quantity * settlementOfAcct.booking.Booking_MaterialType_HandlingRate;
decimal serviceTaxOnAmount = (grossAmount * settlementOfAcct.booking.Booking_MaterialType_ServiceTax) / 100;
decimal educationCessOnAmount = (serviceTaxOnAmount * settlementOfAcct.booking.Booking_MaterialType_EducationCess) / 100;
decimal higherEducationCessOnAmount = (serviceTaxOnAmount * settlementOfAcct.booking.Booking_MaterialType_HigherEducationCess) / 100;
decimal netAmount = grossAmount + serviceTaxOnAmount + educationCessOnAmount + higherEducationCessOnAmount;
ReportParameter SNo = new ReportParameter("SNo", settlementOfAcct.booking.Booking_Agent_AgentShortName + "/" + settlementOfAcct.Account_Id);
ReportParameter Date = new ReportParameter("Date", Convert.ToDateTime(settlementOfAcct.Account_CreatedDate).ToString());
ReportParameter CustName = new ReportParameter("CustName", settlementOfAcct.booking.Booking_Cust_UnitName);
ReportParameter Address = new ReportParameter("Address", settlementOfAcct.booking.Booking_Cust_UnitAddress);
ReportParameter District = new ReportParameter("District", settlementOfAcct.booking.Booking_Cust_District_Name);
ReportParameter State = new ReportParameter("State", settlementOfAcct.booking.Booking_Cust_State_Name);
ReportParameter MatTypeName = new ReportParameter("MatTypeName", settlementOfAcct.booking.Booking_MaterialType_MaterialName);
ReportParameter Quantity = new ReportParameter("Quantity", Convert.ToString(settlementOfAcct.Account_Quantity));
ReportParameter Rate = new ReportParameter("Rate", Convert.ToString(settlementOfAcct.booking.Booking_MaterialType_HandlingRate));
ReportParameter Amount = new ReportParameter("Amount", Convert.ToString(String.Format("{0:F2}", grossAmount)));
if (settlementOfAcct.booking.Booking_TruckType == true)
{
truckRegNo = settlementOfAcct.booking.Booking_StandaloneTruck_RegNo;
}
else
{
truckRegNo = settlementOfAcct.booking.Booking_Truck_RegNo;
}
ReportParameter TruckNo = new ReportParameter("TruckNo", truckRegNo);
ReportParameter InvoiceNo = new ReportParameter("InvoiceNo", settlementOfAcct.Account_InvoiceNumber);
ReportParameter ServiceTax = new ReportParameter("ServiceTax", Convert.ToString(String.Format("{0:F2}", settlementOfAcct.booking.Booking_MaterialType_ServiceTax)));
ReportParameter EducationCess = new ReportParameter("EducationCess", Convert.ToString(String.Format("{0:F2}", settlementOfAcct.booking.Booking_MaterialType_EducationCess)));
ReportParameter HigherEducationCess = new ReportParameter("HigherEducationCess", Convert.ToString(String.Format("{0:F2}", settlementOfAcct.booking.Booking_MaterialType_HigherEducationCess)));
CurrencyConvertor currenyInWords = new CurrencyConvertor();
string amountInWords = currenyInWords.Convertor(Convert.ToString(String.Format("{0:F2}", netAmount)));
ReportParameter RupeesInWords = new ReportParameter("RupeesInWords", amountInWords);
ReportParameter TotalAmount = new ReportParameter("TotalAmount", Convert.ToString(String.Format("{0:F2}",netAmount)));
ReportParameter ServiceTaxAmt = new ReportParameter("ServiceTaxAmt", Convert.ToString(String.Format("{0:F2}", serviceTaxOnAmount)));
ReportParameter EducationCessAmt = new ReportParameter("EducationCessAmt", Convert.ToString(String.Format("{0:F2}", educationCessOnAmount)));
ReportParameter HigherEducationCessAmt = new ReportParameter("HigherEducationCessAmt", Convert.ToString(String.Format("{0:F2}", higherEducationCessOnAmount)));
reportViewer.LocalReport.SetParameters(new ReportParameter[] {SNo, Date, CustName, Address, District, State,
MatTypeName, Quantity, Rate, Amount, TruckNo, InvoiceNo, ServiceTax, EducationCess, HigherEducationCess,
RupeesInWords, TotalAmount, ServiceTaxAmt, EducationCessAmt, HigherEducationCessAmt});
}
public SettlementOfAccountsDTO GetLastSettlementOfAccountsByTruckNo(string truckNo)
{
SettlementOfAccountsDTO settlementOfAcct = new SettlementOfAccountsDTO();
List<settlementofaccount> lstSettlementOfAcctDetail = ESalesUnityContainer.Container.Resolve<IGenericRepository<settlementofaccount>>()
.GetQuery().Where(item => item.booking.truckdetail.Truck_RegNo == truckNo || item.booking.standalonetruck.StandaloneTruck_RegNo == truckNo).OrderByDescending(F => F.Account_CreatedDate).ToList();
if (lstSettlementOfAcctDetail.Count > 0)
{
AutoMapper.Mapper.Map(lstSettlementOfAcctDetail[0], settlementOfAcct);
}
return settlementOfAcct;
}
/// <summary>
/// Initialize DTO propeties with page values
/// </summary>
private SettlementOfAccountsDTO InitializeSettlementDTO()
{
SettlementOfAccountsDTO settlementOfAcct = new SettlementOfAccountsDTO();
settlementOfAcct.Account_Booking_Id = Convert.ToInt32(ViewState[Globals.StateMgmtVariables.BOOKINGID]);
settlementOfAcct.Account_Quantity = Convert.ToDecimal(txtQuantity.Text.Trim());
settlementOfAcct.Account_CFormNo = txtCFormNo.Text.Trim();
settlementOfAcct.Account_FormDNumber = txtFormDNo.Text.Trim();
settlementOfAcct.Account_HGNumber = txtHologramNumber.Text.Trim();
settlementOfAcct.Account_InvoiceNumber = txtInvoiceNo.Text.Trim();
settlementOfAcct.Account_RoadPermitNo = txtRoadPermitNo.Text.Trim();
settlementOfAcct.Account_GatePassNo = txtGatePassNo.Text.Trim();
settlementOfAcct.Account_AdvanceReceived = Convert.ToDecimal(txtBlockedAmount.Text);
settlementOfAcct.Account_TiscoRate = Convert.ToDecimal(txtTiscoRate.Text);
settlementOfAcct.Account_HandlingServiceTax = Convert.ToDecimal(txtHndServiceTax.Text);
settlementOfAcct.Account_HandlingRate = Convert.ToDecimal(txtHandlingRate.Text);
settlementOfAcct.Account_HandlingECess = Convert.ToDecimal(txtHndEducationCess.Text);
settlementOfAcct.Account_HandlingHECess = Convert.ToDecimal(txtHndHigherEducationCess.Text);
settlementOfAcct.Account_TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
settlementOfAcct.Account_Balance = Convert.ToDecimal(txtBalanceBlockedAmount.Text);
settlementOfAcct.Account_CreatedBy = base.GetCurrentUserId();
settlementOfAcct.Account_CreatedDate = DateTime.Now;
settlementOfAcct.Account_Form27CId = Convert.ToInt32(ViewState["form27ID"]);
return settlementOfAcct;
}