} //"vat":{} public IParseble Parse(JSONNode financyNode) { if (financyNode["sub_total"] != null) { subTotal = new FinanceItem().Parse(financyNode["sub_total"]) as FinanceItem; } if (financyNode["discount"] != null) { discount = new FinanceItemBase().Parse(financyNode["discount"]) as FinanceItemBase; } if (financyNode["fee"] != null) { fee = new FinanceItemBase().Parse(financyNode["fee"]) as FinanceItemBase; } if (financyNode["xsolla_credits"] != null) { xsollaCredits = new FinanceItem().Parse(financyNode["xsolla_credits"]) as FinanceItem; } if (financyNode["total"] != null) { total = new FinanceItemBase().Parse(financyNode["total"]) as FinanceItemBase; } if (financyNode["vat"] != null) { vat = new FinanceItemBase().Parse(financyNode["vat"]) as FinanceItemBase; } return(this); }
private static void GetDataForTable(string table, string alias) { DataTable sqlTable = new DataTable(); _info.Add(table, new List <FinanceItem>()); List <string> colsToIgnore = new List <string>(); using (SqlConnection connection = new SqlConnection(SqlDb.GetConnectionString())) { string qry = qryGeneral; using (SqlCommand cmd = new SqlCommand(string.Format(qry, table, alias.ToUpper()), connection)) { connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { FinanceItem item = new FinanceItem(); // Iterate names of fields in object and set field based on matching column foreach (FieldInfo col in FinanceItem.Properties) { if (!colsToIgnore.Contains(col.Name)) // This should increase speed a bit. { try { string colNameConverted = col.Name.Replace("_", " "); int index = reader.GetOrdinal(colNameConverted); if (index >= 0 && index < reader.FieldCount) { var temp = reader.GetValue(index); if (temp != null) { string value = temp.ToString().Trim(); col.SetValue(item, value); } } } catch (IndexOutOfRangeException e) { colsToIgnore.Add(col.Name); Console.WriteLine(string.Format("Looks like one of our columns wasn't found: {0}", col)); } } } _info[table].Add(item); } } finally { // Always call Close when done reading. reader.Close(); } } } }
public IHttpActionResult PutFinanceItem(int id, FinanceItem financeItem) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != financeItem.Id) { return(BadRequest()); } _context.Entry(financeItem).State = EntityState.Modified; try { _context.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!FinanceItemExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
private static void SetItemOptions() { DataTable sqlTable = new DataTable(); List <string> options = new List <string>(); using (SqlConnection connection = new SqlConnection(SqlDb.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand(qryLineItems, connection)) { connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { FinanceItem item = new FinanceItem(); string value = reader.GetValue(0).ToString().Trim(); options.Add(value); } } finally { // Always call Close when done reading. reader.Close(); } } } DataItemOptions = options; }
protected void Application_Start() { GlobalConfiguration.Configure(WebApiConfig.Register); AuthBot.Models.AuthSettings.Mode = ConfigurationManager.AppSettings["ActiveDirectory.Mode"]; AuthBot.Models.AuthSettings.EndpointUrl = ConfigurationManager.AppSettings["ActiveDirectory.EndpointUrl"]; AuthBot.Models.AuthSettings.Tenant = ConfigurationManager.AppSettings["ActiveDirectory.Tenant"]; AuthBot.Models.AuthSettings.RedirectUrl = ConfigurationManager.AppSettings["ActiveDirectory.RedirectUrl"]; AuthBot.Models.AuthSettings.ClientId = ConfigurationManager.AppSettings["ActiveDirectory.ClientId"]; AuthBot.Models.AuthSettings.ClientSecret = ConfigurationManager.AppSettings["ActiveDirectory.ClientSecret"]; AuthBot.Models.AuthSettings.Scopes = ConfigurationManager.AppSettings["ActiveDirectory.Scopes"].Split(','); SqlDb.Server = ConfigurationManager.AppSettings["Db.Server"]; SqlDb.InitialCatalog = ConfigurationManager.AppSettings["Db.InitialCatalog"]; SqlDb.PersistSecurityInfo = ConfigurationManager.AppSettings["Db.PersistSecurityInfo"]; SqlDb.UserId = ConfigurationManager.AppSettings["Db.UserId"]; SqlDb.Password = ConfigurationManager.AppSettings["Db.Password"]; SqlDb.MultipleActiveResultSets = ConfigurationManager.AppSettings["Db.MultipleActiveResultSets"]; SqlDb.Encrypt = ConfigurationManager.AppSettings["Db.Encrypt"]; SqlDb.TrustCertificate = ConfigurationManager.AppSettings["Db.TrustServerCertificate"]; SqlDb.ConnectionTimeout = ConfigurationManager.AppSettings["Db.ConnectionTimeout"]; SqlDb.ConnectionString = ConfigurationManager.AppSettings["Db.ConnectionString"]; Models.User.CORP_DOMAIN = ConfigurationManager.AppSettings["CorpDomain"]; FinanceItem.SetProperties(); }
public IHttpActionResult GetFinanceItem(int id) { FinanceItem financeItem = _context.FinanceItems.Find(id); if (financeItem == null) { return(NotFound()); } return(Ok(financeItem)); }
public IHttpActionResult PostFinanceItem(FinanceItem financeItem) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.FinanceItems.Add(financeItem); _context.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = financeItem.Id }, financeItem)); }
public IHttpActionResult DeleteFinanceItem(int id) { FinanceItem financeItem = _context.FinanceItems.Find(id); if (financeItem == null) { return(NotFound()); } _context.FinanceItems.Remove(financeItem); _context.SaveChanges(); return(Ok(financeItem)); }
public IParseble Parse(JSONNode financyNode) { if(financyNode["sub_total"] != null) subTotal = new FinanceItem().Parse(financyNode["sub_total"]) as FinanceItem; if(financyNode["discount"] != null) discount = new FinanceItemBase().Parse(financyNode["discount"]) as FinanceItemBase; if(financyNode["fee"] != null) fee = new FinanceItemBase().Parse(financyNode["fee"]) as FinanceItemBase; if(financyNode["xsolla_credits"] != null) xsollaCredits = new FinanceItem().Parse(financyNode["xsolla_credits"]) as FinanceItem; if(financyNode["total"] != null) total = new FinanceItemBase().Parse(financyNode["total"]) as FinanceItemBase; if(financyNode["vat"] != null) vat = new FinanceItemBase().Parse(financyNode["vat"]) as FinanceItemBase; return this; }
public static void Initialize(WhatWeGotContext context) { if (context.Items.Any() || context.Categories.Any()) { return; // DB has been seeded } var category = new Category { CategoryDescription = "Test", CategoryName = "TestCat" }; var items = new FinanceItem { Category = category, Amount = 123, EventDate = DateTime.Now.AddDays(-5), ItemName = "WalmartTest" }; context.Add(items); context.SaveChanges(); }
public async Task Post([FromBody] FinanceItem value) { await _repo.SaveFinanceItem(value); }
public async Task SaveFinanceItem(FinanceItem item) { await _context.AddAsync(item); await _context.SaveChangesAsync(); }