public void LoadAllDatabase(List <MaterialsInOrder> listMaterialsinorder)
{
DatabaseConnection();
sqlConnection.Open();
sqlCommand.CommandText = "EXEC dbo.ProcMaterialsInOrderSelect";
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
var materialsinorder = new MaterialsInOrder();
for (int i = 0; i < sqlDataReader.FieldCount; i++)
{
var colName = sqlDataReader.GetName(i);
var value = sqlDataReader.GetValue(i);
var property = materialsinorder.GetType().GetProperty(colName);
if (property != null)
{
property.SetValue(materialsinorder, value);
}
}
listMaterialsinorder.Add(materialsinorder);
}
sqlConnection.Close();
}
public void InsertMaterialsinorder(MaterialsInOrder materialinorder)
{
materialinorder.MaterialsinorderId = listMaterialsinorder.Count() + 1;
listMaterialsinorder.Add(materialinorder);
//SQL INSERT
database.InsertMaterialsinorder(materialinorder);
}
public void UpdateMaterialinorder(MaterialsInOrder materialinorder)
{
var XMaterialinorder = listMaterialsinorder.Where(e => e.MaterialsinorderId == materialinorder.MaterialsinorderId).FirstOrDefault();
listMaterialsinorder.Remove(XMaterialinorder);
materialinorder.MaterialsinorderId = XMaterialinorder.MaterialsinorderId;
listMaterialsinorder.Add(materialinorder);
//SQL UPDATE
database.UpdateMaterialsinorder(materialinorder);
}
public void UpdateMaterialsinorder(MaterialsInOrder materialsInOrder)
{
DatabaseConnection();
sqlConnection.Open();
sqlCommand.CommandText = "EXEC ProcMaterialsInOrderUpdate @id, @code, @dimension, @prize, @send, @amount, @receive, @note";
sqlCommand.Parameters.AddWithValue("@id", materialsInOrder.MaterialsinorderId);
sqlCommand.Parameters.AddWithValue("@code", materialsInOrder.MaterialCode);
sqlCommand.Parameters.AddWithValue("@dimension", materialsInOrder.MaterialDimension);
sqlCommand.Parameters.AddWithValue("@prize", materialsInOrder.MaterialPrize);
sqlCommand.Parameters.AddWithValue("@send", materialsInOrder.MaterialQuantitySend);
sqlCommand.Parameters.AddWithValue("@amount", materialsInOrder.MaterialAmount);
sqlCommand.Parameters.AddWithValue("@receive", materialsInOrder.MaterialQuantityReceive);
sqlCommand.Parameters.AddWithValue("@note", materialsInOrder.MaterialNote);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
public int Put([FromBody] MaterialsInOrder materialinorder)
{
materialinorderBL.UpdateMaterialinorder(materialinorder);
return(1);
}
public int Post([FromBody] MaterialsInOrder materialinorder)
{
materialinorderBL.getData();
materialinorderBL.InsertMaterialsinorder(materialinorder);
return(1);
}