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