public HttpResponseMessage updateArticleGroup(String id, Models.MstArticleGroup articleGroup)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var articleGroups = from d in db.MstArticleGroups where d.Id == Convert.ToInt32(id) select d;
if (articleGroups.Any())
{
var updateArticleGroup = articleGroups.FirstOrDefault();
updateArticleGroup.ArticleGroup = articleGroup.ArticleGroup;
updateArticleGroup.ArticleTypeId = articleGroup.ArticleTypeId;
updateArticleGroup.AccountId = articleGroup.AccountId;
updateArticleGroup.SalesAccountId = articleGroup.SalesAccountId;
updateArticleGroup.CostAccountId = articleGroup.CostAccountId;
updateArticleGroup.AssetAccountId = articleGroup.AssetAccountId;
updateArticleGroup.ExpenseAccountId = articleGroup.ExpenseAccountId;
updateArticleGroup.IsLocked = articleGroup.IsLocked;
updateArticleGroup.UpdatedById = userId;
updateArticleGroup.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
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);
}
}
