private void PopulateSelectedAllotment(List <int> spAllotmentID)
{
List <int> lstSPInventory = new List <int>();
SparePartsAllotmentBL vaBl = new SparePartsAllotmentBL();
SparePartsInventoryBL obj = new SparePartsInventoryBL();
var allinventory = obj.GetAllSparePartsInventory();
var filterefInfo = allinventory.Where(i => i.SparePartsInventoryStatusTypeID == 1).ToList();//.Where(x => lstSPInventory.Contains(x.SparePartsInventoryID));
dgSparePartsInventory.DataSource = filterefInfo;
foreach (var spaltid in spAllotmentID)
{
ComboboxItem item = new ComboboxItem();
var inventoryId = vaBl.GetSPInventoryId(spaltid);
item.Value = inventoryId;
var inventorydto = allinventory.Where(x => x.SparePartsInventoryID == inventoryId).FirstOrDefault();
item.Text = inventorydto.SparePartsModelName;
lstBoxSPInvlist.Items.Add(item);
}
}
private void PopulateInventorySpareParts(int SparePartsInventoryID)
{
SparePartsInventoryBL obj = new SparePartsInventoryBL();
var vehInv = obj.GetAllSparePartsInventory().Where(v => v.SparePartsInventoryID == SparePartsInventoryID).FirstOrDefault();
ComboboxItem selitem = new ComboboxItem();
selitem.Text = vehInv.SparePartsModelName;
selitem.Value = vehInv.SparePartsInfoID;
ddlModelName.Text = selitem.Text;
txtIdentificationNo.Text = vehInv.IdentificationNo;
txtOtherDescription.Text = vehInv.OtherDescription;
txtShowRoomPrice.Text = vehInv.ShowRoomPrice.ToString();
txtMarginPrice.Text = vehInv.MarginPrice.ToString();
//InventoryStatus Populate
var vehInvStatus = obj.GetInventoryStatusType().Where(iv => iv.SparePartsInventoryStatusTypeID == vehInv.SparePartsInventoryStatusTypeID).FirstOrDefault();
ComboboxItem selInvitem = new ComboboxItem();
selInvitem.Text = vehInvStatus.Description;
selInvitem.Value = vehInvStatus.SparePartsInventoryStatusTypeID;
ddlInvStatus.Text = selInvitem.Text;
ddlQuantity.SelectedIndex = 0;
}
private void LoadDefaultValues()
{
SparePartsInventoryBL obj = new SparePartsInventoryBL();
var lst = obj.GetAllSparePartsInventory();
if (_mode == "ADD")
{
lst = lst.Where(i => i.SparePartsInventoryStatusTypeID == 1).ToList();
}
dgSparePartsInventory.DataSource = lst;
//Get All Model Name
ddlModelName.Items.Clear();
SparePartsInfoBL obj1 = new SparePartsInfoBL();
var allVehInfo = obj1.GetAllSparePartsInfo();
foreach (var vehInfo in allVehInfo)
{
//Load Model Name
ComboboxItem itemModelName = new ComboboxItem();
itemModelName.Text = vehInfo.ModelName;
itemModelName.Value = vehInfo.SparePartsInfoID;
ddlModelName.Items.Add(itemModelName);
}
//Load Inventory Status
ddlInventoryStatus.Items.Clear();
SparePartsInventoryBL obj2 = new SparePartsInventoryBL();
foreach (var status in obj2.GetInventoryStatusType())
{
ComboboxItem itemInventoryStatus = new ComboboxItem();
itemInventoryStatus.Text = status.Description;
itemInventoryStatus.Value = status.SparePartsInventoryStatusTypeID;
ddlInventoryStatus.Items.Add(itemInventoryStatus);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
//var modelCode = txtModelCode.Text;
var modelName = ddlModelName.SelectedText;
string inventoryStatus = "";
if (ddlInventoryStatus.SelectedItem != null)
{
inventoryStatus = ddlInventoryStatus.SelectedItem.ToString();
}
string identificationNo = txtIdentificationNo.Text;
SparePartsInventoryBL obj = new SparePartsInventoryBL();
var filterefInfo = obj.GetAllSparePartsInventory()
.Where(
i => i.SparePartsModelName.ToUpper().Contains(modelName.ToUpper())
&&
i.IdentificationNo.ToUpper().Contains(identificationNo.ToUpper())
&&
i.SparePartsInventoryStatusName.ToUpper().Contains(inventoryStatus.ToUpper())
).ToList();
dgSparePartsInventory.DataSource = filterefInfo;
}