public void UpdatePriority(string id) { ItemSupplier itemSupplier = itemSupplierContext.Get(id); itemSupplier.Priority += 1; itemSupplierContext.Commit(); }
/// <summary> /// Eric Bostwick /// Created 2/4/2019 /// Inserts records to the itemsupplier table /// </summary> /// <returns> /// 1 if successful 0 if not /// </returns> /// public int InsertItemSupplier(ItemSupplier itemSupplier) { int result; var conn = DBConnection.GetDbConnection(); var cmdText = @"sp_create_itemsupplier"; var cmd = new SqlCommand(cmdText, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ItemID", itemSupplier.ItemID); cmd.Parameters.AddWithValue("@SupplierID", itemSupplier.SupplierID); cmd.Parameters.AddWithValue("@PrimarySupplier", itemSupplier.PrimarySupplier); cmd.Parameters.AddWithValue("@LeadTimeDays", itemSupplier.LeadTimeDays); cmd.Parameters.AddWithValue("@UnitPrice", itemSupplier.UnitPrice); cmd.Parameters.AddWithValue("@SupplierItemID", itemSupplier.ItemSupplierID); try { conn.Open(); result = cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); } return(result); }
/// <summary> /// Eric Bostwick /// Created: 2/7/19 /// Copies an itemsupplier object to a new itemsupplier object /// </summary> /// <param name="item"> /// The itemsupplier to be copied /// </param> /// <returns> /// A copy of the itemsupplier object /// </returns> private static ItemSupplier CopyItemSupplier(ItemSupplier itemSupplier) { ItemSupplier _newItemSupplier = new ItemSupplier() { Address = itemSupplier.Address, City = itemSupplier.City, ContactFirstName = itemSupplier.ContactFirstName, ContactLastName = itemSupplier.ContactLastName, Country = itemSupplier.Country, DateAdded = itemSupplier.DateAdded, Description = itemSupplier.Description, Email = itemSupplier.Email, ItemID = itemSupplier.ItemID, LeadTimeDays = itemSupplier.LeadTimeDays, Name = itemSupplier.Name, PhoneNumber = itemSupplier.PhoneNumber, PostalCode = itemSupplier.PostalCode, PrimarySupplier = itemSupplier.PrimarySupplier, State = itemSupplier.State, SupplierID = itemSupplier.SupplierID, UnitPrice = itemSupplier.UnitPrice, ItemSupplierActive = itemSupplier.ItemSupplierActive }; return(_newItemSupplier); }
//overloading the updatePriority method public void UpdatePriority(string id, int order) { ItemSupplier itemSupplier = itemSupplierContext.Get(id); itemSupplier.Priority = order; itemSupplierContext.Commit(); }
public void TestCreateItemSupplierInValidInputUnitPriceGreaterThan9999() { //arrange ItemSupplier newItemSupplier = new ItemSupplier() { ItemID = 100004, SupplierID = 100009, Active = true, Address = "2455 Staggering Home St", City = "North Liberty", State = "IA", PostalCode = "52446", Country = "USA", ContactFirstName = "Joe", ContactLastName = "Smith", PhoneNumber = "13193353333", DateAdded = DateTime.Parse("2011-05-15"), Description = "", Email = "", ItemSupplierActive = true, Name = "Alcohol Whole Supply", PrimarySupplier = true, LeadTimeDays = 10, UnitPrice = 10000M }; //Act _itemSupplierManager.CreateItemSupplier(newItemSupplier); }
internal static void CreatePO(List <ItemSupplier> listrr) { PurchaseOrder po = new PurchaseOrder(); po.items = new List <ItemSupplier>(); ItemSupplier xx = new ItemSupplier(); int sId = listrr.FirstOrDefault().item.Id; int iId = listrr.FirstOrDefault().supplier.Id; using (var db = new ADDbContext()) { foreach (ItemSupplier its in listrr) { if (db.ItemSupplier.Where(x => x.item.Id == its.item.Id && x.supplier.Id == its.supplier.Id).Any()) { xx = db.ItemSupplier.Where(x => x.item.Id == its.item.Id && x.supplier.Id == its.supplier.Id).FirstOrDefault(); } po.items.Add(xx); } po.RequestDelivDate = DateTime.Today.AddDays(15); po.status = "pending"; db.PurchaseOrder.Add(po); db.SaveChanges(); } }
public void Save(ItemSupplier itemSupplier) { int count = GetSuppliersByItem(itemSupplier.ItemId).Count(); int p = 0; if (count == 0) { p = 3; } else if (count == 1) { p = 2; } else if (count == 2) { p = 1; } ItemSupplier iSup = new ItemSupplier() { ItemId = itemSupplier.ItemId, Price = itemSupplier.Price, SupplierId = itemSupplier.SupplierId, Priority = p }; itemSupplierContext.Add(iSup); itemSupplierContext.Commit(); }
/// <summary> /// This method is used for insert new category in database. - JJ /// </summary> /// <param name="category">object of CategoryAC</param> /// <param name="companyId"></param> /// <returns>saved object of CategoryAC</returns> public CategoryAC SaveCategory(CategoryAC category, int companyId) { try { var categorys = new Category { CompanyId = companyId, GroupParamTypeId = category.GroupParamTypeId, BrandParamTypeId = category.BrandParamTypeId, CreatedDateTime = DateTime.UtcNow, }; _categoryContext.Add(categorys); _categoryContext.SaveChanges(); category.CategoryId = categorys.Id; var supplier = new ItemSupplier { SupplierId = category.SupplierId, CategoryId = category.CategoryId, CreatedDateTime = DateTime.UtcNow }; _itemSupplierContext.Add(supplier); _itemSupplierContext.SaveChanges(); return(category); } catch (Exception ex) { _errorLog.LogException(ex); throw; } }
/// <summary> /// This method is used for getting list of Item Suppliers. - JJ /// </summary> /// <param name="id">ID OF Category</param> /// <returns>list of object of ItemSupplier</returns> public List <ItemSupplier> GetItemSupplierList(int id) { try { var supplierList = new List <ItemSupplier>(); var listSupplier = _itemSupplierContext.Fetch(x => x.CategoryId == id && x.IsDelete == false).ToList(); foreach (var supplier in listSupplier) { ItemSupplier itemsupplier = new ItemSupplier { CategoryId = supplier.CategoryId, SupplierId = supplier.SupplierId, SupplierProfile = supplier.SupplierProfile, Id = supplier.Id, CreatedDateTime = supplier.CreatedDateTime }; supplierList.Add(itemsupplier); } return(supplierList); } catch (Exception ex) { _errorLog.LogException(ex); throw; } }
//Contructor If we are adding an item supplier public frmAddItemSupplierForItem(Item item, EditMode editmode) { InitializeComponent(); _item = item; _itemSupplier = new ItemSupplier(); _editMode = editmode; LoadControls(); LoadSupplierCombo(); }
//Constructor if we are editing an item supplier public frmAddItemSupplierForItem(Item item, ItemSupplier itemSupplier, EditMode editMode) { InitializeComponent(); _item = item; _itemSupplier = itemSupplier; _editMode = editMode; LoadControls(); }
public List <ItemSupplier> SelectItemSuppliersByItemID(int itemID) { /// <summary> /// Eric Bostwick /// Created 2/4/2019 /// Gets list of itemsuppliers from itemsupplier table /// using the itemID /// </summary> /// <returns> /// List of ItemSupplier Objects /// </returns> { List <ItemSupplier> itemSuppliers = new List <ItemSupplier>(); var conn = DBConnection.GetDbConnection(); var cmdText = @"sp_select_itemsuppliers_by_itemid"; //sp_retrieve_itemsuppliers_by_itemid var cmd = new SqlCommand(cmdText, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ItemID", itemID); try { conn.Open(); var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { ItemSupplier itemSupplier = new ItemSupplier(); itemSupplier.ItemID = reader.GetInt32(reader.GetOrdinal("ItemID")); itemSupplier.SupplierID = reader.GetInt32(reader.GetOrdinal("SupplierID")); itemSupplier.PrimarySupplier = reader.GetBoolean(reader.GetOrdinal("PrimarySupplier")); itemSupplier.LeadTimeDays = reader.GetInt32(reader.GetOrdinal("LeadTimeDays")); itemSupplier.UnitPrice = (decimal)reader.GetSqlMoney(reader.GetOrdinal("UnitPrice")); itemSupplier.Name = reader["Name"].ToString(); itemSupplier.Description = reader["Description"].ToString(); itemSupplier.ItemSupplierActive = reader.GetBoolean(reader.GetOrdinal("ItemSupplierActive")); itemSupplier.ItemSupplierID = reader.GetInt32(reader.GetOrdinal("SupplierItemID")); itemSuppliers.Add(itemSupplier); } } } catch (Exception) { throw; } finally { conn.Close(); } return(itemSuppliers); } }
public void TestUpdateItemSupplierInvalidLeadTimeDays366() { //Arrange ItemSupplier newItemSupplier = new ItemSupplier(); setItemSupplier(newItemSupplier, _itemSuppliers[0]); newItemSupplier.LeadTimeDays = 366; //Act _itemSupplierManager.UpdateItemSupplier(newItemSupplier, _itemSuppliers[0]); }
public void TestUpdateItemSupplierInvalidUnitPriceNegative() { //Arrange ItemSupplier newItemSupplier = new ItemSupplier(); setItemSupplier(newItemSupplier, _itemSuppliers[0]); newItemSupplier.UnitPrice = -0.01M; //Act _itemSupplierManager.UpdateItemSupplier(newItemSupplier, _itemSuppliers[0]); }
public void TestUpdateItemSupplierInvalidUnitPriceTooHigh() { //Arrange ItemSupplier newItemSupplier = new ItemSupplier(); setItemSupplier(newItemSupplier, _itemSuppliers[0]); newItemSupplier.UnitPrice = 10000.00M; //Act _itemSupplierManager.UpdateItemSupplier(newItemSupplier, _itemSuppliers[0]); }
/// <summary> /// Eric Bostwick /// Created 2/4/2019 /// Gets an ItemSupplier from itemsupplier table /// using the itemID and supplierid /// </summary> /// <returns> /// ItemSupplier Object /// </returns> public ItemSupplier SelectItemSupplierByItemIDandSupplierID(int itemID, int supplierID) { ItemSupplier itemSupplier = new ItemSupplier(); var conn = DBConnection.GetDbConnection(); var cmdText = @"sp_select_itemsupplier_by_itemid_and_supplierid"; //sp_retrieve_itemsupplier_by_itemid_and_supplyid var cmd = new SqlCommand(cmdText, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ItemID", itemID); cmd.Parameters.AddWithValue("@SupplierID", supplierID); try { conn.Open(); var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { itemSupplier.ItemID = reader.GetInt32(reader.GetOrdinal("ItemID")); itemSupplier.SupplierID = reader.GetInt32(reader.GetOrdinal("SupplierID")); itemSupplier.PrimarySupplier = reader.GetBoolean(reader.GetOrdinal("PrimarySupplier")); itemSupplier.LeadTimeDays = reader.GetInt32(reader.GetOrdinal("LeadTimeDays")); itemSupplier.UnitPrice = (decimal)reader.GetSqlMoney(reader.GetOrdinal("UnitPrice")); itemSupplier.Address = reader["Address"].ToString(); itemSupplier.City = reader["City"].ToString(); itemSupplier.ContactFirstName = reader["ContactFirstName"].ToString(); itemSupplier.ContactLastName = reader["ContactLastName"].ToString(); itemSupplier.Country = reader["Country"].ToString(); itemSupplier.DateAdded = reader.GetDateTime(reader.GetOrdinal("DateAdded")); itemSupplier.Description = reader["Description"].ToString(); itemSupplier.Email = reader["Email"].ToString(); itemSupplier.Name = reader["Name"].ToString(); itemSupplier.Active = reader.GetBoolean(reader.GetOrdinal("SupplierActive")); itemSupplier.PhoneNumber = reader["PhoneNumber"].ToString(); itemSupplier.PostalCode = reader["PostalCode"].ToString(); itemSupplier.State = reader["State"].ToString(); itemSupplier.ItemSupplierActive = reader.GetBoolean(reader.GetOrdinal("ItemSupplierActive")); itemSupplier.ItemSupplierID = reader.GetInt32(reader.GetOrdinal("SupplierItemID")); } } } catch (Exception) { throw; } finally { conn.Close(); } return(itemSupplier); }
public ItemSupplier SelectItemSupplierByItemIDandSupplierID(int itemID, int supplierID) { ItemSupplier i = new ItemSupplier(); i = _itemSuppliers.Find(x => x.ItemID == itemID & x.SupplierID == supplierID); if (i == null) { throw new ArgumentException("Item Supplier Not Found"); } return(i); }
//Need to Load up the _itemSupplier Object to fill out the supplier data on the screen private void LoadItemSupplier() { try { _itemSupplier = _itemSupplierManager.RetrieveItemSupplier(_item.ItemID, _itemSupplier.SupplierID); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void TestRetrieveItemSupplier() { //Arrange ItemSupplier _itemsupplier = null; //Act _itemsupplier = _itemSupplierManager.RetrieveItemSupplier(100002, 100005); //Assert Assert.AreEqual(_itemsupplier.ItemID, 100002); Assert.AreEqual(_itemsupplier.SupplierID, 100005); }
public void TestDeleteItemSupplier() { //Arrange This is a known item supplier int itemID = 100002; int supplierID = 100005; ItemSupplier itemSupplier = new ItemSupplier(); //Act _itemSupplierManager.DeleteItemSupplier(itemID, supplierID); //Assert should throw exception itemSupplier = _itemSupplierManager.RetrieveItemSupplier(itemID, supplierID); }
public void TestUpdateItemSupplierValidUnit5000() { //Arrange ItemSupplier newItemSupplier = new ItemSupplier(); setItemSupplier(newItemSupplier, _itemSuppliers[0]); newItemSupplier.UnitPrice = 5000.00M; //Act _itemSupplierManager.UpdateItemSupplier(newItemSupplier, _itemSuppliers[0]); //Assert Assert.AreEqual(_itemSupplierManager.RetrieveItemSupplier(_itemSuppliers[0].ItemID, _itemSuppliers[0].SupplierID).UnitPrice, 5000.00M); }
public void TestUpdateItemSupplierLeadTimeDays365() { //Arrange ItemSupplier newItemSupplier = new ItemSupplier(); setItemSupplier(newItemSupplier, _itemSuppliers[0]); newItemSupplier.LeadTimeDays = 365; //Act _itemSupplierManager.UpdateItemSupplier(newItemSupplier, _itemSuppliers[0]); //Assert Assert.AreEqual(_itemSupplierManager.RetrieveItemSupplier(_itemSuppliers[0].ItemID, _itemSuppliers[0].SupplierID).LeadTimeDays, 365); }
/// <summary> /// check itemSupplier exists in databse or not. - JJ /// </summary> /// <param name="itemSupplier">object of ItemSupplier</param> /// <returns>return true if itemSupplier already exist,otherwise false</returns> public bool CheckItemSupplierExixtsOrNot(ItemSupplier itemSupplier) { try { return(_itemSupplierContext.Fetch(x => x.SupplierId == itemSupplier.SupplierId && x.CategoryId == itemSupplier.CategoryId && x.Id != itemSupplier.Id && x.IsDelete == false).Any()); } catch (Exception ex) { _errorLog.LogException(ex); throw; } }
public void TestUpdateItemSupplierMakeInActive() { //Arrange ItemSupplier newItemSupplier = new ItemSupplier(); setItemSupplier(newItemSupplier, _itemSuppliers[0]); newItemSupplier.ItemSupplierActive = false; //Act _itemSupplierManager.UpdateItemSupplier(newItemSupplier, _itemSuppliers[0]); //Assert Assert.AreEqual(_itemSupplierManager.RetrieveItemSupplier(_itemSuppliers[0].ItemID, _itemSuppliers[0].SupplierID).ItemSupplierActive, false); }
//[ExpectedException(typeof(ArgumentException))] public void TestDeactivateItemSupplier() { //Arrange This is a known item supplier int itemID = 100002; int supplierID = 100005; ItemSupplier itemSupplier = new ItemSupplier(); //Act _itemSupplierManager.DeactivateItemSupplier(itemID, supplierID); //Assert should throw exception itemSupplier = _itemSupplierManager.RetrieveItemSupplier(itemID, supplierID); Assert.AreEqual(_itemSupplierManager.RetrieveItemSupplier(itemID, supplierID).ItemSupplierActive, false); }
internal static ItemSupplier GetByItemIdAndSupplierId(int itemId, int supId) { ItemSupplier isup = new ItemSupplier(); using (var db = new ADDbContext()) { if (db.ItemSupplier.Where(x => x.item.Id == itemId && x.supplier.Id == supId).Any()) { isup = db.ItemSupplier.Include("item").Include("supplier").Where(x => x.item.Id == itemId && x.supplier.Id == supId).FirstOrDefault(); } } return(isup); }
public int InsertItemSupplier(ItemSupplier itemSupplier) { int listCount = _itemSuppliers.Count; _itemSuppliers.Add(itemSupplier); if (_itemSuppliers.Count == listCount + 1) { return(1); } else { return(0); } }
internal static void SetPriceById(int isId, double newprice) { ItemSupplier itsu = new ItemSupplier(); using (var db = new ADDbContext()) { if (db.ItemSupplier.Where(x => x.Id == isId).Any()) { itsu = db.ItemSupplier.Where(x => x.Id == isId).FirstOrDefault(); } itsu.UnitPrice = newprice; db.SaveChanges(); } }
public async Task <IActionResult> CreateItemSuppliers([FromBody] ItemSupplier itemSupplier) { var item = await this.repository.GetItemSupplier(itemSupplier.ItemId, itemSupplier.SupplierId); if (item != null) { return(BadRequest("Error - This supplier already belongs to this item!")); } var supplierCreated = await this.repository.Add(itemSupplier); if (supplierCreated == null) { return(BadRequest("Error - Item Supplier NOT created")); } return(Ok(itemSupplier)); }
private void DgItemSupplier_MouseDoubleClick(object sender, MouseButtonEventArgs e) { _itemSupplier = (ItemSupplier)dgItemSupplier.SelectedItem; var itemSupplyManager = new frmAddItemSupplierForItem(_item, _itemSupplier, EditMode.Edit); var result = itemSupplyManager.ShowDialog(); if (result == true) { LoadControls(_item); LoadItemSupplierGrid(); } else { return; } }