void txtclear() { TBProductName.Clear(); TBCategory.Clear(); NUDPrice.Value = 0; NUDAddToStock.Value = 0; }
public ReturnData AJAX_StatusToggle(int idcategory) { try { using (DataClassesDataContext db = new DataClassesDataContext()) { TBCategory _data = GetDetail(db, idcategory); if (_data == null) { return(ReturnData.MessageFailed("The requested resource does not exist.", null)); } _data.Active = !_data.Active; db.SubmitChanges(); Dictionary <string, dynamic> resultData = new Dictionary <string, dynamic>(); resultData.Add("IDCategoryParent", _data.IDCategoryParent); return(ReturnData.MessageSuccess(_data.Name + " has been successfully " + (_data.Active ? "activated" : "deactivated") + ".", resultData)); } } catch (Exception ex) { Class_Log_Error log = new Class_Log_Error(); log.Insert(ex.Message, ex.StackTrace); return(ReturnData.MessageFailed(ex.Message, null)); } }
public ReturnData AJAX_Delete(int idCategory) { try { using (DataClassesDataContext db = new DataClassesDataContext()) { TBCategory _deleteData = GetDetail(db, idCategory); if (_deleteData == null) { return(ReturnData.MessageFailed("The requested resource does not exist.", null)); } string _nameBefore = _deleteData.Name; if (_deleteData.TBProduct_Categories.Where(x => !x.TBProduct.Deflag).AsEnumerable().Count() != 0) { return(ReturnData.MessageFailed(_nameBefore + " failed to deleted, because category already use for some product.", null)); } _deleteData.Deflag = true; _deleteData.DateLastUpdate = DateTime.Now; db.SubmitChanges(); return(ReturnData.MessageSuccess(_nameBefore + " has been successfully deleted.", null)); } } catch (Exception ex) { Class_Log_Error log = new Class_Log_Error(); log.Insert(ex.Message, ex.StackTrace); return(ReturnData.MessageFailed(ex.Message, null)); } }
public ReturnData AJAX_Insert(string baseImage, string fnImage, int?idCategoryParent, string name, string description, bool active) { try { using (DataClassesDataContext db = new DataClassesDataContext()) { if (!ValidationName_Insert(db, name)) { return(ReturnData.MessageFailed(name + " already exists.", null)); } if (idCategoryParent.HasValue && idCategoryParent.Value != 0) { if (Dynamic_GetDetail(db, idCategoryParent.Value) == null) { return(ReturnData.MessageSuccess("The requested resource does not exist.", null)); } } TBCategory _newData = new TBCategory { IDCategoryParent = (idCategoryParent == 0 ? null : idCategoryParent), Image = WITLibrary.ConvertCustom.GetExtention(fnImage), Name = name, Description = description, Active = active, Deflag = false, DateInsert = DateTime.Now, DateLastUpdate = DateTime.Now }; db.TBCategories.InsertOnSubmit(_newData); db.SubmitChanges(); if (_newData != null) { if (baseImage != "" && fnImage != "") { System.Drawing.Image _image = WITLibrary.ConvertCustom.Base64ToImage(baseImage); _image.Save(HttpContext.Current.Server.MapPath("/assets/images/category/" + _newData.IDCategory + _newData.Image)); _newData.Image = _newData.IDCategory + _newData.Image; db.SubmitChanges(); } if (_newData != null) { return(ReturnData.MessageSuccess(name + " has been successfully inserted.", null)); } return(ReturnData.MessageFailed(name + " failed to insert.", null)); } return(ReturnData.MessageFailed(name + " failed to insert.", null)); } } catch (Exception ex) { Class_Log_Error log = new Class_Log_Error(); log.Insert(ex.Message, ex.StackTrace); return(ReturnData.MessageFailed(ex.Message, null)); } }
private int[] ImportCategory(string[] listCategory) { try { DataClassesDataContext db = new DataClassesDataContext(); List <int> listIDCategory = new List <int>(); int?idParent = null; //special case, data pertama itu manufactur if (db.TBManufacturers.Where(x => !x.Deflag && x.Name.ToLower() == listCategory[0].ToLower()).FirstOrDefault() == null) { //insert new manufacturer TBManufacturer _newManufacturer = new TBManufacturer { Name = listCategory[0], DateInsert = DateTime.Now, DateLastUpdate = DateTime.Now }; db.TBManufacturers.InsertOnSubmit(_newManufacturer); db.SubmitChanges(); listIDCategory.Add(_newManufacturer.IDManufacturer); } else { listIDCategory.Add(db.TBManufacturers.Where(x => !x.Deflag && x.Name.ToLower() == listCategory[0].ToLower()).FirstOrDefault().IDManufacturer); } for (int i = 1; i < listCategory.Length - 1; i++) { TBCategory cat = db.TBCategories.Where(x => !x.Deflag && x.Name.ToLower() == listCategory[i].ToLower()).FirstOrDefault(); if (cat == null) { TBCategory _newCategory = new TBCategory { Name = listCategory[i], DateInsert = DateTime.Now, DateLastUpdate = DateTime.Now, IDCategoryParent = idParent }; db.TBCategories.InsertOnSubmit(_newCategory); db.SubmitChanges(); listIDCategory.Add(_newCategory.IDCategory); } else { idParent = cat.IDCategory; listIDCategory.Add(cat.IDCategory); } } return(listIDCategory.ToArray()); } catch (Exception) { return(null); } }
private int[] ImportCategory(string[] listCategory) { try { DataClassesDataContext db = new DataClassesDataContext(); List <int> listIDCategory = new List <int>(); int?idParent = null; for (int i = 0; i < listCategory.Length; i++) { var cekData = db.TBCategories.Where(x => !x.Deflag && x.Name.ToLower() == listCategory[i].ToLower()).FirstOrDefault(); if (cekData == null) { TBCategory _newCategory = new TBCategory { Name = listCategory[i], DateInsert = DateTime.Now, DateLastUpdate = DateTime.Now, IDCategoryParent = idParent, Active = true }; db.TBCategories.InsertOnSubmit(_newCategory); db.SubmitChanges(); listIDCategory.Add(_newCategory.IDCategory); } else { listIDCategory.Add(cekData.IDCategory); } //TBCategory cat = db.TBCategories.Where(x => !x.Deflag && x.Name.ToLower() == listCategory[i].ToLower()).FirstOrDefault(); //if (cat == null) //{ // TBCategory _newCategory = new TBCategory { Name = listCategory[i], DateInsert = DateTime.Now, DateLastUpdate = DateTime.Now, IDCategoryParent = idParent }; // db.TBCategories.InsertOnSubmit(_newCategory); // db.SubmitChanges(); // listIDCategory.Add(_newCategory.IDCategory); //} //else //{ // idParent = cat.IDCategory; // listIDCategory.Add(cat.IDCategory); //} } return(listIDCategory.ToArray()); } catch (Exception) { throw; } }
public ReturnData AJAX_Update(int idcategory, string baseImage, string fnImage, int?idCategoryParent, string name, string description, bool active) { try { using (DataClassesDataContext db = new DataClassesDataContext()) { if (!ValidationName_Update(db, idcategory, name)) { return(ReturnData.MessageFailed(name + " already exists.", null)); } TBCategory _updateData = GetDetail(db, idcategory); if (_updateData == null) { return(ReturnData.MessageFailed("The requested resource does not exist.", null)); } string _nameBefore = _updateData.Name; _updateData.Name = name; _updateData.Description = description; _updateData.Active = active; _updateData.DateLastUpdate = DateTime.Now; if (baseImage != "" && fnImage != "") { _updateData.Image = _updateData.IDCategory.ToString() + WITLibrary.ConvertCustom.GetExtention(fnImage); System.Drawing.Image _image = WITLibrary.ConvertCustom.Base64ToImage(baseImage); _image.Save(HttpContext.Current.Server.MapPath("/assets/images/category/" + _updateData.Image)); } db.SubmitChanges(); if (_updateData != null) { return(ReturnData.MessageSuccess(_nameBefore + " has been successfully updated.", null)); } return(ReturnData.MessageFailed(_nameBefore + " failed to update.", null)); } } catch (Exception ex) { Class_Log_Error log = new Class_Log_Error(); log.Insert(ex.Message, ex.StackTrace); return(ReturnData.MessageFailed(ex.Message, null)); } }
//Button Click code: private void BtnAddInventory_Click(object sender, EventArgs e) { int ct = Program.LstPrd.Count; Product prd = new Product(Product.GetNewID(), TBProductName.Text, TBCategory.Text, NUDPrice.Value, NUDAddStock.Value, NUDPrice.Value * NUDAddStock.Value); Program.LstPrd.Add(prd); if (Program.LstPrd.Count > ct) { MessageBox.Show("Product has been added", "Success", MessageBoxButtons.OK); } else { MessageBox.Show("Product not added", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } TBProductName.Clear(); TBCategory.Clear(); NUDPrice.Value = 0; NUDAddStock.Value = 0; File.AppendAllText(Program.inputfile, System.Environment.NewLine + Convert.ToString(prd.ID) + "," + prd.ProductName + "," + prd.Category + "," + Convert.ToString(prd.Price) + "," + Convert.ToString(prd.AddInStock) + "," + Convert.ToString(prd.CostInStock)); }