private void PopulateSelectedAllotment(int vehicleAllotmentId) { VehicleAllotmentBL vaBl = new VehicleAllotmentBL(); int vehicleInventoryId = vaBl.GeInventoryId(vehicleAllotmentId); VehicleInventoryBL obj = new VehicleInventoryBL(); var filterefInfo = obj.GetAllVehicleInventory() .Where( i => i.VehicleInventoryID == vehicleInventoryId ).ToList(); dgVehicleInventory.DataSource = filterefInfo; }
private void LoadDefaultValues() { VehicleInventoryBL obj = new VehicleInventoryBL(); var lst = obj.GetAllVehicleInventory(); if (_mode == "ADD") { lst = lst.Where(i => i.VehicleInventoryStatusTypeID == 1).ToList(); } dgVehicleInventory.DataSource = lst; //Get All Model Name VehicleInfoBL obj1 = new VehicleInfoBL(); var allVehInfo = obj1.GetAllVehicleInfo(); ddlModelName.Items.Clear(); ddlModelCode.Items.Clear(); foreach (var vehInfo in allVehInfo) { //Load Model Name ComboboxItem itemModelName = new ComboboxItem(); itemModelName.Text = vehInfo.ModelName; itemModelName.Value = vehInfo.VehicleInfoID; ddlModelName.Items.Add(itemModelName); //Load Model Code ComboboxItem itemModelcode = new ComboboxItem(); itemModelcode.Text = vehInfo.ModelCode; itemModelcode.Value = vehInfo.VehicleInfoID; ddlModelCode.Items.Add(itemModelcode); } //Load Inventory Status ddlInventoryStatus.Items.Clear(); VehicleInventoryBL obj2 = new VehicleInventoryBL(); foreach (var status in obj2.GetInventoryStatusType()) { ComboboxItem itemInventoryStatus = new ComboboxItem(); itemInventoryStatus.Text = status.Description; itemInventoryStatus.Value = status.VehicleInventoryStatusTypeID; ddlInventoryStatus.Items.Add(itemInventoryStatus); } //Load Colors ddlColor.DataSource = GlobalSetup.colors; ddlColor.SelectedIndex = -1; }
private void PopulateInventoryVehicle(int vehicleInventoryID) { VehicleInventoryBL obj = new VehicleInventoryBL(); var vehInv = obj.GetAllVehicleInventory().Where(v => v.VehicleInventoryID == vehicleInventoryID).FirstOrDefault(); ComboboxItem selitem = new ComboboxItem(); selitem.Text = vehInv.VehicleModelName; selitem.Value = vehInv.VehicleInfoID; ddlModelName.Text = selitem.Text; txtChasisNo.Text = vehInv.ChasisNo; txtEngineNo.Text = vehInv.EngineNo; ddlColor.SelectedItem = vehInv.Color; dtMfgDate.Value = vehInv.MfgDate; txtKeyNo.Text = vehInv.KeyNo; txtBatteryMake.Text = vehInv.BatteryMake; txtBatteryNo.Text = vehInv.BatteryNo; txtServiceBookNo.Text = vehInv.ServiceBookNo; rdnMarginPrice.Checked = vehInv.IsMarginPrice; rdn50Margin.Checked = vehInv.Is50PerMarginPrice; rdn70Margin.Checked = vehInv.Is70PerMarginPrice; //InventoryStatus Populate var vehInvStatus = obj.GetInventoryStatusType().Where(iv => iv.VehicleInventoryStatusTypeID == vehInv.VehicleInventoryStatusTypeID).FirstOrDefault(); ComboboxItem selInvitem = new ComboboxItem(); selInvitem.Text = vehInvStatus.Description; selInvitem.Value = vehInvStatus.VehicleInventoryStatusTypeID; ddlInvStatus.Text = selInvitem.Text; txtShowRoomPrice.Text = vehInv.ExShowRoomPrice.ToString(); txtLTRTOtherExp.Text = vehInv.LT_RT_OtherExp.ToString(); txtInsurancePrice.Text = vehInv.InsurancePrice.ToString(); txtMarginPrice.Text = vehInv.MarginPrice.ToString(); txt50Margin.Text = vehInv.Margin50.ToString(); txt70Margin.Text = vehInv.Margin70.ToString(); txtWarranty.Text = vehInv.WarrantyPrice.ToString(); txtOnRoadPrice.Text = vehInv.OnRoadPrice.ToString(); txtRemarks.Text = vehInv.Remarks; }
private void btnSearch_Click(object sender, EventArgs e) { //var modelCode = txtModelCode.Text; var modelName = ddlModelName.SelectedText; var modelCode = ddlModelCode.SelectedText; string color = ""; if (ddlColor.SelectedItem != null) { color = ddlColor.SelectedItem.ToString(); } string inventoryStatus = ""; if (ddlInventoryStatus.SelectedItem != null) { inventoryStatus = ddlInventoryStatus.SelectedItem.ToString(); } var chasisNo = txtChasisNo.Text; var engineNo = txtEngineNo.Text; VehicleInventoryBL obj = new VehicleInventoryBL(); var filterefInfo = obj.GetAllVehicleInventory() .Where( i => i.VehicleModelName.ToUpper().Contains(modelName.ToUpper()) && i.VehicleModelCode.ToUpper().Contains(modelCode.ToUpper()) && i.ChasisNo.ToUpper().Contains(chasisNo.ToUpper()) && i.EngineNo.ToUpper().Contains(engineNo.ToUpper()) && i.Color.ToUpper().Contains(color.ToUpper()) && i.VehicleInventoryStatusName.ToUpper().Contains(inventoryStatus.ToUpper()) ).ToList(); dgVehicleInventory.DataSource = filterefInfo; }