private void txtLedgerName_KeyUp(object sender, KeyEventArgs e)
{
try
{
dgStockDetails.AutoGenerateColumns = false;
int rowNos = 1;
_entities = new MicroAccountsEntities1();
List <tbl_ItemMaster> data;
if (txtLedgerName.Text == "")
{
data = _entities.tbl_ItemMaster.ToList();
}
else
{
data = _entities.tbl_ItemMaster.Where(x => x.itemCode.Contains(txtLedgerName.Text.Trim().ToString())).ToList();
}
modelList = new List <ItemMasterVM>();
foreach (var item in data)
{
ItemMasterVM model = new ItemMasterVM();
model.rowNo = rowNos;
model.id = item.id;
model.categoryName = _entities.tbl_CategoryMaster.Where(x => x.cId == item.categoryId).FirstOrDefault().cName.ToString();
model.itemCode = item.itemCode;
model.photo = item.photo;
var itemDetail = _entities.tbl_StockItemDetails.Where(x => x.itemId == item.id).FirstOrDefault();
model.weight = (itemDetail.weight.ToString() + " " + itemDetail.unit.ToString()).ToString();
model.carret = itemDetail.carret;
model.qty = Convert.ToInt32(itemDetail.qty);
model.melting = itemDetail.melting;
model.createdDate = Convert.ToDateTime(item.createdDate).ToString("dd-MM-yyyy hh:mm tt");
model.updatedDate = Convert.ToDateTime(item.updateDate).ToString("dd-MM-yyyy hh:mm tt");
modelList.Add(model);
rowNos++;
}
dgStockDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
for (int i = 0; i < dgStockDetails.Rows.Count; i++)
{
if (dgStockDetails.Columns[2] is DataGridViewImageColumn)
{
((DataGridViewImageColumn)dgStockDetails.Columns[2]).ImageLayout = DataGridViewImageCellLayout.Stretch;
break;
}
}
dgStockDetails.RowTemplate.Height = 80;
}
catch (Exception x)
{
}
}
public bool AddItem(ItemMasterVM _ItemVM)
{
try
{
tblItemMaster Item = new tblItemMaster();
Item.ItemId = _ItemVM.ItemId;
Item.ItemName = _ItemVM.ItemName;
Item.BatchNo = _ItemVM.BatchNo;
Item.Description = _ItemVM.Description;
Item.HSN = _ItemVM.HSN;
Item.IsActive = _ItemVM.IsActive;
Item.ItemCode = _ItemVM.ItemCode;
Item.ManufacturedBy = _ItemVM.ManufacturedBy;
Item.Price = _ItemVM.Price;
Item.SerialNo = _ItemVM.SerialNo;
Item.TypeId = _ItemVM.TypeId;
Item.UOMId = _ItemVM.UOMId;
Item.IsDeleted = false;
_ItemRepository.Add(Item);
_unitOfWork.Complete();
return(true);
}
catch (Exception e)
{
throw e;
}
}
public ItemMasterVM GetItemById(int id)
{
ItemMasterVM ItemVM = new ItemMasterVM();
try
{
var Item = _ItemRepository.GetById(id);
if (Item != null)
{
ItemVM.ItemId = Item.ItemId;
ItemVM.ItemName = Item.ItemName;
ItemVM.BatchNo = Item.BatchNo;
ItemVM.Description = Item.Description;
ItemVM.HSN = Item.HSN;
ItemVM.IsActive = (bool)Item.IsActive;
ItemVM.ItemCode = Item.ItemCode;
ItemVM.ManufacturedBy = Item.ManufacturedBy;
ItemVM.Price = Item.Price;
ItemVM.SerialNo = Item.SerialNo;
ItemVM.TypeId = Item.TypeId;
ItemVM.UOMId = ItemVM.UOMId;
}
return(ItemVM);
}
catch (Exception e) { throw e; }
}
public ActionResult AddOrEditItem(ItemMasterVM _ItemVM)
{
ViewBag.Types = dropDown.DDLGetTypes();
ViewBag.Units = dropDown.DDLGetUnits();
try
{
bool status = false;
if (ModelState.IsValid)
{
if (_ItemVM.ItemId == 0)
{
//add
status = _ItemSerivce.AddItem(_ItemVM);
if (status)
{
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = "Error" }, JsonRequestBehavior.AllowGet));
}
}
else
{
//update
status = _ItemSerivce.UpdateItem(_ItemVM);
if (status)
{
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = "Error" }, JsonRequestBehavior.AllowGet));
}
}
}
else
{
return(PartialView(_ItemVM));
}
}
catch (Exception e)
{
throw e;
}
}
public ActionResult AddOrEditItem(int id = 0)
{
ItemMasterVM ItemVM = new ItemMasterVM();
ViewBag.Types = dropDown.DDLGetTypes();
ViewBag.Units = dropDown.DDLGetUnits();
if (id == 0)
{
//add
return(PartialView(ItemVM));
}
else
{
//update
ItemVM = _ItemSerivce.GetItemById(id);
return(PartialView(ItemVM));
}
}
public void SetItemVisual(ItemMasterVM item)
{
item.BorderBrush = _colorgenerator.GetNextBrush();
SelectedItemHistory.Add(item);
}
