public Donor_Product Insert(Donor_Product id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_DONOR_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DonorID", id.DonorID); cmd.Parameters.AddWithValue("@ProductID", id.ProductID); cmd.Parameters.AddWithValue("@quantity", id.quantity); cmd.Parameters.AddWithValue("@other_info", id.other_info); cmd.Parameters.AddWithValue("@Product_rec_date", id.Product_rec_date); cmd.Parameters.AddWithValue("@AmountOfProdDonated", id.AmountOfProdDonated); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_DONOR_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DonorID", id.DonorID); cmd.Parameters.AddWithValue("@ProductID", id.ProductID); cmd.Parameters.AddWithValue("@quantity", id.quantity); cmd.Parameters.AddWithValue("@other_info", id.other_info); cmd.Parameters.AddWithValue("@Product_rec_date", id.Product_rec_date); cmd.Parameters.AddWithValue("@AmountOfProdDonated", id.AmountOfProdDonated); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.DonorProductID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public Donor_Product Select(int id) { Donor_Product Donor_Product = new Donor_Product(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_DONOR_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DonorProductID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Donor_Product.DonorProductID = rdr.GetInt32(0); } else { Donor_Product.DonorProductID = 0; } if (!rdr.IsDBNull(1)) { Donor_Product.DonorID = rdr.GetInt32(1); } else { Donor_Product.DonorID = 0; } if (!rdr.IsDBNull(2)) { Donor_Product.ProductID = rdr.GetInt32(2); } else { Donor_Product.ProductID = 0; } if (!rdr.IsDBNull(3)) { Donor_Product.quantity = rdr.GetInt32(3); } else { Donor_Product.quantity = 0; } if (!rdr.IsDBNull(4)) { Donor_Product.other_info = rdr.GetString(4); } else { Donor_Product.other_info = " "; } if (!rdr.IsDBNull(5)) { Donor_Product.Product_rec_date = rdr.GetDateTime(5); } else { Donor_Product.Product_rec_date = DateTime.Now; } if (!rdr.IsDBNull(6)) { Donor_Product.AmountOfProdDonated = rdr.GetString(6); } else { Donor_Product.AmountOfProdDonated = " "; } } else { Donor_Product.SetColumnDefaults(); } } catch (Exception ex) { Donor_Product.SetColumnDefaults(); return(Donor_Product); } finally { con.Close(); } return(Donor_Product); }
public Donor_Product Insert(Donor_Product id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_DONOR_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DonorID", id.DonorID); cmd.Parameters.AddWithValue("@ProductID", id.ProductID); cmd.Parameters.AddWithValue("@quantity", id.quantity); cmd.Parameters.AddWithValue("@other_info", id.other_info); cmd.Parameters.AddWithValue("@Product_rec_date", id.Product_rec_date); cmd.Parameters.AddWithValue("@AmountOfProdDonated", id.AmountOfProdDonated); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_DONOR_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DonorID", id.DonorID); cmd.Parameters.AddWithValue("@ProductID", id.ProductID); cmd.Parameters.AddWithValue("@quantity", id.quantity); cmd.Parameters.AddWithValue("@other_info", id.other_info); cmd.Parameters.AddWithValue("@Product_rec_date", id.Product_rec_date); cmd.Parameters.AddWithValue("@AmountOfProdDonated", id.AmountOfProdDonated); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.DonorProductID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
public Donor_Product Select(int id) { Donor_Product Donor_Product = new Donor_Product(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_DONOR_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DonorProductID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Donor_Product.DonorProductID = rdr.GetInt32(0); } else { Donor_Product.DonorProductID = 0; } if (!rdr.IsDBNull(1)) { Donor_Product.DonorID = rdr.GetInt32(1); } else { Donor_Product.DonorID = 0; } if (!rdr.IsDBNull(2)) { Donor_Product.ProductID = rdr.GetInt32(2); } else { Donor_Product.ProductID = 0; } if (!rdr.IsDBNull(3)) { Donor_Product.quantity = rdr.GetInt32(3); } else { Donor_Product.quantity = 0; } if (!rdr.IsDBNull(4)) { Donor_Product.other_info = rdr.GetString(4); } else { Donor_Product.other_info = " "; } if (!rdr.IsDBNull(5)) { Donor_Product.Product_rec_date = rdr.GetDateTime(5); } else { Donor_Product.Product_rec_date = DateTime.Now; } if (!rdr.IsDBNull(6)) { Donor_Product.AmountOfProdDonated = rdr.GetString(6); } else { Donor_Product.AmountOfProdDonated = " "; } } else { Donor_Product.SetColumnDefaults(); } } catch (Exception ex) { Donor_Product.SetColumnDefaults(); return Donor_Product; } finally { con.Close(); } return Donor_Product; }