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); }