public VehicleInventoryDTO GetVehicleInventory(int InventoryId)
{
VehicleInventoryDTO voIDTO = new VehicleInventoryDTO();
try
{
using (var entities = new ManiMotorsEntities1())
{
voIDTO = (from invlist in entities.VehicleInventories
join invstatus in entities.VehicleInventoryStatus
on invlist.VehicleInventoryID equals invstatus.VehicleInventoryID
join vehinfo in entities.VehicleInfoes
on invlist.VehicleInfoID equals vehinfo.VehicleInfoID
join vehStatus in entities.VehicleInventoryStatus
on invlist.VehicleInventoryID equals vehStatus.VehicleInventoryID
join vehStatusTypes in entities.VehicleInventoryStatusTypes
on vehStatus.VehicleInventoryStatusTypeID equals vehStatusTypes.VehicleInventoryStatusTypeID
where invlist.VehicleInventoryID == InventoryId
select new VehicleInventoryDTO
{
VehicleInventoryID = invlist.VehicleInventoryID,
VehicleInfoID = invlist.VehicleInfoID,
VehicleModelName = vehinfo.ModelName,
VehicleModelCode = vehinfo.ModelCode,
ChasisNo = invlist.ChasisNo,
EngineNo = invlist.EngineNo,
Color = invlist.Color,
MfgDate = invlist.ManfgDate ?? DateTime.Now,
ServiceBookNo = invlist.ServiceBookNo,
KeyNo = invlist.KeyNo,
BatteryMake = invlist.BatteryMake,
BatteryNo = invlist.BatteryNo,
VehicleInventoryStatusTypeID = vehStatusTypes.VehicleInventoryStatusTypeID,
VehicleInventoryStatusName = vehStatusTypes.Description,
Is50PerMarginPrice = invlist.Is50PercentMarginPrice ?? false,
Is70PerMarginPrice = invlist.Is70PercentMarginPrice ?? false,
IsMarginPrice = invlist.IsMarginPrice ?? false,
ExShowRoomPrice = invlist.ExShowroomPrice ?? 0,
LT_RT_OtherExp = invlist.LT_RT_OtherExp ?? 0,
InsurancePrice = invlist.InsurancePrice ?? 0,
OnRoadPrice = invlist.OnRoadPrice ?? 0,
MarginPrice = invlist.MarginPrice ?? 0,
Margin50 = invlist.CreditPercentMargin ?? 0,
Margin70 = invlist.FullCashPercentMargin ?? 0,
WarrantyPrice = invlist.WarrantyPrice ?? 0
}).FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(voIDTO);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (ddlModelName.SelectedIndex == -1 || txtChasisNo.Text == "" || txtEngineNo.Text == "" || ddlColor.SelectedIndex == -1 || txtServiceBookNo.Text == "" || txtKeyNo.Text == "" || txtBatteryNo.Text == "" || txtBatteryMake.Text == "" || ddlInvStatus.SelectedIndex == -1 || txtShowRoomPrice.Text == "" || txtLTRTOtherExp.Text == "" || txtInsurancePrice.Text == "" || txtMarginPrice.Text == "" || txt50Margin.Text == "" || txt70Margin.Text == "" || txtWarranty.Text == "" || txtOnRoadPrice.Text == "" || (!rdn50Margin.Checked && !rdn70Margin.Checked && !rdnMarginPrice.Checked))
{
MyMessageBox.ShowBox("Please Select All Mandatory Fields !!!");
return;
}
if (txtShowRoomPrice.Text == "0" || txtLTRTOtherExp.Text == "0" || txtInsurancePrice.Text == "0" || txtMarginPrice.Text == "0" || txt50Margin.Text == "0" || txt70Margin.Text == "0" || txtWarranty.Text == "0" || txtOnRoadPrice.Text == "0")
{
MyMessageBox.ShowBox("Price cannot be 0 !!!");
return;
}
if (ddlInvStatus.SelectedIndex != 0 && txtRemarks.Text == "")
{
MyMessageBox.ShowBox("Remarks Cannot be Empty !!!");
return;
}
VehicleInventoryDTO info = new VehicleInventoryDTO();
var selItem = (ComboboxItem)ddlModelName.SelectedItem;
info.VehicleInventoryID = _vehicleInventoryID;
info.VehicleInfoID = Convert.ToInt32(selItem.Value);
info.ChasisNo = txtChasisNo.Text;
info.EngineNo = txtEngineNo.Text;
info.Color = ddlColor.SelectedItem.ToString();
info.MfgDate = Convert.ToDateTime(dtMfgDate.Text);
info.KeyNo = txtKeyNo.Text;
info.BatteryMake = txtBatteryMake.Text;
info.BatteryNo = txtBatteryNo.Text;
info.ServiceBookNo = txtServiceBookNo.Text;
info.CreatedDate = System.DateTime.Now;
info.CreatedBy = GlobalSetup.Userid;
info.ModifiedDate = System.DateTime.Now;
info.ModifiedBy = GlobalSetup.Userid;
info.Is50PerMarginPrice = rdn50Margin.Checked;
info.Is70PerMarginPrice = rdn70Margin.Checked;
info.IsMarginPrice = rdnMarginPrice.Checked;
info.ExShowRoomPrice = Convert.ToInt32(txtShowRoomPrice.Text);
info.LT_RT_OtherExp = Convert.ToInt32(txtLTRTOtherExp.Text);
info.InsurancePrice = Convert.ToInt32(txtInsurancePrice.Text);
info.OnRoadPrice = Convert.ToInt32(txtOnRoadPrice.Text);
info.MarginPrice = Convert.ToInt32(txtMarginPrice.Text);
info.Margin50 = Convert.ToInt32(txt50Margin.Text);
info.Margin70 = Convert.ToInt32(txt70Margin.Text);
info.WarrantyPrice = Convert.ToInt32(txtWarranty.Text);
info.Remarks = txtRemarks.Text;
var invSelitem = (ComboboxItem)ddlInvStatus.SelectedItem;
info.VehicleInventoryStatusTypeID = Convert.ToInt32(invSelitem.Value);
info.Remarks = txtRemarks.Text;
VehicleInventoryBL viBL = new VehicleInventoryBL();
var flag = viBL.SaveInventoryVehicle(info, _mode);
if (flag)
{
MyMessageBox.ShowBox("Vehicle Inventory Saved", "Vehicle Inventory");
Clear();
}
else
{
MyMessageBox.ShowBox("Vehicle Inventory Failed to Save", "Vehicle Inventory");
}
this.Close();
}
public bool SaveInventoryVehicle(VehicleInventoryDTO dto, string mode)
{
var flag = false;
try
{
using (var entities = new ManiMotorsEntities1())
{
if (mode == "EDIT")
{
var info = entities.VehicleInventories.FirstOrDefault(v => v.VehicleInventoryID == dto.VehicleInventoryID);
info.VehicleInfoID = dto.VehicleInfoID;
info.ChasisNo = dto.ChasisNo;
info.EngineNo = dto.EngineNo;
info.Color = dto.Color;
info.ManfgDate = dto.MfgDate;
info.ServiceBookNo = dto.ServiceBookNo;
info.KeyNo = dto.KeyNo;
info.BatteryMake = dto.BatteryMake;
info.BatteryNo = dto.BatteryNo;
info.CreatedDate = dto.CreatedDate;
info.Createdby = dto.CreatedBy;
info.ModifiedDate = dto.ModifiedDate;
info.Modifiedby = dto.ModifiedBy;
info.IsMarginPrice = dto.IsMarginPrice;
info.Is50PercentMarginPrice = dto.Is50PerMarginPrice;
info.Is70PercentMarginPrice = dto.Is70PerMarginPrice;
info.ExShowroomPrice = dto.ExShowRoomPrice;
info.LT_RT_OtherExp = dto.LT_RT_OtherExp;
info.InsurancePrice = dto.InsurancePrice;
info.OnRoadPrice = dto.OnRoadPrice;
info.MarginPrice = dto.MarginPrice;
info.CreditPercentMargin = dto.Margin50;
info.FullCashPercentMargin = dto.Margin70;
info.WarrantyPrice = dto.WarrantyPrice;
entities.SaveChanges();
var invInfo = entities.VehicleInventoryStatus.FirstOrDefault(vi => vi.VehicleInventoryID == dto.VehicleInventoryID);
if (invInfo != null)
{
invInfo.VehicleInventoryStatusTypeID = dto.VehicleInventoryStatusTypeID;
invInfo.Remarks = dto.Remarks;
invInfo.Modifiedby = dto.ModifiedBy;
invInfo.ModifiedDate = dto.ModifiedDate;
entities.SaveChanges();
}
flag = true;
}
else
{
VehicleInventory info = new VehicleInventory()
{
VehicleInfoID = dto.VehicleInfoID,
ChasisNo = dto.ChasisNo,
EngineNo = dto.EngineNo,
Color = dto.Color,
ManfgDate = dto.MfgDate,
ServiceBookNo = dto.ServiceBookNo,
KeyNo = dto.KeyNo,
BatteryNo = dto.BatteryNo,
BatteryMake = dto.BatteryMake,
CreatedDate = dto.CreatedDate,
Createdby = dto.CreatedBy,
ModifiedDate = dto.ModifiedDate,
Modifiedby = dto.ModifiedBy,
IsMarginPrice = dto.IsMarginPrice,
Is50PercentMarginPrice = dto.Is50PerMarginPrice,
Is70PercentMarginPrice = dto.Is70PerMarginPrice,
ExShowroomPrice = dto.ExShowRoomPrice,
LT_RT_OtherExp = dto.LT_RT_OtherExp,
InsurancePrice = dto.InsurancePrice,
OnRoadPrice = dto.OnRoadPrice,
MarginPrice = dto.MarginPrice,
CreditPercentMargin = dto.Margin50,
FullCashPercentMargin = dto.Margin70,
WarrantyPrice = dto.WarrantyPrice,
};
entities.VehicleInventories.Add(info);
entities.SaveChanges();
VehicleInventoryStatu obj = new VehicleInventoryStatu();
obj.VehicleInventoryID = info.VehicleInventoryID;
obj.VehicleInventoryStatusTypeID = dto.VehicleInventoryStatusTypeID;//InStock Status
obj.Remarks = dto.Remarks;
entities.VehicleInventoryStatus.Add(obj);
entities.SaveChanges();
flag = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}
public InvoiceDTO GetInvoiceDetails(int VehicleBookingId)
{
var Invoicedto = new InvoiceDTO();
var vBL = new VehicleBookingBL();
var viBL = new VehicleInventoryBL();
var vABL = new VehicleAllotmentBL();
var spABL = new SparePartsAllotmentBL();
var spInventory = new SparePartsInventoryBL();
var fABL = new FinanceAllotmentBL();
var vehicleBooking = vBL.GetVehicleBooking(VehicleBookingId);
//Customer Information
var ctmrDTO = new CustomerDTO();
//VehicleInventory
var vIDTO = new VehicleInventoryDTO();
//VehicleBooking
var vBDTO = new VehicleBookingDTO();
//SpareParts Inventory
var spInvDTOlist = new List <SparePartsInventoryDTO>();
//Finance Allotment
var fDTO = new FinanceAllotmentDTO();
if (vehicleBooking != null)
{
vBDTO = vehicleBooking;
Invoicedto.VclBooking = vBDTO;
ctmrDTO.CustomerID = vehicleBooking.CustomerID;
ctmrDTO.Name = vehicleBooking.CustomerName;
Invoicedto.Customer = ctmrDTO;
//Get Vehicle Inventory ID from VehicleAllotment Id
int vInventoryId = vABL.GeInventoryId(vehicleBooking.VehicleBookingAllotmentId ?? 0);
if (vInventoryId != 0)
{
var invDTO = viBL.GetVehicleInventory(vInventoryId);
vIDTO.EngineNo = invDTO.EngineNo;
vIDTO.ChasisNo = invDTO.ChasisNo;
vIDTO.VehicleModelName = invDTO.VehicleModelName;
vIDTO.ExShowRoomPrice = invDTO.ExShowRoomPrice;
vIDTO.LT_RT_OtherExp = invDTO.LT_RT_OtherExp;
vIDTO.InsurancePrice = invDTO.InsurancePrice;
vIDTO.OnRoadPrice = invDTO.OnRoadPrice;
vIDTO.WarrantyPrice = invDTO.WarrantyPrice;
vIDTO.VehicleInventoryID = vInventoryId;
if (invDTO.Is70PerMarginPrice)
{
vIDTO.MarginPrice = invDTO.Margin70;
}
if (invDTO.Is50PerMarginPrice)
{
vIDTO.MarginPrice = invDTO.Margin50;
}
Invoicedto.VehicleInventory = vIDTO;
}
//Get SpareParts Allotment Details
var sPAltList = spABL.GetSparePartsAllotmentbyBookingId(VehicleBookingId);
if (sPAltList.Count > 0)
{
foreach (var sp in sPAltList)
{
var spIDTO = new SparePartsInventoryDTO();
if (sp.SparePartsInventoryID != 0)
{
var spI = spInventory.GetSparePartsInventory(sp.SparePartsInventoryID);
//SpareParts Inventory
SparePartsInventoryDTO spidto = new SparePartsInventoryDTO();
spidto.SparePartsInventoryID = sp.SparePartsInventoryID;
spidto.ShowRoomPrice = spI.ShowRoomPrice;
spidto.MarginPrice = spI.MarginPrice;
spidto.SparePartsModelName = spI.SparePartsModelName;
spidto.SparePartsInfoID = spI.SparePartsInfoID;
spInvDTOlist.Add(spidto);
}
}
Invoicedto.lstSparePartsInventory = spInvDTOlist;
}
//Finance Allotment
if (vehicleBooking.FinanceAllotmentId != null && vehicleBooking.FinanceAllotmentId != 0)
{
fDTO = fABL.GetFinanceAllotment(vehicleBooking.FinanceAllotmentId ?? 0);
Invoicedto.FinanceAllotment = fDTO;
}
}
return(Invoicedto);
}
