public HttpResponseMessage UpdateArticle(Entities.MstArticle objArticle, String id) { try { var article = from d in db.MstArticles where d.Id == Convert.ToInt32(id) select d; if (article.Any()) { var updateArticle = article.FirstOrDefault(); updateArticle.Article = objArticle.Article; updateArticle.Category = objArticle.Category; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Successfully Updated!")); } else { return(Request.CreateResponse(HttpStatusCode.OK, "Data Not Exist!")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong!")); } }
public HttpResponseMessage AddArticle(Entities.MstArticle objArticle) { try { Data.MstArticle newArticle = new Data.MstArticle { ArticleCode = objArticle.ArticleCode, ManualArticleCode = objArticle.ManualArticleCode, Article = objArticle.Article, Category = objArticle.Category, ArticleTypeId = objArticle.ArticleTypeId, ArticleGroupId = objArticle.ArticleGroupId, AccountId = objArticle.AccountId, SalesAccountId = objArticle.SalesAccountId, CostAccountId = objArticle.CostAccountId, AssetAccountId = objArticle.AssetAccountId, ExpenseAccountId = objArticle.ExpenseAccountId, UnitId = objArticle.UnitId, OutputTaxId = objArticle.OutputTaxId, InputTaxId = objArticle.InputTaxId, WTaxTypeId = objArticle.WTaxTypeId, Price = objArticle.Price, Cost = objArticle.Cost, IsInventory = objArticle.IsInventory, Particulars = objArticle.Particulars, Address = objArticle.Address, TermId = objArticle.TermId, ContactNumber = objArticle.ContactNumber, ContactPerson = objArticle.ContactPerson, EmailAddress = objArticle.EmailAddress, TaxNumber = objArticle.TaxNumber, CreditLimit = objArticle.CreditLimit, DateAcquired = Convert.ToDateTime(objArticle.DateAcquired), UsefulLife = objArticle.UsefulLife, SalvageValue = objArticle.SalvageValue, ManualArticleOldCode = objArticle.ManualArticleOldCode, Kitting = objArticle.Kitting, IsLocked = objArticle.IsLocked, CreatedById = objArticle.CreatedById, CreatedDateTime = Convert.ToDateTime(objArticle.CreatedDateTime), UpdatedById = objArticle.UpdatedById, UpdatedDateTime = Convert.ToDateTime(objArticle.UpdatedDateTime), }; db.MstArticles.InsertOnSubmit(newArticle); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Successfully Added!")); } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong!")); } }
public HttpResponseMessage LockItem(Entities.MstArticle objItem, String id) { 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("ItemDetail") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanLock) { var item = from d in db.MstArticles where d.Id == Convert.ToInt32(id) && d.ArticleTypeId == 1 select d; if (item.Any()) { if (!item.FirstOrDefault().IsLocked) { String oldObject = auditTrail.GetObjectString(item.FirstOrDefault()); if (item.FirstOrDefault().MstArticleUnits.Any()) { if (item.FirstOrDefault().MstArticlePrices.Any()) { var itemByManualCode = from d in db.MstArticles where d.ArticleTypeId == 1 && d.ManualArticleCode.Equals(objItem.ManualArticleCode) && d.IsLocked == true select d; if (!itemByManualCode.Any()) { var lockItem = item.FirstOrDefault(); lockItem.ManualArticleCode = objItem.ManualArticleCode; lockItem.Article = objItem.Article; lockItem.ArticleGroupId = objItem.ArticleGroupId; lockItem.AccountId = objItem.AccountId; lockItem.SalesAccountId = objItem.SalesAccountId; lockItem.CostAccountId = objItem.CostAccountId; lockItem.AssetAccountId = objItem.AssetAccountId; lockItem.ExpenseAccountId = objItem.ExpenseAccountId; lockItem.Category = objItem.Category; lockItem.UnitId = objItem.UnitId; lockItem.Price = objItem.Price; lockItem.Particulars = objItem.Particulars; lockItem.InputTaxId = objItem.InputTaxId; lockItem.OutputTaxId = objItem.OutputTaxId; lockItem.WTaxTypeId = objItem.WTaxTypeId; lockItem.IsInventory = objItem.IsInventory; lockItem.IsConsignment = objItem.IsConsignment; lockItem.ConsignmentCostPercentage = objItem.ConsignmentCostPercentage; lockItem.ConsignmentCostValue = objItem.ConsignmentCostValue; lockItem.ManualArticleOldCode = objItem.ManualArticleOldCode; lockItem.Cost = objItem.Cost; lockItem.Kitting = objItem.Kitting; lockItem.DefaultSupplierId = objItem.DefaultSupplierId; lockItem.DateAcquired = Convert.ToDateTime(objItem.DateAcquired); lockItem.UsefulLife = objItem.UsefulLife; lockItem.SalvageValue = objItem.SalvageValue; lockItem.IsLocked = true; lockItem.UpdatedById = currentUserId; lockItem.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); String newObject = auditTrail.GetObjectString(item.FirstOrDefault()); auditTrail.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Manual Code is already taken.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No Price Found. Please provide at least one price.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No Unit Conversion Found. Please provide at least one unit conversion.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Locking Error. These item details are already locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These item details are not found in the server.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to lock item.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this item detail 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 SaveItem(Entities.MstArticle objItem, String id) { 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 item = from d in db.MstArticles where d.Id == Convert.ToInt32(id) && d.ArticleTypeId == 1 select d; if (item.Any()) { if (!item.FirstOrDefault().IsLocked) { String oldObject = auditTrail.GetObjectString(item.FirstOrDefault()); var saveItem = item.FirstOrDefault(); saveItem.ManualArticleCode = objItem.ManualArticleCode; saveItem.Article = objItem.Article; saveItem.ArticleGroupId = objItem.ArticleGroupId; saveItem.AccountId = objItem.AccountId; saveItem.SalesAccountId = objItem.SalesAccountId; saveItem.CostAccountId = objItem.CostAccountId; saveItem.AssetAccountId = objItem.AssetAccountId; saveItem.ExpenseAccountId = objItem.ExpenseAccountId; saveItem.Category = objItem.Category; saveItem.UnitId = objItem.UnitId; saveItem.Price = objItem.Price; saveItem.Particulars = objItem.Particulars; saveItem.InputTaxId = objItem.InputTaxId; saveItem.OutputTaxId = objItem.OutputTaxId; saveItem.WTaxTypeId = objItem.WTaxTypeId; saveItem.IsInventory = objItem.IsInventory; saveItem.IsConsignment = objItem.IsConsignment; saveItem.ConsignmentCostPercentage = objItem.ConsignmentCostPercentage; saveItem.ConsignmentCostValue = objItem.ConsignmentCostValue; saveItem.ManualArticleOldCode = objItem.ManualArticleOldCode; saveItem.Cost = objItem.Cost; saveItem.Kitting = objItem.Kitting; saveItem.DefaultSupplierId = objItem.DefaultSupplierId; saveItem.DateAcquired = Convert.ToDateTime(objItem.DateAcquired); saveItem.UsefulLife = objItem.UsefulLife; saveItem.SalvageValue = objItem.SalvageValue; saveItem.UpdatedById = currentUserId; saveItem.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); String newObject = auditTrail.GetObjectString(item.FirstOrDefault()); auditTrail.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Saving Error. These item details are already locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These item details are not found in the server.")); } } 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 UpdateBank(Entities.MstArticle objBank, String id) { 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("BankList") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanEdit) { var bank = from d in db.MstArticles where d.Id == Convert.ToInt32(id) && d.ArticleTypeId == 5 select d; if (bank.Any()) { var bankByManualCode = from d in db.MstArticles where d.Id != Convert.ToInt32(id) && d.ArticleTypeId == 5 && d.ManualArticleCode.Equals(objBank.ManualArticleCode) select d; if (!bankByManualCode.Any()) { String oldObject = at.GetObjectString(bank.FirstOrDefault()); var lockBank = bank.FirstOrDefault(); lockBank.ManualArticleCode = objBank.ManualArticleCode; lockBank.Article = objBank.Article; lockBank.ArticleGroupId = objBank.ArticleGroupId; lockBank.AccountId = objBank.AccountId; lockBank.SalesAccountId = objBank.SalesAccountId; lockBank.CostAccountId = objBank.CostAccountId; lockBank.AssetAccountId = objBank.AssetAccountId; lockBank.ExpenseAccountId = objBank.ExpenseAccountId; lockBank.Address = objBank.Address; lockBank.ContactNumber = objBank.ContactNumber; lockBank.ContactPerson = objBank.ContactPerson; lockBank.IsLocked = true; lockBank.UpdatedById = currentUserId; lockBank.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); String newObject = at.GetObjectString(bank.FirstOrDefault()); at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Manual Code is already taken.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These bank details are not found in the server.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to edit and update bank.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this bank detail 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 AddBank(Entities.MstArticle objBank) { 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("BankList") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanAdd) { var defaultBankCode = "0000000001"; var lastBank = from d in db.MstArticles.OrderByDescending(d => d.Id) where d.ArticleTypeId == 5 select d; if (lastBank.Any()) { var bankCode = Convert.ToInt32(lastBank.FirstOrDefault().ArticleCode) + 0000000001; defaultBankCode = FillLeadingZeroes(bankCode, 10); } var articleGroups = from d in db.MstArticleGroups where d.Id == objBank.ArticleGroupId && d.ArticleTypeId == 5 select d; if (articleGroups.Any()) { var units = from d in db.MstUnits select d; if (units.Any()) { var taxTypes = from d in db.MstTaxTypes select d; if (taxTypes.Any()) { var terms = from d in db.MstTerms select d; if (terms.Any()) { var bankByManualCode = from d in db.MstArticles where d.ArticleTypeId == 5 && d.ManualArticleCode.Equals(objBank.ManualArticleCode) select d; if (!bankByManualCode.Any()) { Data.MstArticle newBank = new Data.MstArticle { ArticleCode = defaultBankCode, ManualArticleCode = objBank.ManualArticleCode, Article = objBank.Article, Category = "NA", ArticleTypeId = 5, ArticleGroupId = articleGroups.FirstOrDefault().Id, AccountId = articleGroups.FirstOrDefault().AccountId, SalesAccountId = articleGroups.FirstOrDefault().SalesAccountId, CostAccountId = articleGroups.FirstOrDefault().CostAccountId, AssetAccountId = articleGroups.FirstOrDefault().AssetAccountId, ExpenseAccountId = articleGroups.FirstOrDefault().ExpenseAccountId, UnitId = units.FirstOrDefault().Id, OutputTaxId = db.MstTaxTypes.FirstOrDefault().Id, InputTaxId = db.MstTaxTypes.FirstOrDefault().Id, WTaxTypeId = db.MstTaxTypes.FirstOrDefault().Id, Price = 0, Cost = 0, IsInventory = false, Particulars = "NA", Address = objBank.Address, TermId = terms.FirstOrDefault().Id, ContactNumber = objBank.ContactNumber, ContactPerson = objBank.ContactPerson, EmailAddress = "NA", TaxNumber = "NA", CreditLimit = 0, DateAcquired = DateTime.Now, UsefulLife = 0, SalvageValue = 0, ManualArticleOldCode = "NA", Kitting = 0, DefaultSupplierId = null, StockLevelQuantity = 0, ReorderQuantity = 0, IsLocked = true, CreatedById = currentUserId, CreatedDateTime = DateTime.Now, UpdatedById = currentUserId, UpdatedDateTime = DateTime.Now }; db.MstArticles.InsertOnSubmit(newBank); db.SubmitChanges(); String newObject = at.GetObjectString(newBank); at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject); return(Request.CreateResponse(HttpStatusCode.OK, newBank.Id)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Manual Code is already taken.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No term found. Please setup more terms for all master tables.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No tax type found. Please setup more tax types for all master tables.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No unit found. Please setup more units for all master tables.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No article group found. Please setup at least one article group for banks.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add bank.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this bank 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 LockSupplier(Entities.MstArticle objSupplier, String id) { 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("SupplierDetail") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanLock) { var supplier = from d in db.MstArticles where d.Id == Convert.ToInt32(id) && d.ArticleTypeId == 3 select d; if (supplier.Any()) { if (!supplier.FirstOrDefault().IsLocked) { var lockSupplier = supplier.FirstOrDefault(); lockSupplier.ManualArticleCode = objSupplier.ManualArticleCode; lockSupplier.Article = objSupplier.Article; lockSupplier.ArticleGroupId = objSupplier.ArticleGroupId; lockSupplier.AccountId = objSupplier.AccountId; lockSupplier.SalesAccountId = objSupplier.SalesAccountId; lockSupplier.CostAccountId = objSupplier.CostAccountId; lockSupplier.AssetAccountId = objSupplier.AssetAccountId; lockSupplier.ExpenseAccountId = objSupplier.ExpenseAccountId; lockSupplier.TermId = objSupplier.TermId; lockSupplier.Address = objSupplier.Address; lockSupplier.ContactNumber = objSupplier.ContactNumber; lockSupplier.ContactPerson = objSupplier.ContactPerson; lockSupplier.TaxNumber = objSupplier.TaxNumber; lockSupplier.Particulars = objSupplier.Particulars; lockSupplier.EmailAddress = objSupplier.EmailAddress; lockSupplier.IsLocked = true; lockSupplier.UpdatedById = currentUserId; lockSupplier.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Locking Error. These supplier details are already locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These supplier details are not found in the server.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to lock supplier.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this supplier detail 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 LockSupplier(Entities.MstArticle objSupplier, String id) { 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("SupplierDetail") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanLock) { var supplier = from d in db.MstArticles where d.Id == Convert.ToInt32(id) && d.ArticleTypeId == 3 select d; if (supplier.Any()) { if (!supplier.FirstOrDefault().IsLocked) { String oldObject = auditTrail.GetObjectString(supplier.FirstOrDefault()); var supplierByManualCode = from d in db.MstArticles where d.ArticleTypeId == 3 && d.ManualArticleCode.Equals(objSupplier.ManualArticleCode) && d.IsLocked == true select d; if (!supplierByManualCode.Any()) { var lockSupplier = supplier.FirstOrDefault(); lockSupplier.ManualArticleCode = objSupplier.ManualArticleCode; lockSupplier.Article = objSupplier.Article; lockSupplier.ArticleGroupId = objSupplier.ArticleGroupId; lockSupplier.AccountId = objSupplier.AccountId; lockSupplier.SalesAccountId = objSupplier.SalesAccountId; lockSupplier.CostAccountId = objSupplier.CostAccountId; lockSupplier.AssetAccountId = objSupplier.AssetAccountId; lockSupplier.ExpenseAccountId = objSupplier.ExpenseAccountId; lockSupplier.TermId = objSupplier.TermId; lockSupplier.Address = objSupplier.Address; lockSupplier.ContactNumber = objSupplier.ContactNumber; lockSupplier.ContactPerson = objSupplier.ContactPerson; lockSupplier.TaxNumber = objSupplier.TaxNumber; lockSupplier.Particulars = objSupplier.Particulars; lockSupplier.EmailAddress = objSupplier.EmailAddress; lockSupplier.CreditLimit = objSupplier.CreditLimit; lockSupplier.IsLocked = true; lockSupplier.UpdatedById = currentUserId; lockSupplier.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); String newObject = auditTrail.GetObjectString(supplier.FirstOrDefault()); auditTrail.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Manual Code is already taken.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Already locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "This supplier detail is no longer exist.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "No rights.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "No rights.")); } } 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 UpdateOtherArticle(Entities.MstArticle objOtherArticle, String id) { 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().CanEdit) { var otherArticle = from d in db.MstArticles where d.Id == Convert.ToInt32(id) && d.ArticleTypeId == 6 select d; if (otherArticle.Any()) { var lockOtherArticle = otherArticle.FirstOrDefault(); lockOtherArticle.Article = objOtherArticle.Article; lockOtherArticle.ArticleGroupId = objOtherArticle.ArticleGroupId; lockOtherArticle.AccountId = objOtherArticle.AccountId; lockOtherArticle.SalesAccountId = objOtherArticle.SalesAccountId; lockOtherArticle.CostAccountId = objOtherArticle.CostAccountId; lockOtherArticle.AssetAccountId = objOtherArticle.AssetAccountId; lockOtherArticle.ExpenseAccountId = objOtherArticle.ExpenseAccountId; lockOtherArticle.Address = objOtherArticle.Address; lockOtherArticle.ContactNumber = objOtherArticle.ContactNumber; lockOtherArticle.ContactPerson = objOtherArticle.ContactPerson; lockOtherArticle.IsLocked = true; lockOtherArticle.UpdatedById = currentUserId; lockOtherArticle.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These other article details are not found in the server.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to edit and update other article.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this system tables 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 AddOtherArticle(Entities.MstArticle objOtherArticle) { 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 defaultOtherArticleCode = "0000000001"; var lastOtherArticle = from d in db.MstArticles.OrderByDescending(d => d.Id) where d.ArticleTypeId == 6 select d; if (lastOtherArticle.Any()) { var otherArticleCode = Convert.ToInt32(lastOtherArticle.FirstOrDefault().ArticleCode) + 0000000001; defaultOtherArticleCode = FillLeadingZeroes(otherArticleCode, 10); } var articleGroups = from d in db.MstArticleGroups where d.Id == objOtherArticle.ArticleGroupId && d.ArticleTypeId == 6 select d; if (articleGroups.Any()) { var units = from d in db.MstUnits select d; if (units.Any()) { var taxTypes = from d in db.MstTaxTypes select d; if (taxTypes.Any()) { var terms = from d in db.MstTerms select d; if (terms.Any()) { Data.MstArticle newOtherArticle = new Data.MstArticle { ArticleCode = defaultOtherArticleCode, ManualArticleCode = "NA", Article = objOtherArticle.Article, Category = "NA", ArticleTypeId = 6, ArticleGroupId = articleGroups.FirstOrDefault().Id, AccountId = articleGroups.FirstOrDefault().AccountId, SalesAccountId = articleGroups.FirstOrDefault().SalesAccountId, CostAccountId = articleGroups.FirstOrDefault().CostAccountId, AssetAccountId = articleGroups.FirstOrDefault().AssetAccountId, ExpenseAccountId = articleGroups.FirstOrDefault().ExpenseAccountId, UnitId = units.FirstOrDefault().Id, OutputTaxId = db.MstTaxTypes.FirstOrDefault().Id, InputTaxId = db.MstTaxTypes.FirstOrDefault().Id, WTaxTypeId = db.MstTaxTypes.FirstOrDefault().Id, Price = 0, Cost = 0, IsInventory = false, Particulars = "NA", Address = objOtherArticle.Address, TermId = terms.FirstOrDefault().Id, ContactNumber = objOtherArticle.ContactNumber, ContactPerson = objOtherArticle.ContactPerson, EmailAddress = "NA", TaxNumber = "NA", CreditLimit = 0, DateAcquired = DateTime.Now, UsefulLife = 0, SalvageValue = 0, ManualArticleOldCode = "NA", Kitting = 0, IsLocked = true, CreatedById = currentUserId, CreatedDateTime = DateTime.Now, UpdatedById = currentUserId, UpdatedDateTime = DateTime.Now }; db.MstArticles.InsertOnSubmit(newOtherArticle); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK, newOtherArticle.Id)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No term found. Please setup more terms for all master tables.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No tax type found. Please setup more tax types for all master tables.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No unit found. Please setup more units for all master tables.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "No article group found. Please setup at least one article group for other articles.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add other article.")); } } 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 AddUpdateConsignmentItem(Entities.MstArticle objItem, String supplierId) { 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("SupplierDetail") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanAdd) { var article = from d in db.MstArticles where d.Id == Convert.ToInt32(supplierId) select d; if (article.Any()) { if (!article.FirstOrDefault().IsLocked) { var item = from d in db.MstArticles where d.Id == objItem.Id && d.ArticleTypeId == 1 && d.IsLocked == true select d; if (item.Any()) { var updateItem = item.FirstOrDefault(); updateItem.DefaultSupplierId = Convert.ToInt32(supplierId); updateItem.ConsignmentCostPercentage = objItem.ConsignmentCostPercentage; updateItem.ConsignmentCostValue = objItem.ConsignmentCostValue; updateItem.IsConsignment = true; updateItem.IsInventory = true; db.SubmitChanges(); String newObject = at.GetObjectString(item.FirstOrDefault()); at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "The item you're looking was not found in the server.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new consignment item if the current supplier detail is locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "These current supplier details are not found in the server. Please add new supplier first before proceeding.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add new consignment item in this supplier detail page.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this supplier detail 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 SaveCustomer(Entities.MstArticle objCustomer, String id) { 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 customer = from d in db.MstArticles where d.Id == Convert.ToInt32(id) && d.ArticleTypeId == 2 select d; if (customer.Any()) { if (!customer.FirstOrDefault().IsLocked) { String oldObject = auditTrail.GetObjectString(customer.FirstOrDefault()); var saveCustomer = customer.FirstOrDefault(); saveCustomer.ManualArticleCode = objCustomer.ManualArticleCode; saveCustomer.Article = objCustomer.Article; saveCustomer.ArticleGroupId = objCustomer.ArticleGroupId; saveCustomer.AccountId = objCustomer.AccountId; saveCustomer.SalesAccountId = objCustomer.SalesAccountId; saveCustomer.CostAccountId = objCustomer.CostAccountId; saveCustomer.AssetAccountId = objCustomer.AssetAccountId; saveCustomer.ExpenseAccountId = objCustomer.ExpenseAccountId; saveCustomer.TermId = objCustomer.TermId; saveCustomer.Address = objCustomer.Address; saveCustomer.CreditLimit = objCustomer.CreditLimit; saveCustomer.ContactNumber = objCustomer.ContactNumber; saveCustomer.ContactPerson = objCustomer.ContactPerson; saveCustomer.TaxNumber = objCustomer.TaxNumber; saveCustomer.Particulars = objCustomer.Particulars; saveCustomer.EmailAddress = objCustomer.EmailAddress; saveCustomer.UpdatedById = currentUserId; saveCustomer.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); String newObject = auditTrail.GetObjectString(customer.FirstOrDefault()); auditTrail.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, oldObject, newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Saving Error. These customer details are already locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These customer details are not found in the server.")); } } 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.")); } }