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.")); } }