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