public ActionResult Edit(ModelProduct product, string sID) { ModelProduct cItemToEdit = cRepositoryProducts.Find(sID); if (cItemToEdit == null) { return(HttpNotFound()); } else { if (!ModelState.IsValid) { return(View(cItemToEdit)); } cItemToEdit.Category = product.Category; cItemToEdit.Description = product.Description; cItemToEdit.Image = product.Image; cItemToEdit.Name = product.Name; cItemToEdit.Price = product.Price; cRepositoryProducts.Commit(); return(RedirectToAction("Index")); } }
public DataTable CategoryComboList(ModelProduct modelProduct) { string connection = @"Server = AHO-BATIJA; DataBase = SmallBusinessManagementSystem; Integrated Security = True"; SqlConnection sqlConnection = new SqlConnection(connection); string query = @"SELECT DISTINCT Name FROM Products WHERE CategoryName = '" + modelProduct.CategoryName + "'"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand); DataTable dataTable = new DataTable(); sqlDataAdapter.Fill(dataTable); sqlConnection.Close(); return(dataTable); //List<ModelProduct> productComboList = new List<ModelProduct>(); //SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); //while (sqlDataReader.Read()) //{ // modelProduct.Name = sqlDataReader["Name"].ToString(); // productComboList.Add(modelProduct); //} //sqlConnection.Close(); //return productComboList; }
private void ProductComboBox_SelectedIndexChanged(object sender, EventArgs e) { try { ProductManager _productManager = new ProductManager(); ModelProduct _modelProduct = new ModelProduct(); _modelProduct.Name = productComboBox.Text; _productManager.ProductComboList(_modelProduct); codeTextBox.Text = _modelProduct.Name + " ( " + _modelProduct.Code + " )"; //int qty = 0; //int availableQty = 0; //for (int i = 0; i < _productManager.ProductComboList(_modelProduct).Count; i++) //{ // qty = i + _modelProduct.Constant; // availableQty = qty + 1; //} //availAbleQtyTextBox.Text = availableQty.ToString(); } catch (Exception exception) { MessageBox.Show(exception.Message); } }
public FrmStokYonetimi() { InitializeComponent(); modelProduct = new ModelProduct(); Init(); }
private void CategoryComboBox_SelectedIndexChanged(object sender, EventArgs e) { ProductManager _productManager = new ProductManager(); ModelProduct _modelProduct = new ModelProduct(); _modelProduct.CategoryName = categoryComboBox.Text; productComboBox.DataSource = _productManager.CategoryComboList(_modelProduct); }
/// <summary> /// To the model. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> internal static ModelProduct ToModel(this EntityProduct entity) { var model = new ModelProduct(); model.Id = entity.Id; model.Name = entity.Name; model.Description = entity.Description; model.Price = entity.Price; return(model); }
/// <summary> /// To the entity. /// </summary> /// <param name="model">The model.</param> /// <returns></returns> internal static EntityProduct ToEntity(this ModelProduct model) { var entity = new EntityProduct(); entity.Id = model.Id; entity.Name = model.Name; entity.Description = model.Description; entity.Price = model.Price; return(entity); }
public ActionResult Delete(string sID) { ModelProduct cItemToDelete = cRepositoryProducts.Find(sID); if (cItemToDelete == null) { return(HttpNotFound()); } else { return(View(cItemToDelete)); } }
private void gridViewAvailableStock_CellClick(object sender, DataGridViewCellEventArgs e) { try { bool Status = false; string StatusDetails = null; if (e.RowIndex >= 0) { DataGridViewRow Row = this.gridViewAvailableStock.Rows[e.RowIndex]; labelBarcode.Text = Row.Cells["Barcode"].Value.ToString(); labelCategory.Text = Row.Cells["CategoryName"].Value.ToString(); labelType.Text = Row.Cells["ProductType"].Value.ToString(); labelBrand.Text = Row.Cells["ProductBrand"].Value.ToString(); labelSize.Text = Row.Cells["ProductSize"].Value.ToString(); labelColor.Text = Row.Cells["ProductColor"].Value.ToString(); labelDate.Text = Row.Cells["PurchaseDate"].Value.ToString(); labelAvailableStock.Text = Row.Cells["AvailableQty"].Value.ToString(); labelCousumeStock.Text = Row.Cells["SoldQty"].Value.ToString(); ModelProduct mp = new ModelProduct(); mp.ProductID = Convert.ToInt32(Row.Cells["ProductID"].Value.ToString()); DataTable ddt = MainClass.POS.usp_GetProduct_withImage(mp, out Status, out StatusDetails); if (Status) { string pImage = ddt.Rows[0]["ProductPicture"].ToString(); if (pImage == "ImageClass.GetImageFromBase64(Row.Cells[ProductImage].Value.ToString())' threw an exception of type 'System.FormatException" || pImage == "" || pImage == "NoImage") { labelAfterHiddenImage.Visible = true; labelAfterHiddenImage.Text = "NoImage"; pictureBoxAvailable.Visible = false; } else { pictureBoxAvailable.Visible = true; labelAfterHiddenImage.Visible = false; pictureBoxAvailable.Image = ImageClass.GetImageFromBase64(ddt.Rows[0]["ProductPicture"].ToString()); } udmGetQtySumFromGridViewDown(); } else { MessageBox.Show(StatusDetails, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } catch (Exception ex) { JIMessageBox.ErrorMessage(ex.Message); } }
public ActionResult Create(ModelProduct product) { if (!ModelState.IsValid) { return(View(product)); } else { cRepositoryProducts.Insert(product); cRepositoryProducts.Commit(); return(RedirectToAction("Index")); } }
public List <ModelProduct> UpdateProduct(ModelProduct modelProduct) { string connection = @"Server = AHO-BATIJA; DataBase = SmallBusinessManagementSystem; Integrated Security = True"; SqlConnection sqlConnection = new SqlConnection(connection); string query = @"UPDATE Products SET CategoryName='" + modelProduct.CategoryName + "', Code='" + modelProduct.Code + "', Name='" + modelProduct.Name + "', ReOrder=" + modelProduct.ReOrder + ", Description='" + modelProduct.Description + "' WHERE Id = " + modelProduct.Id + ""; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); List <ModelProduct> modelProductList = new List <ModelProduct>(); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); modelProductList.Add(modelProduct); sqlConnection.Close(); return(modelProductList); }
public ActionResult ConfirmDelete(string sID) { ModelProduct cItemToDelete = cRepositoryProducts.Find(sID); if (cItemToDelete == null) { return(HttpNotFound()); } else { cRepositoryProducts.Delete(sID); cRepositoryProducts.Commit(); return(RedirectToAction("Index")); } }
/// <summary> /// A simple function that takes a string and does a ToUpper /// </summary> /// <param name="input"></param> /// <param name="context"></param> /// <returns></returns> public Response FunctionHandler(Request input, ILambdaContext context) { var dba = new DBAccess(); if (input.Body.IsPing) { return new Response { StatusCode = 200, Message = dba.Test() } } ; try { //validate require role if (!input.SourceUser.HasRole("Model")) { return new Response { StatusCode = 401, Message = "Access denied, requires Model role" } } ; var modelProduct = new ModelProduct { ModelId = input.Body.ModelId, ProductId = input.Body.ProductId }; modelProduct.Delete(dba.Connection); var r = new Response { StatusCode = 200, Message = "ok" }; return(r); } catch (Exception e) { var r = new Response(); r.SetError(400, e); return(r); } } }
private void udmKeyPress() { try { bool Status = false; string StatusDetails = null; // Getting Index of Current Row int index = gridViewAvailableStock.CurrentRow.Index; DataGridViewRow Row = this.gridViewAvailableStock.Rows[index]; labelBarcode.Text = Row.Cells["Barcode"].Value.ToString(); labelCategory.Text = Row.Cells["CategoryName"].Value.ToString(); labelType.Text = Row.Cells["ProductType"].Value.ToString(); labelBrand.Text = Row.Cells["ProductBrand"].Value.ToString(); labelSize.Text = Row.Cells["ProductSize"].Value.ToString(); labelColor.Text = Row.Cells["ProductColor"].Value.ToString(); labelDate.Text = Row.Cells["PurchaseDate"].Value.ToString(); labelAvailableStock.Text = Row.Cells["AvailableQty"].Value.ToString(); labelCousumeStock.Text = Row.Cells["SoldQty"].Value.ToString(); ModelProduct mp = new ModelProduct(); mp.ProductID = Convert.ToInt32(Row.Cells["ProductID"].Value.ToString()); DataTable ddt = MainClass.POS.usp_GetProduct_withImage(mp, out Status, out StatusDetails); if (Status) { string pImage = ddt.Rows[0]["ProductPicture"].ToString(); if (pImage == "ImageClass.GetImageFromBase64(Row.Cells[ProductImage].Value.ToString())' threw an exception of type 'System.FormatException" || pImage == "" || pImage == "NoImage") { labelAfterHiddenImage.Visible = true; labelAfterHiddenImage.Text = "NoImage"; pictureBoxAvailable.Visible = false; } else { pictureBoxAvailable.Visible = true; labelAfterHiddenImage.Visible = false; pictureBoxAvailable.Image = ImageClass.GetImageFromBase64(ddt.Rows[0]["ProductPicture"].ToString()); } udmGetQtySumFromGridViewDown(); } } catch (Exception ex) { JIMessageBox.ErrorMessage(ex.Message); } }
private void btnKaydet_Click(object sender, EventArgs e) { var modelProduct = new ModelProduct(); string message = string.Empty; // modelProduct.TextBoslukKontrol_DevExpress(t,dxErrorProvider1,"Stok adı alanı boş olmaz!"); if (!dxValidationProvider1.Validate()) { return; } int pid = 0; var product = new PRODUCT { BRAND_ID = _brand.BRAND_ID, PRODUCT_NAME = txtUrunAd.Text, PRODUCT_CATID = _urunKategori.PRODUCT_CATID, SHORT_CODE_ID = _model.MODEL_ID, PRODUCT_CODE = "123456", PRODUCT_CODE_2 = "1234567", PRODUCT_STATUS = true }; var productUnit = new PRODUCT_UNIT { ADD_UNIT = _birim.UNIT, MAIN_UNIT = _birim.UNIT, MAIN_UNIT_ID = _birim.UNIT_ID, MULTIPLIER = 1, IS_MAIN = true, PRODUCT_UNIT_STATUS = true }; var priceStandart = new PRICE_STANDART { PRICE = double.Parse(txtStandartSatis.Text), PRICE_KDV = double.Parse(txtStandartSatis.Text), PRICESTANDART_STATUS = true }; modelProduct.AddProduct(product, productUnit, new STOCKS(), priceStandart); toastNotificationsManager1.ShowNotification(toastNotificationsManager1.Notifications[1]); this.DialogResult = DialogResult.OK; this.Close(); }
public ActionResult Edit(string sID) { ModelProduct cItem = cRepositoryProducts.Find(sID); if (cItem == null) { return(HttpNotFound()); } else { ViewModelProductManager viewModel = new ViewModelProductManager(); viewModel.Product = cItem; viewModel.ProductCategories = cRepositoryCategories.Collection(); return(View(viewModel)); } }
public bool SaveProduct(ModelProduct modelProduct) { bool isSaveProduct = false; string connection = @"Server = AHO-BATIJA; DataBase = SmallBusinessManagementSystem; Integrated Security = True"; SqlConnection sqlConnection = new SqlConnection(connection); string query = @"INSERT INTO Products(CategoryName, Code, Name, ReOrder, Description)VALUES('" + modelProduct.CategoryName + "','" + modelProduct.Code + "' , '" + modelProduct.Name + "', " + modelProduct.ReOrder + ",'" + modelProduct.Description + "')"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); int isExecute = sqlCommand.ExecuteNonQuery(); if (isExecute > 0) { isSaveProduct = true; } sqlConnection.Close(); return(isSaveProduct); }
public bool IsProductCodeExits(ModelProduct modelProduct) { bool isCodeExits = false; string connection = @"Server = AHO-BATIJA; DataBase = SmallBusinessManagementSystem; Integrated Security = True"; SqlConnection sqlConnection = new SqlConnection(connection); string query = @"SELECT * FROM Products WHERE Code = '" + modelProduct.Code + "'"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand); DataTable dataTable = new DataTable(); sqlDataAdapter.Fill(dataTable); if (dataTable.Rows.Count > 0) { isCodeExits = true; } sqlConnection.Close(); return(isCodeExits); }
public List <ModelProduct> ProductComboList(ModelProduct modelProduct) { string connection = @"Server = AHO-BATIJA; DataBase = SmallBusinessManagementSystem; Integrated Security = True"; SqlConnection sqlConnection = new SqlConnection(connection); string query = @"SELECT * FROM Products WHERE Name = '" + modelProduct.Name + "'"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); List <ModelProduct> productComboList = new List <ModelProduct>(); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { modelProduct.Code = sqlDataReader["Code"].ToString(); modelProduct.Name = sqlDataReader["Name"].ToString(); productComboList.Add(modelProduct); } sqlConnection.Close(); return(productComboList); }
// PUT: api/Products/5 public IHttpActionResult Put(int id, ModelProduct product) { if (ModelState.IsValid) { try { var productToUpdate = Mapper.Map <ModelProduct, Product>(product); _productApp.Update(productToUpdate); return(Ok(productToUpdate)); } catch { return(InternalServerError()); } } else { return(BadRequest(ModelState)); } }
public bool SaveProduct(ModelProduct modelProduct) { return(_productRepository.SaveProduct(modelProduct)); }
public void Add(ModelProduct product) { _repository.Add(product); }
public List <ModelProduct> ProductComboList(ModelProduct modelProduct) { return(_productRepository.ProductComboList(modelProduct)); }
public DataTable CategoryComboList(ModelProduct modelProduct) { return(_productRepository.CategoryComboList(modelProduct)); }
public bool IsProductCodeExits(ModelProduct modelProduct) { return(_productRepository.IsProductCodeExits(modelProduct)); }
public List <ModelProduct> UpdateProduct(ModelProduct modelProduct) { return(_productRepository.UpdateProduct(modelProduct)); }
public ItemForm() { InitializeComponent(); m_model = new ModelProduct(); }
/// <summary> /// A simple function that takes a string and does a ToUpper /// </summary> /// <param name="input"></param> /// <param name="context"></param> /// <returns></returns> public Response FunctionHandler(Request input, ILambdaContext context) { var dba = new DBAccess(); if (input.Body.IsPing) { return new Response { StatusCode = 200, Message = dba.Test() } } ; try { //validate require role if (!input.SourceUser.HasRole("Model")) { return new Response { StatusCode = 401, Message = "Access denied, requires Model role" } } ; //get user var user = User.LoadBySourceUser(input.SourceUser, dba.Connection); if (user == null) { return new Response { StatusCode = 404, Message = "User is not registered, hence cannot be a model" } } ; //get model var model = Model.LoadByUser(user.Id, false, dba.Connection); if (model == null) { return new Response { StatusCode = 404, Message = "User is not registered as a model, so cannot create a live session" } } ; //check that the user is also the model if (model.Id != input.Body.ModelId) { return new Response { StatusCode = 404, Message = "This model does not match the model id provided in the request" } } ; //create product var modelProduct = new ModelProduct { ModelId = model.Id, ProductId = input.Body.ProductId }; modelProduct.Save(dba.Connection); var r = new Response { StatusCode = 200, Message = "ok" }; return(r); } catch (Exception e) { var r = new Response(); r.SetError(400, e); return(r); } } }
public ItemChartForm() { InitializeComponent(); m_model = new ModelProduct(); m_report_model = new ModelReport(); }