public ReturnData AJAX_Delete(int idAttribute)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
TBAttribute _deleteData = GetDetail(db, idAttribute);
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();
if (_deleteData != null)
{
return(ReturnData.MessageSuccess(_nameBefore + " has been successfully deleted.", null));
}
return(ReturnData.MessageFailed(_nameBefore + " failed to delete.", 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 name, bool isColor)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
if (!ValidationName_Insert(db, name))
{
return(ReturnData.MessageFailed(name + " already exists.", null));
}
TBAttribute newData = new TBAttribute
{
Name = name,
IsColor = isColor,
Deflag = false,
DateInsert = DateTime.Now,
DateLastUpdate = DateTime.Now,
};
db.TBAttributes.InsertOnSubmit(newData);
db.SubmitChanges();
if (newData != null)
{
return(ReturnData.MessageSuccess(name + " has been successfully inserted.", 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));
}
}
public ReturnData AJAX_Update(int idAttribute, string name, bool isColor)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
if (!ValidationName_Update(db, idAttribute, name))
{
return(ReturnData.MessageFailed(name + " already exists.", null));
}
TBAttribute _updateData = GetDetail(db, idAttribute);
if (_updateData == null)
{
return(ReturnData.MessageFailed("The requested resource does not exist.", null));
}
string _nameBefore = _updateData.Name;
_updateData.Name = name;
_updateData.IsColor = isColor;
_updateData.DateLastUpdate = DateTime.Now;
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));
}
}
