/// <summary>
/// Static constructor.
///
/// Loads laminations from an optimizer database.
/// As of 03/15/2019 it only loads from a particular database.
/// </summary>
static StandardLaminations()
{
__laminations = new List <Lamination>();
using (SQLiteConnection sqlCon = new SQLiteConnection(@DATABASE_CONNECTION_STRING, true))
{
sqlCon.Open();
SQLiteCommand sqlCom = new SQLiteCommand("SELECT [name], [tongue], [phase], [width], [height], [base_price], [weight], [shape], [thickness], [grade], [scrap_factor] FROM Std_Lams", sqlCon);
SQLiteDataReader reader = sqlCom.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
try
{
Lamination lamination = new Lamination(true, reader["name"].ToString(), GetCoreShape(reader["shape"].ToString()), GetPhase(reader["phase"].ToString()), GetGrade(reader["grade"].ToString()),
double.Parse(reader["thickness"].ToString()), double.Parse(reader["tongue"].ToString()), DetermineYoke(GetCoreShape(reader["shape"].ToString()), GetPhase(reader["phase"].ToString()), double.Parse(reader["tongue"].ToString())),
double.Parse(reader["width"].ToString()), double.Parse(reader["height"].ToString()), double.Parse(reader["scrap_factor"].ToString()),
GetDestructionFactor(GetGrade(reader["grade"].ToString())), GetExcitationFactor(GetGrade(reader["grade"].ToString())),
double.Parse(reader["base_price"].ToString()), double.Parse(reader["weight"].ToString()));
__laminations.Add(lamination);
}
catch (Exception) { }
}
}
}
}
public IActionResult Save(Lamination entity)
{
try
{
ClaimsPrincipal currentUser = this.User;
var id = currentUser.Claims.FirstOrDefault(z => z.Type.Contains("primarysid")).Value;
if (id == null)
{
return(BadRequest("Identificação do usuário não encontrada."));
}
if (entity.Id > decimal.Zero)
{
var entityBase = genericRepository.Get(entity.Id);
entityBase.Name = entity.Name;
entityBase.Details = entity.Details;
entityBase.UpdateApplicationUserId = id;
entityBase.UpdateDate = DateTime.Now;
genericRepository.Update(entityBase);
}
else
{
entity.ApplicationUserId = id;
entity.CreateDate = DateTime.Now;
genericRepository.Insert(entity);
}
return(new JsonResult(entity));
}
catch (Exception ex)
{
return(new JsonResult(ex));
}
}