public Message Update(SR_Category category)
{
Message msg = null;
try
{
msg = CheckExisted(category);
if (msg != null)
return msg;
SR_Category objDB = GetById(category.ID, null);
objDB.Description = category.Description;
objDB.DisplayOrder = category.DisplayOrder;
objDB.IsActive = category.IsActive;
objDB.Name = category.Name;
objDB.ParentId = category.ParentId;
objDB.UpdateDate = DateTime.Now;
objDB.UpdatedBy = category.UpdatedBy;
//dbContext.SR_Categories.InsertOnSubmit(category);
msg = new Message(MessageConstants.I0001, MessageType.Info, "Category \"" + category.Name + "\"", "updated");
dbContext.SubmitChanges();
}
catch
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
private Message CheckExisted(SR_Category category)
{
SR_Category objDB = GetByName(category.Name, category.ParentId, null);
if (objDB != null)
{
if (category.ID == objDB.ID)
return null;
if (objDB.ParentId == null)
return new Message(MessageConstants.E0020, MessageType.Error, "Category \"" + category.Name + "\"", "database");
return new Message(MessageConstants.E0020, MessageType.Error, "Sub-category \"" + category.Name +
"\" of category \"" + objDB.SR_Category1.Name + "\"", "database");
}
//Return null if category does not exist
return null;
}
public Message Insert(SR_Category category)
{
Message msg = null;
try
{
msg = CheckExisted(category);
if (msg != null)
return msg;
category.CreateDate = category.UpdateDate = DateTime.Now;
dbContext.SR_Categories.InsertOnSubmit(category);
msg = new Message(MessageConstants.I0001, MessageType.Info, "Category \"" + category.Name + "\"", "inserted");
dbContext.SubmitChanges();
}
catch
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
