public ReturnData AJAX_StatusToggle(int idManufacturer)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
TBManufacturer _data = GetDetail(db, idManufacturer);
if (_data == null)
{
return(ReturnData.MessageFailed("The requested resource does not exist.", null));
}
_data.Active = !_data.Active;
db.SubmitChanges();
return(ReturnData.MessageSuccess(_data.Name + " has been successfully " + (_data.Active ? "activated" : "deactivated") + ".", 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_Delete(int idManufacturer)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
TBManufacturer _deleteData = GetDetail(db, idManufacturer);
if (_deleteData == null)
{
return(ReturnData.MessageFailed("The requested resource does not exist.", null));
}
string _nameBefore = _deleteData.Name;
_deleteData.Deflag = true;
_deleteData.DateLastUpdate = DateTime.Now;
db.SubmitChanges();
return(ReturnData.MessageSuccess(_deleteData.Name + " 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));
}
}
private int ImportManufacturer(string name)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
var existData = db.TBManufacturers.Where(x => !x.Deflag && x.Name.ToLower() == name.ToLower()).FirstOrDefault();
if (existData == null)
{
TBManufacturer newData = new TBManufacturer();
newData.Name = name;
newData.Active = true;
newData.DateInsert = DateTime.Now;
newData.DateLastUpdate = DateTime.Now;
newData.Deflag = false;
db.TBManufacturers.InsertOnSubmit(newData);
db.SubmitChanges();
return(newData.IDManufacturer);
}
else
{
return(existData.IDManufacturer);
}
}
catch (Exception)
{
throw;
}
}
public ReturnData AJAX_Insert(string baseImage, string fnImage, string name, string email, string phone, string address, string description, bool active)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
if (!ValidationInsert_Name(db, name))
{
return(ReturnData.MessageFailed(name + " already exists.", null));
}
TBManufacturer _newData = new TBManufacturer
{
Logo = WITLibrary.ConvertCustom.GetExtention(fnImage),
Name = name,
Email = email,
Phone = phone,
Address = address,
ShortDescription = OurClass.ShortDescription(description, 250),
Description = description,
Active = active,
Deflag = false,
DateInsert = DateTime.Now,
DateLastUpdate = DateTime.Now
};
db.TBManufacturers.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/manufacturer/" + _newData.IDManufacturer + _newData.Logo));
_newData.Logo = _newData.IDManufacturer + _newData.Logo;
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);
}
}
public ReturnData AJAX_Update(int idManufacturer, string baseImage, string fnImage, string name, string email, string phone, string address, string description, bool active)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
if (!ValidationName_Update(db, idManufacturer, name))
{
return(ReturnData.MessageFailed(name + " already exists.", null));
}
TBManufacturer _updateData = GetDetail(db, idManufacturer);
if (_updateData == null)
{
return(ReturnData.MessageFailed("The requested resource does not exist.", null));
}
string _nameBefore = _updateData.Name;
_updateData.Logo = _updateData.IDManufacturer.ToString() + WITLibrary.ConvertCustom.GetExtention(fnImage);
_updateData.Name = name;
_updateData.Email = email;
_updateData.Phone = phone;
_updateData.Address = address;
_updateData.ShortDescription = OurClass.ShortDescription(description, 250);
_updateData.Description = description;
_updateData.Active = active;
_updateData.DateLastUpdate = DateTime.Now;
if (baseImage != "" && fnImage != "")
{
System.Drawing.Image _image = WITLibrary.ConvertCustom.Base64ToImage(baseImage);
_image.Save(HttpContext.Current.Server.MapPath("/assets/images/manufacturer/" + _updateData.Logo));
}
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));
}
}
