/// <summary>
///
/// </summary>
/// <param name="vehicleType"></param>
/// <returns></returns>
public List <tblMotorVendorDetail> GetVendorDetails(int vehicleType)
{
using (var db = new hackathonteam289_dbEntities1())
{
return(db.tblMotorVendorDetails.Where(i => i.VehicleType == vehicleType).ToList());
}
}
/// <summary>
///
/// </summary>
/// <param name="vehicleType"></param>
/// <param name="brandName"></param>
/// <param name="model"></param>
/// <returns></returns>
public List <int> GetVehicleManufactureYear(int vehicleType, string brandName, string model)
{
using (var db = new hackathonteam289_dbEntities1())
{
return(db.tblMotorDetails.Where(i => i.VehicleType == vehicleType && i.Brand.ToLower() == brandName.ToLower() && i.Model.ToLower() == model.ToLower()).Select(i => i.Make).Distinct().ToList());
}
}
/// <summary>
///
/// </summary>
/// <param name="mobileNo"></param>
/// <returns></returns>
public List <tblCustomerDetail> GetCustomerDetails(string mobileNo)
{
using (var db = new hackathonteam289_dbEntities1())
{
return(db.tblCustomerDetails.Where(i => i.PrimaryContactNumber == mobileNo).ToList());
}
}
/// <summary>
///
/// </summary>
/// <param name="vehicleType"></param>
/// <returns></returns>
public List <string> GetVehicleBrands(int vehicleType)
{
using (var db = new hackathonteam289_dbEntities1())
{
return(db.tblMotorDetails.Where(i => i.VehicleType == vehicleType).Select(i => i.Brand).Distinct().ToList());
}
}
public List <string> GetPolicyNames()
{
using (var db = new hackathonteam289_dbEntities1())
{
return(db.tblMediPolicyDetails.Select(i => i.PolicyName).Distinct().ToList());
}
}
public tblMedTransactionDetail GetMedicalTransactionDetails(int id)
{
using (var db = new hackathonteam289_dbEntities1())
{
return(db.tblMedTransactionDetails.FirstOrDefault(i => i.PolicyId == id));
}
}
public List <tblMediPolicyDetail> GetMedicalPolicyDetailsByPolicyCode(string policyCode)
{
using (var db = new hackathonteam289_dbEntities1())
{
return(db.tblMediPolicyDetails.Where(i => i.PolicyCode.ToLower() == policyCode.ToLower()).ToList());
}
}
public List <string> GetAllInsuranceTypes()
{
using (var db = new hackathonteam289_dbEntities1())
{
return(db.tblInsuranceTypes.Select(i => i.InsuranceType).ToList());
}
}
public void AddInsuranceTransacationData(tblMotorPaymentDetail objMotorPaymentDetails)
{
using (var db = new hackathonteam289_dbEntities1())
{
tblMotorPaymentDetail objMotPayDetails = new tblMotorPaymentDetail();
db.SaveChanges();
}
}
/// <summary>
///
/// </summary>
/// <param name="vehicleType"></param>
/// <param name="venderName"></param>
/// <returns></returns>
public string GetVendorFeatures(int vehicleType, string venderName)
{
using (var db = new hackathonteam289_dbEntities1())
{
var vendor = db.tblMotorVendorDetails.FirstOrDefault(i => i.VehicleType == vehicleType && i.VendorName.ToLower() == venderName.ToLower());
if (vendor != null)
{
return(vendor.Features);
}
else
{
return(null);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="vehicleType"></param>
/// <param name="brandName"></param>
/// <param name="model"></param>
/// <param name="year"></param>
/// <returns></returns>
public decimal?GetVehicleAmount(int vehicleType, string brandName, string model, int year)
{
using (var db = new hackathonteam289_dbEntities1())
{
var vehicle = db.tblMotorDetails.FirstOrDefault(i => i.VehicleType == vehicleType && i.Brand.ToLower() == brandName.ToLower() && i.Model.ToLower() == model.ToLower() && i.Make == year);
if (vehicle != null)
{
return(vehicle.BaselineAmount);
}
else
{
return(null);
}
}
}
