public ListResultDto <QuoteDetailDto> GetQuotes(GetQuoteInput input)
{
int Id = Convert.ToInt32(input.Filter);
var quotes = _quotedetailsrepository.GetAll().Where(p => p.QuoteId == Id && p.tenantid == _abpSession.TenantId && p.IsDeleted.Equals(false) && p.QuoteStatusId == input.StatusId).ToList();
if (quotes.Count == 0)
{
var aa = new QuoteDetails();
aa.QuoteStatusId = 0;
aa.IsCompleted = false;
aa.QuoteId = Id;
aa.QLocation = "";
aa.QAction = "";
aa.Description = "";
aa.Part = "";
quotes = new List <QuoteDetails>();
quotes.Add(aa);
}
var finalquery = new ListResultDto <QuoteDetailDto>(ObjectMapper.Map <List <QuoteDetailDto> >(quotes));
var EstimatedValues = _quotemasterrepository.FirstOrDefault(p => p.Id == Id && p.TenantId == _abpSession.TenantId);
if (EstimatedValues != null)
{
finalquery.Items[0].RepairerEstimatedDays = EstimatedValues.RepairerEstimatedDays;
}
return(finalquery);
}
public void CompleteQuote(GetQuoteInput input)
{
int Id = Convert.ToInt32(input.Filter);
var Tonewrow = _quotedetailsrepository.GetAll().Where(p => p.QuoteId == Id && p.IsDeleted == false && p.IsCompleted == false && p.QuoteStatusId == 1).ToList();
foreach (var qmaster in Tonewrow)
{
qmaster.IsCompleted = true;
qmaster.QuoteStatusId = 1;
qmaster.QuoteId = Id;
_quotedetailsrepository.Update(qmaster);
}
}
public QuoteSummaryDto GetQuoteJobSummary(GetQuoteInput input)
{
int Id = Convert.ToInt32(input.Filter);
var qmaster = _quotemasterrepository.GetAll().Where(c => c.Id == Id).FirstOrDefault();
var JobMaster = _jobsrrepository.GetAll().Where(c => c.Id == qmaster.JobId).FirstOrDefault();
var VehicleMaster = _vehiclerrepository.GetAll().Where(c => c.Id == JobMaster.VehicleID).FirstOrDefault();
var InsurerName = _insurerrrepository.GetAll().Where(c => c.Id == JobMaster.InsuranceID).FirstOrDefault().InsurerName;
var BrokerName = _brokerrrepository.GetAll().Where(c => c.Id == JobMaster.BrokerID).FirstOrDefault().BrokerName;
var quotestatus = _qstatusrepository.GetAll().Where(c => c.Id == qmaster.QuoteStatusID).FirstOrDefault().Description;
var quotecategories = _quotecatrepository.GetAll().Where(c => c.Id == qmaster.QuoteCatID).FirstOrDefault().Description;
var repairtypes = _repairtyperepository.GetAll().Where(c => c.Id == qmaster.RepairTypeId).FirstOrDefault().Description;
var model = _modelepository.GetAll().Where(c => c.Id == VehicleMaster.ModelId).FirstOrDefault();
var make = _makerepository.GetAll().Where(c => c.Id == model.VehicleMakeID).FirstOrDefault().Description;
var createdBy = UserManager.Users.FirstOrDefault(c => c.Id == qmaster.CreatorUserId).UserName;
var sdtos = new QuoteSummaryDto();
sdtos.JobId = JobMaster.Id;
sdtos.QuoteCat = quotecategories;
sdtos.QuoteStatus = quotestatus;
sdtos.QuoteCreated = qmaster.CreationTime.ToShortDateString();
sdtos.Value = qmaster.Value;
sdtos.VehicleYear = VehicleMaster.Year;
sdtos.VehicleColor = VehicleMaster.Color;
sdtos.VehicleReg = VehicleMaster.RegistrationNumber;
sdtos.VehicleVin = VehicleMaster.VinNumber;
sdtos.VehicleCreatedBy = JobMaster.CreationTime.ToShortDateString();
sdtos.RepairType = repairtypes;
sdtos.Pre_Auth = qmaster.Pre_Auth ? "Yes" : "No";
sdtos.VehicleMake = make;
sdtos.VehicleModal = model.Model;
sdtos.Broker = BrokerName;
sdtos.Insurer = InsurerName;
sdtos.Id = Id;
sdtos.CreatedBy = createdBy;
return(sdtos.MapTo <QuoteSummaryDto>());
}
public void CompleteQuoteCallBack(GetQuoteInput input)
{
int Id = Convert.ToInt32(input.Filter);
var Tonewrow = _quotedetailsrepository.GetAll().Where(p => p.QuoteId == Id && p.IsDeleted == false && p.IsCompleted == true && p.QuoteStatusId == 1).ToList();
foreach (var qmaster in Tonewrow)
{
qmaster.IsCompleted = false;
qmaster.QuoteStatusId = input.StatusId;
_quotedetailsrepository.Insert(qmaster);
}
var master = _quotemasterrepository.FirstOrDefault(p => p.Id == Id);
master.QuoteStatusID = input.StatusId;
_quotemasterrepository.Update(master);
}
public ListResultDto <QuoteMastersDto> ViewQuotations(GetQuoteInput input)
{
var JobMaster = _jobsrrepository.GetAll().Where(c => c.TenantID == _abpSession.TenantId && c.IsDeleted == false).ToList();
var VehicleMaster = _vehiclerrepository.GetAll().Where(c => c.TenantId == _abpSession.TenantId && c.IsDeleted == false).ToList();
var quotestatus = _qstatusrepository.GetAll().Where(x => x.Enabled == true && x.IsDeleted == false).ToList();
var quotecategories = _quotecatrepository.GetAll().Where(x => x.Enabled == true && x.IsDeleted == false).ToList();
var repairtypes = _repairtyperepository.GetAll().Where(x => x.Enabled == true && x.IsDeleted == false).ToList();
var qmaster = _quotemasterrepository.GetAll().Where(c => c.TenantId == _abpSession.TenantId && c.IsDeleted == false).ToList();
var user = UserManager.Users.ToList();
var quoteMaster = (from y1 in qmaster
join s in quotestatus on y1.QuoteStatusID equals s.Id
join c in quotecategories on y1.QuoteCatID equals c.Id
join r in repairtypes on y1.RepairTypeId equals r.Id
join u in user on(y1.LastModifierUserId != null ? y1.LastModifierUserId : y1.CreatorUserId) equals u.Id
select new
{
y1.Id,
y1.JobId,
y1.Value,
y1.CreationTime,
QuoteCat = c.Description,
RepairType = r.Description,
QuoteStatus = s.Description,
y1.Pre_Auth,
u.Surname,
u.Name
}).ToList();
var finalQuery = (from v in JobMaster
join master in quoteMaster on v.Id equals master.JobId
//into pp from y1 in pp.DefaultIfEmpty()
select new QuoteMastersDto
{
JobId = v.Id,
Id = master == null ? 0 : master.Id,
Job = _vehiclerrepository.FirstOrDefault(p => p.Id == v.VehicleID).RegistrationNumber,
Value = master == null ? "" : master.Value,
CreationTime = master == null ? DateTime.MinValue : master.CreationTime,
QuoteCat = master == null ? "" : master.QuoteCat,
RepairType = master == null ? "" : master.RepairType,
QuoteStatus = master == null ? "" : master.QuoteStatus,
Pre_Auth = master == null ? false : master.Pre_Auth,
LastModifierUser = master == null ? "" : master.Surname + " " + master.Name,
}).WhereIf(!input.Filter.IsNullOrWhiteSpace(),
u =>
u.Job.Contains(input.Filter) ||
u.QuoteCat.Contains(input.Filter) ||
u.RepairType.Contains(input.Filter) ||
u.QuoteStatus.Contains(input.Filter)
).OrderByDescending(p => p.CreationTime).ToList();
return(new ListResultDto <QuoteMastersDto>(ObjectMapper.Map <List <QuoteMastersDto> >(finalQuery)));
}
public int CurrentQuoteStatusId(GetQuoteInput input)
{
int Id = Convert.ToInt32(input.Filter);
return(_quotemasterrepository.FirstOrDefault(p => p.Id == Id).QuoteStatusID);
}
public bool IsQuotePreparationCompleted(GetQuoteInput input)
{
int Id = Convert.ToInt32(input.Filter);
return(_quotedetailsrepository.FirstOrDefault(p => p.QuoteId == Id && p.IsDeleted == false && p.QuoteStatusId == input.StatusId).IsCompleted);
}
public void DeleteQuote(GetQuoteInput input)
{
int Id = Convert.ToInt32(input.Filter);
_quotedetailsrepository.Delete(Id);
}
