// RPT_OrderingDetailClass Searc //public static List<RPT_OrderingDetailClass> Search1(String PO_Number) //{ // SqlConnection connection = SAMDataClass.GetConnection(); // string selectProcedure = "OrderingDetailSearch"; // SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); // selectCommand.CommandType = CommandType.StoredProcedure; // if (!String.IsNullOrEmpty(PO_Number)) // { // selectCommand.Parameters.AddWithValue("@PO_Number", PO_Number); // } // else // { // selectCommand.Parameters.AddWithValue("@PO_Number", DBNull.Value); // } // List<RPT_OrderingDetailClass> item = new List<RPT_OrderingDetailClass>(); // DataTable dt = new DataTable(); // try // { // connection.Open(); // SqlDataReader reader1 = selectCommand.ExecuteReader(); // if (reader1.HasRows) // { // dt.Load(reader1); // foreach (DataRow reader in dt.Rows) // { // item.Add( // new RPT_OrderingDetailClass() // { // Ordering_Detail_ID = reader["Ordering_Detail_ID"] is DBNull ? null : reader["Ordering_Detail_ID"].ToString(), // PO_Number = reader["PO_Number"] is DBNull ? null : reader["PO_Number"].ToString(), // Product_ID = reader["Product_ID"] is DBNull ? null : reader["Product_ID"].ToString(), // Price = reader["Price"] is DBNull ? 0 : (Decimal)reader["Price"], // Vat = reader["Vat"] is DBNull ? 0 : (Decimal)reader["Vat"], // Stock_on_hand = reader["Stock_on_hand"] is DBNull ? Int16.Parse("0") : (Int16)reader["Stock_on_hand"], // Suggest_Quantity = reader["Suggest_Quantity"] is DBNull ? Int16.Parse("0") : (Int16)reader["Suggest_Quantity"], // Quantity = reader["Quantity"] is DBNull ? Int16.Parse("0") : (Int16)reader["Quantity"], // Sub_Total = reader["Sub_Total"] is DBNull ? 0 : (Decimal)reader["Sub_Total"], // Vat_Amount = reader["Vat_Amount"] is DBNull ? 0 : (Decimal)reader["Vat_Amount"], // Total = reader["Total"] is DBNull ? 0 : (Decimal)reader["Total"], // Point = reader["Point"] is DBNull ? Byte.Parse("0"): (Byte)reader["Point"], // } // ); // } // } // reader1.Close(); // } // catch (SqlException ex) // { // return item; // } // catch (Exception ex) // { // } // finally // { // connection.Close(); // } // return item; //} // public static List<Product_Quantity> public static dbo_OrderingDetailClass Select_Record(String Ordering_Detail_ID) { dbo_OrderingDetailClass clsdbo_OrderingDetail = new dbo_OrderingDetailClass(); SqlConnection connection = SAMDataClass.GetConnection(); string selectProcedure = "[OrderingDetailSelect]"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@Ordering_Detail_ID", Ordering_Detail_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_OrderingDetail.Ordering_Detail_ID = reader["Ordering_Detail_ID"] is DBNull ? null : reader["Ordering_Detail_ID"].ToString(); clsdbo_OrderingDetail.PO_Number = reader["PO_Number"] is DBNull ? null : reader["PO_Number"].ToString(); clsdbo_OrderingDetail.Product_ID = reader["Product_ID"] is DBNull ? null : reader["Product_ID"].ToString(); clsdbo_OrderingDetail.Price = reader["Price"] is DBNull ? null : (Decimal?)reader["Price"]; clsdbo_OrderingDetail.Vat = reader["Vat"] is DBNull ? null : (Decimal?)reader["Vat"]; clsdbo_OrderingDetail.Stock_on_hand = reader["Stock_on_hand"] is DBNull ? null : (Int16?)reader["Stock_on_hand"]; clsdbo_OrderingDetail.Suggest_Quantity = reader["Suggest_Quantity"] is DBNull ? null : (Int16?)reader["Suggest_Quantity"]; clsdbo_OrderingDetail.Quantity = reader["Quantity"] is DBNull ? null : (Int16?)reader["Quantity"]; clsdbo_OrderingDetail.Sub_Total = reader["Sub_Total"] is DBNull ? null : (Decimal?)reader["Sub_Total"]; clsdbo_OrderingDetail.Vat_Amount = reader["Vat_Amount"] is DBNull ? null : (Decimal?)reader["Vat_Amount"]; clsdbo_OrderingDetail.Total = reader["Total"] is DBNull ? null : (Decimal?)reader["Total"]; clsdbo_OrderingDetail.Point = reader["Point"] is DBNull ? null : (Byte?)reader["Point"]; } else { clsdbo_OrderingDetail = null; } reader.Close(); } catch (SqlException ex) { logger.Error(ex.Message); return(clsdbo_OrderingDetail); } finally { connection.Close(); } return(clsdbo_OrderingDetail); }
public static bool Update(dbo_OrderingDetailClass newdbo_OrderingDetailClass, String Last_Modified_By) { logger.Info(System.Web.HttpContext.Current.Request.Cookies["User_ID"].Value == null ? string.Empty : System.Web.HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); SqlConnection connection = SAMDataClass.GetConnection(); string updateProcedure = "[OrderingDetailUpdate]"; SqlCommand updateCommand = new SqlCommand(updateProcedure, connection); updateCommand.CommandType = CommandType.StoredProcedure; if (newdbo_OrderingDetailClass.Ordering_Detail_ID != null) { updateCommand.Parameters.AddWithValue("@NewOrdering_Detail_ID", newdbo_OrderingDetailClass.Ordering_Detail_ID); } else { updateCommand.Parameters.AddWithValue("@NewOrdering_Detail_ID", DBNull.Value); } if (newdbo_OrderingDetailClass.PO_Number != null) { updateCommand.Parameters.AddWithValue("@NewPO_Number", newdbo_OrderingDetailClass.PO_Number); } else { updateCommand.Parameters.AddWithValue("@NewPO_Number", DBNull.Value); } if (newdbo_OrderingDetailClass.Product_ID != null) { updateCommand.Parameters.AddWithValue("@NewProduct_ID", newdbo_OrderingDetailClass.Product_ID); } else { updateCommand.Parameters.AddWithValue("@NewProduct_ID", DBNull.Value); } if (newdbo_OrderingDetailClass.Price.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewPrice", newdbo_OrderingDetailClass.Price); } else { updateCommand.Parameters.AddWithValue("@NewPrice", DBNull.Value); } if (newdbo_OrderingDetailClass.Vat.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewVat", newdbo_OrderingDetailClass.Vat); } else { updateCommand.Parameters.AddWithValue("@NewVat", DBNull.Value); } if (newdbo_OrderingDetailClass.Stock_on_hand.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewStock_on_hand", newdbo_OrderingDetailClass.Stock_on_hand); } else { updateCommand.Parameters.AddWithValue("@NewStock_on_hand", DBNull.Value); } if (newdbo_OrderingDetailClass.Suggest_Quantity.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewSuggest_Quantity", newdbo_OrderingDetailClass.Suggest_Quantity); } else { updateCommand.Parameters.AddWithValue("@NewSuggest_Quantity", DBNull.Value); } if (newdbo_OrderingDetailClass.Quantity.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewQuantity", newdbo_OrderingDetailClass.Quantity); } else { updateCommand.Parameters.AddWithValue("@NewQuantity", DBNull.Value); } if (newdbo_OrderingDetailClass.Sub_Total.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewSub_Total", newdbo_OrderingDetailClass.Sub_Total); } else { updateCommand.Parameters.AddWithValue("@NewSub_Total", DBNull.Value); } if (newdbo_OrderingDetailClass.Vat_Amount.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewVat_Amount", newdbo_OrderingDetailClass.Vat_Amount); } else { updateCommand.Parameters.AddWithValue("@NewVat_Amount", DBNull.Value); } if (newdbo_OrderingDetailClass.Total.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewTotal", newdbo_OrderingDetailClass.Total); } else { updateCommand.Parameters.AddWithValue("@NewTotal", DBNull.Value); } if (newdbo_OrderingDetailClass.Point.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewPoint", newdbo_OrderingDetailClass.Point); } else { updateCommand.Parameters.AddWithValue("@NewPoint", DBNull.Value); } if (!string.IsNullOrEmpty(Last_Modified_By)) { updateCommand.Parameters.AddWithValue("@Last_Modified_By", Last_Modified_By); } else { updateCommand.Parameters.AddWithValue("@Last_Modified_By", DBNull.Value); } updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); updateCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { logger.Error(ex.Message); return(false); } finally { connection.Close(); } }
public static bool Add(dbo_OrderingDetailClass clsdbo_OrderingDetail, String Created_By) { logger.Info(System.Web.HttpContext.Current.Request.Cookies["User_ID"].Value == null ? string.Empty : System.Web.HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); SqlConnection connection = SAMDataClass.GetConnection(); string insertProcedure = "OrderingDetailInsert"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_OrderingDetail.Ordering_Detail_ID != null) { insertCommand.Parameters.AddWithValue("@Ordering_Detail_ID", clsdbo_OrderingDetail.Ordering_Detail_ID); } else { insertCommand.Parameters.AddWithValue("@Ordering_Detail_ID", DBNull.Value); } if (clsdbo_OrderingDetail.PO_Number != null) { insertCommand.Parameters.AddWithValue("@PO_Number", clsdbo_OrderingDetail.PO_Number); } else { insertCommand.Parameters.AddWithValue("@PO_Number", DBNull.Value); } if (clsdbo_OrderingDetail.Product_ID != null) { insertCommand.Parameters.AddWithValue("@Product_ID", clsdbo_OrderingDetail.Product_ID); } else { insertCommand.Parameters.AddWithValue("@Product_ID", DBNull.Value); } if (clsdbo_OrderingDetail.Price.HasValue == true) { insertCommand.Parameters.AddWithValue("@Price", clsdbo_OrderingDetail.Price); } else { insertCommand.Parameters.AddWithValue("@Price", DBNull.Value); } if (clsdbo_OrderingDetail.Vat.HasValue == true) { insertCommand.Parameters.AddWithValue("@Vat", clsdbo_OrderingDetail.Vat); } else { insertCommand.Parameters.AddWithValue("@Vat", DBNull.Value); } if (clsdbo_OrderingDetail.Stock_on_hand.HasValue == true) { insertCommand.Parameters.AddWithValue("@Stock_on_hand", clsdbo_OrderingDetail.Stock_on_hand); } else { insertCommand.Parameters.AddWithValue("@Stock_on_hand", DBNull.Value); } if (clsdbo_OrderingDetail.Suggest_Quantity.HasValue == true) { insertCommand.Parameters.AddWithValue("@Suggest_Quantity", clsdbo_OrderingDetail.Suggest_Quantity); } else { insertCommand.Parameters.AddWithValue("@Suggest_Quantity", DBNull.Value); } if (clsdbo_OrderingDetail.Quantity.HasValue == true) { insertCommand.Parameters.AddWithValue("@Quantity", clsdbo_OrderingDetail.Quantity); } else { insertCommand.Parameters.AddWithValue("@Quantity", DBNull.Value); } if (clsdbo_OrderingDetail.Sub_Total.HasValue == true) { insertCommand.Parameters.AddWithValue("@Sub_Total", clsdbo_OrderingDetail.Sub_Total); } else { insertCommand.Parameters.AddWithValue("@Sub_Total", DBNull.Value); } if (clsdbo_OrderingDetail.Vat_Amount.HasValue == true) { insertCommand.Parameters.AddWithValue("@Vat_Amount", clsdbo_OrderingDetail.Vat_Amount); } else { insertCommand.Parameters.AddWithValue("@Vat_Amount", DBNull.Value); } if (clsdbo_OrderingDetail.Total.HasValue == true) { insertCommand.Parameters.AddWithValue("@Total", clsdbo_OrderingDetail.Total); } else { insertCommand.Parameters.AddWithValue("@Total", DBNull.Value); } if (clsdbo_OrderingDetail.Point.HasValue == true) { insertCommand.Parameters.AddWithValue("@Point", clsdbo_OrderingDetail.Point); } else { insertCommand.Parameters.AddWithValue("@Point", DBNull.Value); } if (!string.IsNullOrEmpty(Created_By)) { insertCommand.Parameters.AddWithValue("@Created_By", Created_By); } else { insertCommand.Parameters.AddWithValue("@Created_By", DBNull.Value); } insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); insertCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { logger.Error(ex.Message); return(false); } finally { connection.Close(); } }