public HttpResponseMessage AddItemCategory(Entities.MstArticleCategory objItemCategory)
{
try
{
var currentUser = from d in db.MstUsers
where d.UserId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var userForms = from d in db.MstUserForms
where d.UserId == currentUser.FirstOrDefault().Id &&
d.SysForm.FormName.Equals("SystemTables")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
Data.MstArticleCategory newItemCategory = new Data.MstArticleCategory
{
Category = objItemCategory.Category,
CategoryImageURL = objItemCategory.CategoryImageURL,
IsLocked = true,
CreatedById = currentUser.FirstOrDefault().Id,
CreatedDateTime = DateTime.Now,
UpdatedById = currentUser.FirstOrDefault().Id,
UpdatedDateTime = DateTime.Now
};
db.MstArticleCategories.InsertOnSubmit(newItemCategory);
db.SubmitChanges();
String newObject = at.GetObjectString(newItemCategory);
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject);
return(Request.CreateResponse(HttpStatusCode.OK, newItemCategory.Id));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add item category."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this system table page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
public HttpResponseMessage UpdateArcticleCategory(Entities.MstArticleCategory objItemCategory, String id)
{
try
{
var currentUser = from d in db.MstUsers
where d.UserId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var userForms = from d in db.MstUserForms
where d.UserId == currentUser.FirstOrDefault().Id &&
d.SysForm.FormName.Equals("SystemTables")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanEdit)
{
var articleCategories = from d in db.MstArticleCategories
where d.Id == Convert.ToInt32(id)
select d;
if (articleCategories.Any())
{
String oldObject = at.GetObjectString(articleCategories.FirstOrDefault());
var updateItemCategory = articleCategories.FirstOrDefault();
updateItemCategory.Category = objItemCategory.Category;
updateItemCategory.CategoryImageURL = objItemCategory.CategoryImageURL;
updateItemCategory.IsLocked = true;
updateItemCategory.UpdatedById = currentUser.FirstOrDefault().Id;
updateItemCategory.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
String newObject = at.GetObjectString(articleCategories.FirstOrDefault());
at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject);
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These article category details are not found in the server."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to edit and update article category."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this system table page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
