public Boolean Update(Order_Product id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_ORDER_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@order_Product_ID", id.order_Product_ID); cmd.Parameters.AddWithValue("@orderID", id.orderID); cmd.Parameters.AddWithValue("@ProductID", id.ProductID); cmd.Parameters.AddWithValue("@Quantity", id.Quantity); cmd.Parameters.AddWithValue("@warehouseid", id.warehouseid); cmd.Parameters.AddWithValue("@DatePicked", id.DatePicked); cmd.Parameters.AddWithValue("@Qtypicked", id.Qtypicked); cmd.ExecuteReader(); con.Close(); return(true); } catch (Exception ex) { return(false); } finally { con.Close(); } }
public Order_Product Insert(Order_Product id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_ORDER_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@orderID", id.orderID); cmd.Parameters.AddWithValue("@ProductID", id.ProductID); cmd.Parameters.AddWithValue("@Quantity", id.Quantity); cmd.Parameters.AddWithValue("@warehouseid", id.warehouseid); cmd.Parameters.AddWithValue("@DatePicked", id.DatePicked); cmd.Parameters.AddWithValue("@Qtypicked", id.Qtypicked); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_ORDER_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@orderID", id.orderID); cmd.Parameters.AddWithValue("@ProductID", id.ProductID); cmd.Parameters.AddWithValue("@Quantity", id.Quantity); cmd.Parameters.AddWithValue("@warehouseid", id.warehouseid); cmd.Parameters.AddWithValue("@DatePicked", id.DatePicked); cmd.Parameters.AddWithValue("@Qtypicked", id.Qtypicked); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.order_Product_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public Order_Product Insert(Order_Product id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_ORDER_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@orderID", id.orderID); cmd.Parameters.AddWithValue("@ProductID", id.ProductID); cmd.Parameters.AddWithValue("@Quantity", id.Quantity); cmd.Parameters.AddWithValue("@warehouseid", id.warehouseid); cmd.Parameters.AddWithValue("@DatePicked", id.DatePicked); cmd.Parameters.AddWithValue("@Qtypicked", id.Qtypicked); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_ORDER_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@orderID", id.orderID); cmd.Parameters.AddWithValue("@ProductID", id.ProductID); cmd.Parameters.AddWithValue("@Quantity", id.Quantity); cmd.Parameters.AddWithValue("@warehouseid", id.warehouseid); cmd.Parameters.AddWithValue("@DatePicked", id.DatePicked); cmd.Parameters.AddWithValue("@Qtypicked", id.Qtypicked); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.order_Product_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
public Order_Product Select(int id) { Order_Product Order_Product = new Order_Product(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_ORDER_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@order_Product_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Order_Product.order_Product_ID = rdr.GetInt32(0); } else { Order_Product.order_Product_ID = 0; } if (!rdr.IsDBNull(1)) { Order_Product.orderID = rdr.GetInt32(1); } else { Order_Product.orderID = 0; } if (!rdr.IsDBNull(2)) { Order_Product.ProductID = rdr.GetInt32(2); } else { Order_Product.ProductID = 0; } if (!rdr.IsDBNull(3)) { Order_Product.Quantity = rdr.GetInt32(3); } else { Order_Product.Quantity = 0; } if (!rdr.IsDBNull(4)) { Order_Product.warehouseid = rdr.GetInt32(4); } else { Order_Product.warehouseid = 0; } if (!rdr.IsDBNull(5)) { Order_Product.DatePicked = rdr.GetDateTime(5); } else { Order_Product.DatePicked = DateTime.Now; } if (!rdr.IsDBNull(6)) { Order_Product.Qtypicked = rdr.GetInt32(6); } else { Order_Product.Qtypicked = 0; } } else { Order_Product.SetColumnDefaults(); } } catch (Exception ex) { Order_Product.SetColumnDefaults(); return(Order_Product); } finally { con.Close(); } return(Order_Product); }
public Boolean Update(Order_Product id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_ORDER_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@order_Product_ID", id.order_Product_ID); cmd.Parameters.AddWithValue("@orderID", id.orderID); cmd.Parameters.AddWithValue("@ProductID", id.ProductID); cmd.Parameters.AddWithValue("@Quantity", id.Quantity); cmd.Parameters.AddWithValue("@warehouseid", id.warehouseid); cmd.Parameters.AddWithValue("@DatePicked", id.DatePicked); cmd.Parameters.AddWithValue("@Qtypicked", id.Qtypicked); cmd.ExecuteReader(); con.Close(); return true; } catch (Exception ex) { return false; } finally { con.Close(); } }
public Order_Product Select(int id) { Order_Product Order_Product = new Order_Product(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_ORDER_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@order_Product_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Order_Product.order_Product_ID = rdr.GetInt32(0); } else { Order_Product.order_Product_ID = 0; } if (!rdr.IsDBNull(1)) { Order_Product.orderID = rdr.GetInt32(1); } else { Order_Product.orderID = 0; } if (!rdr.IsDBNull(2)) { Order_Product.ProductID = rdr.GetInt32(2); } else { Order_Product.ProductID = 0; } if (!rdr.IsDBNull(3)) { Order_Product.Quantity = rdr.GetInt32(3); } else { Order_Product.Quantity = 0; } if (!rdr.IsDBNull(4)) { Order_Product.warehouseid = rdr.GetInt32(4); } else { Order_Product.warehouseid = 0; } if (!rdr.IsDBNull(5)) { Order_Product.DatePicked = rdr.GetDateTime(5); } else { Order_Product.DatePicked = DateTime.Now; } if (!rdr.IsDBNull(6)) { Order_Product.Qtypicked = rdr.GetInt32(6); } else { Order_Product.Qtypicked = 0; } } else { Order_Product.SetColumnDefaults(); } } catch (Exception ex) { Order_Product.SetColumnDefaults(); return Order_Product; } finally { con.Close(); } return Order_Product; }