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); }