//
// Methods
//
protected override void Init()
{
LineItem = new PickListModel();
Entries = new List <PickListModel>();
SearchEntity = new PickListModel();
base.Init();
}
public bool Update(PickListModel entity)
{
bool ret = false;
ret = Validate(entity);
if (ret)
{
// TODO: check number of rows updates = 1
using (SqlConnection connection = new SqlConnection(GlobalConnectionString))
{
// Update PickList table
SqlCommand cmdUpdPickList = new SqlCommand(SqlUpdPickList, connection);
cmdUpdPickList.Parameters.Add("@location", SqlDbType.VarChar).Value = entity.Location;
cmdUpdPickList.Parameters.Add("@sku", SqlDbType.VarChar).Value = entity.SKU;
// Update Inventory Table
SqlCommand cmdUpdInventory = new SqlCommand(SqlUpdInventory, connection);
cmdUpdInventory.Parameters.Add("@location", SqlDbType.VarChar).Value = entity.Location;
cmdUpdInventory.Parameters.Add("@sku", SqlDbType.VarChar).Value = entity.SKU;
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
Int32 rowsAffected;
try
{
// Execute Update PickList table
rowsAffected = cmdUpdPickList.ExecuteNonQuery();
if (rowsAffected != 1)
{
throw new Exception("error: " + rowsAffected + " rows were updated in PickList table, instead of 1");
}
// Execute Update Inventory Table
rowsAffected = cmdUpdInventory.ExecuteNonQuery();
if (rowsAffected != 1)
{
throw new Exception("error: " + rowsAffected + " rows were updated in Inventory table, instead of 1");
}
}
catch (Exception ex)
{
// Log error?
throw ex;
}
}
}
return(ret);
}
public PickListModel Get(String Title)
{
var list = new List <PickListModel>();
var ret = new PickListModel();
list = GetAllData();
ret = list.Find(e => e.Title == Title);
return(ret);
}
public bool Insert(PickListModel entity)
{
bool ret = false;
ret = Validate(entity);
if (ret)
{
// TODO: insert to DB code goes here
}
return(ret);
}
public PickListModel NewPicklistItem([FromBody] PickListModel list)
{
try
{
_unitOfWork.PickListRepository.Insert(list);
_unitOfWork.Save();
return(list);
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
}
//
// Search - i.e. Get specific entity
//
public List <PickListModel> Get(PickListModel entity)
{
var ret = new List <PickListModel>();
ret = GetAllData();
// Search/Filter results
if (!string.IsNullOrEmpty(entity.DIFlag))
{
ret = ret.FindAll(e => e.DIFlag.ToUpper().Equals(entity.DIFlag));
}
return(ret);
}
protected override void Delete()
{
var mgr = new PickListDAL();
LineItem = new PickListModel();
//PickList.ID = Convert.ToInt32(EventArgument);
LineItem.Title = EventArgument;
mgr.Delete(LineItem);
Get(); // may or may not want to get all the products again
base.Delete();
}
//
// Get All Data
//
private List <PickListModel> GetAllData()
{
string message = string.Empty;
var PickList = new List <PickListModel>();
using (SqlConnection connection = new SqlConnection(GlobalConnectionString))
{
SqlCommand cmdGetItems = new SqlCommand(SqlGet, connection);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
SqlDataReader dr = cmdGetItems.ExecuteReader();
try
{
while (dr.Read())
{
// Can't we do this automagically somehow?
var lineItem = new PickListModel();
lineItem.SKU = Convert.ToString(dr["SKU"]);
lineItem.Location = Convert.ToString(dr["location"]);
lineItem.ImageURL = Convert.ToString(dr["image_url"]);
lineItem.Quantity = Convert.ToInt32(dr["quantity"]);
lineItem.Title = Convert.ToString(dr["title"]);
lineItem.Variation = Convert.ToString(dr["variation"]);
lineItem.DIFlag = Convert.ToString(dr["di_flag"]);
lineItem.Picked = (dr["item_picked"] as int? == 1) ? true : false;
PickList.Add(lineItem);
}
}
catch (Exception ex)
{
// Log error?
dr.Close();
throw ex;
}
finally
{
dr.Close();
}
}
return(PickList);
}
protected override void Add()
{
IsValid = true;
// Create new pbject and set default values
LineItem = new PickListModel();
LineItem.SKU = "";
LineItem.Location = "";
LineItem.ImageURL = "Images/missing.png";
LineItem.Quantity = 0;
LineItem.Title = "";
LineItem.Variation = "";
LineItem.DIFlag = "";
base.Add();
}
// Methods
//
public bool Validate(PickListModel entity)
{
//
// TODO: put in the BLL class?
//
ValidationErrors.Clear();
/*
* if (entity.ID <= 0)
* {
* ValidationErrors.Add(new KeyValuePair<string, string>("ID", "ID must be > 0"));
* }
* else if (entity.ID > 100)
* {
* ValidationErrors.Add(new KeyValuePair<string, string>("ID", "ID must be less than 100"));
* }
*/
return(ValidationErrors.Count == 0);
}
public bool Delete(PickListModel entity)
{
// TODO: create DELETE code here
return(true);
}
protected override void ResetSearch()
{
SearchEntity = new PickListModel();
base.ResetSearch();
}
