public Int32 insertArticleGroup(Models.MstArticleGroup articleGroup)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
Data.MstArticleGroup newArticleGroup = new Data.MstArticleGroup();
newArticleGroup.ArticleGroup = articleGroup.ArticleGroup;
newArticleGroup.ArticleTypeId = articleGroup.ArticleTypeId;
newArticleGroup.AccountId = articleGroup.AccountId;
newArticleGroup.SalesAccountId = articleGroup.SalesAccountId;
newArticleGroup.CostAccountId = articleGroup.CostAccountId;
newArticleGroup.AssetAccountId = articleGroup.AssetAccountId;
newArticleGroup.ExpenseAccountId = articleGroup.ExpenseAccountId;
newArticleGroup.IsLocked = articleGroup.IsLocked;
newArticleGroup.CreatedById = userId;
newArticleGroup.CreatedDateTime = DateTime.Now;
newArticleGroup.UpdatedById = userId;
newArticleGroup.UpdatedDateTime = DateTime.Now;
db.MstArticleGroups.InsertOnSubmit(newArticleGroup);
db.SubmitChanges();
return(newArticleGroup.Id);
}
catch
{
return(0);
}
}
public Int32 insertArticleGroup(Models.MstArticleGroup articleGroup)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
Data.MstArticleGroup newArticleGroup = new Data.MstArticleGroup();
newArticleGroup.ArticleGroup = articleGroup.ArticleGroup;
newArticleGroup.ArticleTypeId = articleGroup.ArticleTypeId;
newArticleGroup.AccountId = articleGroup.AccountId;
newArticleGroup.SalesAccountId = articleGroup.SalesAccountId;
newArticleGroup.CostAccountId = articleGroup.CostAccountId;
newArticleGroup.AssetAccountId = articleGroup.AssetAccountId;
newArticleGroup.ExpenseAccountId = articleGroup.ExpenseAccountId;
newArticleGroup.IsLocked = articleGroup.IsLocked;
newArticleGroup.CreatedById = userId;
newArticleGroup.CreatedDateTime = DateTime.Now;
newArticleGroup.UpdatedById = userId;
newArticleGroup.UpdatedDateTime = DateTime.Now;
db.MstArticleGroups.InsertOnSubmit(newArticleGroup);
db.SubmitChanges();
return newArticleGroup.Id;
}
catch
{
return 0;
}
}
public HttpResponseMessage AddArticleGroup(Entities.MstArticleGroup objArticleGroup)
{
try
{
var currentUser = from d in db.MstUsers
where d.UserId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var currentUserId = currentUser.FirstOrDefault().Id;
var userForms = from d in db.MstUserForms
where d.UserId == currentUserId &&
d.SysForm.FormName.Equals("SystemTables")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
var accounts = from d in db.MstAccounts.OrderBy(d => d.Account)
where d.IsLocked == true
select d;
if (accounts.Any())
{
Data.MstArticleGroup newArticleGroup = new Data.MstArticleGroup
{
ArticleGroup = objArticleGroup.ArticleGroup,
ArticleTypeId = objArticleGroup.ArticleTypeId,
AccountId = objArticleGroup.AccountId,
SalesAccountId = objArticleGroup.SalesAccountId,
CostAccountId = objArticleGroup.CostAccountId,
AssetAccountId = objArticleGroup.AssetAccountId,
ExpenseAccountId = objArticleGroup.ExpenseAccountId,
IsLocked = true,
CreatedById = currentUserId,
CreatedDateTime = DateTime.Now,
UpdatedById = currentUserId,
UpdatedDateTime = DateTime.Now
};
db.MstArticleGroups.InsertOnSubmit(newArticleGroup);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK, newArticleGroup.Id));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "No account found. Please setup at least one account for article groups."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add article group."));
}
}
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."));
}
}
