public Int32 insertArticlePrice(Models.MstArticlePrice price) { try { Data.MstArticlePrice newPrice = new Data.MstArticlePrice(); newPrice.ArticleId = price.ArticleId; newPrice.PriceDescription = price.PriceDescription; newPrice.Price = price.Price; newPrice.Remarks = price.Remarks; db.MstArticlePrices.InsertOnSubmit(newPrice); db.SubmitChanges(); return newPrice.Id; } catch { return 0; } }
public Int32 insertArticlePrice(Models.MstArticlePrice price) { try { Data.MstArticlePrice newPrice = new Data.MstArticlePrice(); newPrice.ArticleId = price.ArticleId; newPrice.PriceDescription = price.PriceDescription; newPrice.Price = price.Price; newPrice.Remarks = price.Remarks; db.MstArticlePrices.InsertOnSubmit(newPrice); db.SubmitChanges(); return(newPrice.Id); } catch { return(0); } }
public HttpResponseMessage AddItemPrice(Entities.MstArticlePrice objItemPrice, String itemId) { 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().CanAdd) { var item = from d in db.MstArticles where d.Id == Convert.ToInt32(itemId) && d.ArticleTypeId == 1 select d; if (item.Any()) { if (!item.FirstOrDefault().IsLocked) { Data.MstArticlePrice newItemPrice = new Data.MstArticlePrice { ArticleId = Convert.ToInt32(itemId), PriceDescription = objItemPrice.PriceDescription, Price = objItemPrice.Price, Remarks = objItemPrice.Remarks }; db.MstArticlePrices.InsertOnSubmit(newItemPrice); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new price if the current item detail is locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "These current item details are not found in the server. Please add new item first before proceeding.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add new price in this item detail page.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in 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 List <Entities.ReturnedDocument> QuintaIntegrationAddSalesInvoice(Entities.RootObject objRoot) { try { List <Entities.ReturnedDocument> listSINumber = new List <Entities.ReturnedDocument>(); var branch = from d in db.MstBranches select d; if (branch.Any()) { Int32 currentBranchId = branch.FirstOrDefault().Id; if (objRoot.TRN.Any()) { foreach (var objSales in objRoot.TRN) { if (objSales != null) { Boolean unitExist = false; var units = from d in db.MstUnits select d; if (units.Any()) { unitExist = true; } Boolean termExist = false; var terms = from d in db.MstTerms where d.Term.Equals(objRoot.DefaultTerm) select d; if (terms.Any()) { termExist = true; } Boolean userExist = false; var users = from d in db.MstUsers where d.UserName.Equals("admin") select d; if (users.Any()) { userExist = true; } Int32 customerId = 0; var customers = from d in db.MstArticles where d.ManualArticleCode.Equals(objSales.ACI) && d.ArticleTypeId == 2 select d; if (customers.Any()) { customerId = customers.FirstOrDefault().Id; } else { var defaultCustomerCode = "0000000001"; var lastCustomer = from d in db.MstArticles.OrderByDescending(d => d.Id) where d.ArticleTypeId == 2 select d; if (lastCustomer.Any()) { var customerCode = Convert.ToInt32(lastCustomer.FirstOrDefault().ArticleCode) + 0000000001; defaultCustomerCode = ZeroFill(customerCode, 10); } var articleGroups = from d in db.MstArticleGroups where d.ArticleTypeId == 2 select d; if (articleGroups.Any()) { Data.MstArticle newCustomer = new Data.MstArticle { ArticleCode = defaultCustomerCode, ManualArticleCode = objSales.ACI, Article = objSales.ACC, Category = "NA", ArticleTypeId = 2, 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, IsConsignment = false, ConsignmentCostPercentage = 0, ConsignmentCostValue = 0, Particulars = "NA", Address = "NA", TermId = terms.FirstOrDefault().Id, ContactNumber = "NA", ContactPerson = "NA", 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 = users.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedById = users.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now }; db.MstArticles.InsertOnSubmit(newCustomer); db.SubmitChanges(); customerId = newCustomer.Id; } } Boolean taxTypeExist = false; var taxTypes = from d in db.MstTaxTypes select d; if (taxTypes.Any()) { taxTypeExist = true; } Boolean discountExist = false; var discounts = from d in db.MstDiscounts where d.Discount.Equals(objRoot.DefaultDiscount) select d; if (discounts.Any()) { discountExist = true; } if (userExist) { if (termExist) { if (customerId != 0) { Int32 salesInvoiceId = 0; var SINumberResult = "0000000001"; var lastSalesInvoice = from d in db.TrnSalesInvoices.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId select d; if (lastSalesInvoice.Any()) { var SINumber = Convert.ToInt32(lastSalesInvoice.FirstOrDefault().SINumber) + 0000000001; SINumberResult = ZeroFill(SINumber, 10); } Data.TrnSalesInvoice addSalesInvoice = new Data.TrnSalesInvoice { BranchId = currentBranchId, SINumber = SINumberResult, SIDate = Convert.ToDateTime(objSales.TDT), CustomerId = customerId, TermId = terms.FirstOrDefault().Id, DocumentReference = objSales.FTN, ManualSINumber = objSales.FTN, Remarks = "NA", Amount = objSales.NAM, PaidAmount = 0, AdjustmentAmount = 0, BalanceAmount = objSales.NAM, SoldById = users.FirstOrDefault().Id, PreparedById = users.FirstOrDefault().Id, CheckedById = users.FirstOrDefault().Id, ApprovedById = users.FirstOrDefault().Id, IsLocked = true, CreatedById = users.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedById = users.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now }; db.TrnSalesInvoices.InsertOnSubmit(addSalesInvoice); db.SubmitChanges(); salesInvoiceId = addSalesInvoice.Id; listSINumber.Add(new Entities.ReturnedDocument() { SINumber = addSalesInvoice.SINumber, ManualSINumber = addSalesInvoice.ManualSINumber }); if (salesInvoiceId != 0) { Int32 itemId = 0; var items = from d in db.MstArticles where d.ManualArticleCode.Equals(objSales.SAI) && d.ArticleTypeId == 1 select d; if (items.Any()) { itemId = items.FirstOrDefault().Id; } else { var defaultItemCode = "0000000001"; var lastItem = from d in db.MstArticles.OrderByDescending(d => d.Id) where d.ArticleTypeId == 1 select d; if (lastItem.Any()) { var itemCode = Convert.ToInt32(lastItem.FirstOrDefault().ArticleCode) + 0000000001; defaultItemCode = ZeroFill(itemCode, 10); } var articleGroups = from d in db.MstArticleGroups where d.ArticleTypeId == 1 select d; if (articleGroups.Any()) { Data.MstArticle newItem = new Data.MstArticle { ArticleCode = defaultItemCode, ManualArticleCode = objSales.SAI, Article = objSales.SAM, Category = "NA", ArticleTypeId = 1, 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 = taxTypes.Where(d => d.TaxType.Equals(objRoot.DefaultVatOutput)).FirstOrDefault().Id, InputTaxId = taxTypes.Where(d => d.TaxType.Equals(objRoot.DefaultVatInput)).FirstOrDefault().Id, WTaxTypeId = taxTypes.Where(d => d.TaxType.Equals(objRoot.DefaultWTax)).FirstOrDefault().Id, Price = objSales.NAM, Cost = 0, IsInventory = false, IsConsignment = false, ConsignmentCostPercentage = 0, ConsignmentCostValue = 0, Particulars = "NA", Address = "NA", TermId = terms.FirstOrDefault().Id, ContactNumber = "NA", ContactPerson = "NA", 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 = users.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedById = users.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now }; db.MstArticles.InsertOnSubmit(newItem); db.SubmitChanges(); itemId = newItem.Id; Data.MstArticleUnit newItemUnitConversion = new Data.MstArticleUnit { ArticleId = Convert.ToInt32(itemId), UnitId = units.FirstOrDefault().Id, Multiplier = 1, IsCountUnit = false }; db.MstArticleUnits.InsertOnSubmit(newItemUnitConversion); db.SubmitChanges(); Data.MstArticlePrice newItemPrice = new Data.MstArticlePrice { ArticleId = Convert.ToInt32(itemId), PriceDescription = "SRP", Price = objSales.NAM, Remarks = "NA" }; db.MstArticlePrices.InsertOnSubmit(newItemPrice); db.SubmitChanges(); } } if (itemId != 0) { if (unitExist) { if (taxTypeExist) { if (discountExist) { Int32?itemInventoryId = null; var articleInventory = from d in db.MstArticleInventories where d.BranchId == currentBranchId && d.ArticleId == itemId select d; if (articleInventory.Any()) { itemInventoryId = articleInventory.FirstOrDefault().Id; } var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == itemId && d.UnitId == items.FirstOrDefault().UnitId select d; if (conversionUnit.Any()) { Decimal baseQuantity = 1; Decimal basePrice = objSales.NAM; if (conversionUnit.FirstOrDefault().Multiplier > 0) { baseQuantity = 1 * (1 / conversionUnit.FirstOrDefault().Multiplier); } if (baseQuantity > 0) { basePrice = objSales.NAM / baseQuantity; } Data.TrnSalesInvoiceItem newSalesInvoiceItem = new Data.TrnSalesInvoiceItem { SIId = salesInvoiceId, ItemId = itemId, ItemInventoryId = itemInventoryId, Particulars = "NA", UnitId = units.FirstOrDefault().Id, Quantity = 1, Price = objSales.NAM, DiscountId = discounts.FirstOrDefault().Id, DiscountRate = discounts.FirstOrDefault().DiscountRate, DiscountAmount = 0, NetPrice = objSales.NAM, Amount = objSales.NAM, VATId = items.FirstOrDefault().OutputTaxId, VATPercentage = items.FirstOrDefault().MstTaxType.TaxRate, VATAmount = (objSales.NAM / (1 + (items.FirstOrDefault().MstTaxType.TaxRate / 100))) * (items.FirstOrDefault().MstTaxType.TaxRate / 100), BaseUnitId = items.FirstOrDefault().UnitId, BaseQuantity = baseQuantity, BasePrice = basePrice, SalesItemTimeStamp = DateTime.Now }; db.TrnSalesInvoiceItems.InsertOnSubmit(newSalesInvoiceItem); db.SubmitChanges(); } } } } } var currentSalesInvoice = from d in db.TrnSalesInvoices where d.Id == salesInvoiceId select d; if (currentSalesInvoice.Any()) { Decimal salesAmount = 0; Decimal paidAmount = currentSalesInvoice.FirstOrDefault().PaidAmount; Decimal adjustmentAmount = currentSalesInvoice.FirstOrDefault().AdjustmentAmount; var salesInvoiceItems = from d in db.TrnSalesInvoiceItems where d.SIId == salesInvoiceId select d; if (salesInvoiceItems.Any()) { salesAmount = salesInvoiceItems.Sum(d => d.Amount); } var updateSalesInvoiceAmount = currentSalesInvoice.FirstOrDefault(); updateSalesInvoiceAmount.Amount = salesAmount; updateSalesInvoiceAmount.BalanceAmount = (salesAmount - paidAmount) + adjustmentAmount; db.SubmitChanges(); } inventory.InsertSalesInvoiceInventory(Convert.ToInt32(salesInvoiceId)); journal.InsertSalesInvoiceJournal(Convert.ToInt32(salesInvoiceId)); if (currentSalesInvoice.Any()) { var defaultORNumber = "0000000001"; var lastCollection = from d in db.TrnCollections.OrderByDescending(d => d.Id) where d.BranchId == currentBranchId select d; if (lastCollection.Any()) { var ORNumber = Convert.ToInt32(lastCollection.FirstOrDefault().ORNumber) + 0000000001; defaultORNumber = ZeroFill(ORNumber, 10); } Data.TrnCollection newCollection = new Data.TrnCollection { BranchId = currentBranchId, ORNumber = defaultORNumber, ORDate = Convert.ToDateTime(objSales.ADT), ManualORNumber = "NA", CustomerId = customers.FirstOrDefault().Id, Particulars = "NA", PreparedById = users.FirstOrDefault().Id, CheckedById = users.FirstOrDefault().Id, ApprovedById = users.FirstOrDefault().Id, IsLocked = true, CreatedById = users.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedById = users.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now }; db.TrnCollections.InsertOnSubmit(newCollection); db.SubmitChanges(); Boolean payTypeExist = false; var payTypes = from d in db.MstPayTypes select d; if (payTypes.Any()) { payTypeExist = true; } Boolean bankExist = false; var banks = from d in db.MstArticles where d.ArticleTypeId == 5 select d; if (banks.Any()) { bankExist = true; } if (payTypeExist) { if (bankExist) { Data.TrnCollectionLine newCollectionLine = new Data.TrnCollectionLine { ORId = newCollection.Id, BranchId = currentBranchId, AccountId = currentSalesInvoice.FirstOrDefault().MstArticle.AccountId, ArticleId = currentSalesInvoice.FirstOrDefault().CustomerId, SIId = currentSalesInvoice.FirstOrDefault().Id, Particulars = currentSalesInvoice.FirstOrDefault().Remarks, Amount = objSales.NAM, PayTypeId = payTypes.FirstOrDefault().Id, CheckNumber = "NA", CheckDate = DateTime.Today, CheckBank = "NA", DepositoryBankId = banks.FirstOrDefault().Id, IsClear = true }; db.TrnCollectionLines.InsertOnSubmit(newCollectionLine); db.SubmitChanges(); journal.InsertOfficialReceiptJournal(Convert.ToInt32(newCollection.Id)); accountsReceivable.UpdateAccountsReceivable(currentSalesInvoice.FirstOrDefault().Id); } } } } } } } } } } return(listSINumber.ToList()); } else { return(new List <Entities.ReturnedDocument>()); } } catch (Exception e) { Debug.WriteLine(e); return(new List <Entities.ReturnedDocument>()); } }
public HttpResponseMessage AddItemPrice(Entities.MstArticlePrice objItemPrice, String itemId) { 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().CanAdd) { var item = from d in db.MstArticles where d.Id == Convert.ToInt32(itemId) && d.ArticleTypeId == 1 select d; if (item.Any()) { if (!item.FirstOrDefault().IsLocked) { String standardCaseVariablePrice = "Variable"; Boolean isVariablePriceRestriction = false; if (string.Equals(standardCaseVariablePrice, objItemPrice.PriceDescription.Trim(), StringComparison.OrdinalIgnoreCase)) { isVariablePriceRestriction = true; } if (isVariablePriceRestriction) { if (objItemPrice.Price == Convert.ToDecimal(1)) { Data.MstArticlePrice newItemPrice = new Data.MstArticlePrice { ArticleId = Convert.ToInt32(itemId), PriceDescription = objItemPrice.PriceDescription, Price = objItemPrice.Price, Remarks = objItemPrice.Remarks }; db.MstArticlePrices.InsertOnSubmit(newItemPrice); db.SubmitChanges(); String newObject = at.GetObjectString(newItemPrice); at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Invalid Price Description.")); } } else { Data.MstArticlePrice newItemPrice = new Data.MstArticlePrice { ArticleId = Convert.ToInt32(itemId), PriceDescription = objItemPrice.PriceDescription, Price = objItemPrice.Price, Remarks = objItemPrice.Remarks }; db.MstArticlePrices.InsertOnSubmit(newItemPrice); db.SubmitChanges(); String newObject = at.GetObjectString(newItemPrice); at.InsertAuditTrail(currentUser.FirstOrDefault().Id, GetType().Name, MethodBase.GetCurrentMethod().Name, "NA", newObject); return(Request.CreateResponse(HttpStatusCode.OK)); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new price if the current item detail is locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "These current item details are not found in the server. Please add new item first before proceeding.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add new price in this item detail page.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in 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 UpdatePriceArticlePrice(Entities.TrnArticlePrice objArticlePrice, 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("ItemPriceDetail") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanEdit) { var articlePrice = from d in db.TrnArticlePrices where d.Id == Convert.ToInt32(id) select d; if (articlePrice.Any()) { if (articlePrice.FirstOrDefault().IsLocked) { var articlePriceItems = from d in db.TrnArticlePriceItems where d.ArticlePriceId == articlePrice.FirstOrDefault().Id select d; if (articlePriceItems.Any()) { foreach (var articlePriceItem in articlePriceItems) { var item = from d in db.MstArticles where d.Id == articlePriceItem.ItemId select d; if (item.Any()) { var mstArticlePrice = from d in db.MstArticlePrices where d.PriceDescription.Equals("IP-" + articlePrice.FirstOrDefault().MstBranch.BranchCode + "-" + articlePrice.FirstOrDefault().IPNumber + " (" + articlePrice.FirstOrDefault().IPDate.ToShortDateString() + ")") select d; if (mstArticlePrice.Any()) { db.MstArticlePrices.DeleteOnSubmit(mstArticlePrice.FirstOrDefault()); db.SubmitChanges(); var updateItem = item.FirstOrDefault(); updateItem.Price = articlePriceItem.Price; updateItem.UpdatedDateTime = DateTime.Today; db.SubmitChanges(); Data.MstArticlePrice newArticlePrice = new Data.MstArticlePrice { ArticleId = articlePriceItem.ItemId, PriceDescription = "IP-" + articlePrice.FirstOrDefault().MstBranch.BranchCode + "-" + articlePrice.FirstOrDefault().IPNumber + " (" + articlePrice.FirstOrDefault().IPDate.ToShortDateString() + ")", Price = articlePriceItem.Price, Remarks = "Branch: " + articlePrice.FirstOrDefault().MstBranch.Branch + "\nIP Date: " + articlePrice.FirstOrDefault().IPDate.ToShortDateString() + "\nIP Number: " + articlePrice.FirstOrDefault().IPNumber + "\nManual IP Number: " + articlePrice.FirstOrDefault().ManualIPNumber }; db.MstArticlePrices.InsertOnSubmit(newArticlePrice); db.SubmitChanges(); } else { var updateItem = item.FirstOrDefault(); updateItem.Price = articlePriceItem.Price; updateItem.UpdatedDateTime = DateTime.Today; db.SubmitChanges(); Data.MstArticlePrice newArticlePrice = new Data.MstArticlePrice { ArticleId = articlePriceItem.ItemId, PriceDescription = "IP-" + articlePrice.FirstOrDefault().MstBranch.BranchCode + "-" + articlePrice.FirstOrDefault().IPNumber + " (" + articlePrice.FirstOrDefault().IPDate.ToShortDateString() + ")", Price = articlePriceItem.Price, Remarks = "Branch: " + articlePrice.FirstOrDefault().MstBranch.Branch + "\nIP Date: " + articlePrice.FirstOrDefault().IPDate.ToShortDateString() + "\nIP Number: " + articlePrice.FirstOrDefault().IPNumber + "\nManual IP Number: " + articlePrice.FirstOrDefault().ManualIPNumber }; db.MstArticlePrices.InsertOnSubmit(newArticlePrice); db.SubmitChanges(); } } } } return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Update Error. Please lock the item price before proceeding.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Data not found. These item price details are not found in the server.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to update price.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this item price 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.")); } }