public vendor Select(int id)
{
vendor vendor = new vendor();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_VENDOR", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@vendor_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
vendor.vendor_id = rdr.GetInt32(0);
}
else
{
vendor.vendor_id = 0;
}
if (!rdr.IsDBNull(1))
{
vendor.vendor_name = rdr.GetString(1);
}
else
{
vendor.vendor_name = " ";
}
if (!rdr.IsDBNull(2))
{
vendor.phone_num = rdr.GetString(2);
}
else
{
vendor.phone_num = " ";
}
if (!rdr.IsDBNull(3))
{
vendor.email = rdr.GetString(3);
}
else
{
vendor.email = " ";
}
if (!rdr.IsDBNull(4))
{
vendor.address_id = rdr.GetInt32(4);
}
else
{
vendor.address_id = 0;
}
if (!rdr.IsDBNull(5))
{
vendor.Vendor_address2 = rdr.GetInt32(5);
}
else
{
vendor.Vendor_address2 = 0;
}
if (!rdr.IsDBNull(6))
{
vendor.vendor_job_assign = rdr.GetString(6);
}
else
{
vendor.vendor_job_assign = " ";
}
if (!rdr.IsDBNull(7))
{
vendor.vendor_start_date = rdr.GetDateTime(7);
}
else
{
vendor.vendor_start_date = DateTime.Now;
}
if (!rdr.IsDBNull(8))
{
vendor.vendor_end_date = rdr.GetDateTime(8);
}
else
{
vendor.vendor_end_date = DateTime.Now;
}
if (!rdr.IsDBNull(9))
{
vendor.vendor_meth_of_contact = rdr.GetString(9);
}
else
{
vendor.vendor_meth_of_contact = " ";
}
if (!rdr.IsDBNull(10))
{
vendor.vendor_status = rdr.GetString(10);
}
else
{
vendor.vendor_status = " ";
}
if (!rdr.IsDBNull(11))
{
vendor.vendor_meth_of_pay = rdr.GetString(11);
}
else
{
vendor.vendor_meth_of_pay = " ";
}
if (!rdr.IsDBNull(12))
{
vendor.vendor_type = rdr.GetString(12);
}
else
{
vendor.vendor_type = " ";
}
if (!rdr.IsDBNull(13))
{
vendor.vendor_comments = rdr.GetString(13);
}
else
{
vendor.vendor_comments = " ";
}
if (!rdr.IsDBNull(14))
{
vendor.primary_fName = rdr.GetString(14);
}
else
{
vendor.primary_fName = " ";
}
if (!rdr.IsDBNull(15))
{
vendor.primary_lName = rdr.GetString(15);
}
else
{
vendor.primary_lName = " ";
}
if (!rdr.IsDBNull(16))
{
vendor.primary_phone = rdr.GetString(16);
}
else
{
vendor.primary_phone = " ";
}
if (!rdr.IsDBNull(17))
{
vendor.sec_fName = rdr.GetString(17);
}
else
{
vendor.sec_fName = " ";
}
if (!rdr.IsDBNull(18))
{
vendor.sec_lName = rdr.GetString(18);
}
else
{
vendor.sec_lName = " ";
}
if (!rdr.IsDBNull(19))
{
vendor.sec_phone = rdr.GetString(19);
}
else
{
vendor.sec_phone = " ";
}
}
else
{
vendor.SetColumnDefaults();
}
}
catch (Exception ex)
{
vendor.SetColumnDefaults();
return vendor;
}
finally
{
con.Close();
}
return vendor;
}
public vendor Insert(vendor id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_VENDOR", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@vendor_name", id.vendor_name);
cmd.Parameters.AddWithValue("@phone_num", id.phone_num);
cmd.Parameters.AddWithValue("@email", id.email);
cmd.Parameters.AddWithValue("@address_id", id.address_id);
cmd.Parameters.AddWithValue("@Vendor_address2", id.Vendor_address2);
cmd.Parameters.AddWithValue("@vendor_job_assign", id.vendor_job_assign);
cmd.Parameters.AddWithValue("@vendor_start_date", id.vendor_start_date);
cmd.Parameters.AddWithValue("@vendor_end_date", id.vendor_end_date);
cmd.Parameters.AddWithValue("@vendor_meth_of_contact", id.vendor_meth_of_contact);
cmd.Parameters.AddWithValue("@vendor_status", id.vendor_status);
cmd.Parameters.AddWithValue("@vendor_meth_of_pay", id.vendor_meth_of_pay);
cmd.Parameters.AddWithValue("@vendor_type", id.vendor_type);
cmd.Parameters.AddWithValue("@vendor_comments", id.vendor_comments);
cmd.Parameters.AddWithValue("@primary_fName", id.primary_fName);
cmd.Parameters.AddWithValue("@primary_lName", id.primary_lName);
cmd.Parameters.AddWithValue("@primary_phone", id.primary_phone);
cmd.Parameters.AddWithValue("@sec_fName", id.sec_fName);
cmd.Parameters.AddWithValue("@sec_lName", id.sec_lName);
cmd.Parameters.AddWithValue("@sec_phone", id.sec_phone);
cmd.ExecuteReader();
con.Close();
con.Open();
cmd = new SqlCommand("SP_DMCS_GET_VENDOR", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@vendor_name", id.vendor_name);
cmd.Parameters.AddWithValue("@phone_num", id.phone_num);
cmd.Parameters.AddWithValue("@email", id.email);
cmd.Parameters.AddWithValue("@address_id", id.address_id);
cmd.Parameters.AddWithValue("@Vendor_address2", id.Vendor_address2);
cmd.Parameters.AddWithValue("@vendor_job_assign", id.vendor_job_assign);
cmd.Parameters.AddWithValue("@vendor_start_date", id.vendor_start_date);
cmd.Parameters.AddWithValue("@vendor_end_date", id.vendor_end_date);
cmd.Parameters.AddWithValue("@vendor_meth_of_contact", id.vendor_meth_of_contact);
cmd.Parameters.AddWithValue("@vendor_status", id.vendor_status);
cmd.Parameters.AddWithValue("@vendor_meth_of_pay", id.vendor_meth_of_pay);
cmd.Parameters.AddWithValue("@vendor_type", id.vendor_type);
cmd.Parameters.AddWithValue("@vendor_comments", id.vendor_comments);
cmd.Parameters.AddWithValue("@primary_fName", id.primary_fName);
cmd.Parameters.AddWithValue("@primary_lName", id.primary_lName);
cmd.Parameters.AddWithValue("@primary_phone", id.primary_phone);
cmd.Parameters.AddWithValue("@sec_fName", id.sec_fName);
cmd.Parameters.AddWithValue("@sec_lName", id.sec_lName);
cmd.Parameters.AddWithValue("@sec_phone", id.sec_phone);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
id.vendor_id = rdr.GetInt32(0);
}
}
catch (Exception ex)
{
id.SetColumnDefaults();
}
finally
{
con.Close();
}
return(id);
}
public vendor Insert(vendor id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_VENDOR", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@vendor_name", id.vendor_name);
cmd.Parameters.AddWithValue("@phone_num", id.phone_num);
cmd.Parameters.AddWithValue("@email", id.email);
cmd.Parameters.AddWithValue("@address_id", id.address_id);
cmd.Parameters.AddWithValue("@Vendor_address2", id.Vendor_address2);
cmd.Parameters.AddWithValue("@vendor_job_assign", id.vendor_job_assign);
cmd.Parameters.AddWithValue("@vendor_start_date", id.vendor_start_date);
cmd.Parameters.AddWithValue("@vendor_end_date", id.vendor_end_date);
cmd.Parameters.AddWithValue("@vendor_meth_of_contact", id.vendor_meth_of_contact);
cmd.Parameters.AddWithValue("@vendor_status", id.vendor_status);
cmd.Parameters.AddWithValue("@vendor_meth_of_pay", id.vendor_meth_of_pay);
cmd.Parameters.AddWithValue("@vendor_type", id.vendor_type);
cmd.Parameters.AddWithValue("@vendor_comments", id.vendor_comments);
cmd.Parameters.AddWithValue("@primary_fName", id.primary_fName);
cmd.Parameters.AddWithValue("@primary_lName", id.primary_lName);
cmd.Parameters.AddWithValue("@primary_phone", id.primary_phone);
cmd.Parameters.AddWithValue("@sec_fName", id.sec_fName);
cmd.Parameters.AddWithValue("@sec_lName", id.sec_lName);
cmd.Parameters.AddWithValue("@sec_phone", id.sec_phone);
cmd.ExecuteReader();
con.Close();
con.Open();
cmd = new SqlCommand("SP_DMCS_GET_VENDOR", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@vendor_name", id.vendor_name);
cmd.Parameters.AddWithValue("@phone_num", id.phone_num);
cmd.Parameters.AddWithValue("@email", id.email);
cmd.Parameters.AddWithValue("@address_id", id.address_id);
cmd.Parameters.AddWithValue("@Vendor_address2", id.Vendor_address2);
cmd.Parameters.AddWithValue("@vendor_job_assign", id.vendor_job_assign);
cmd.Parameters.AddWithValue("@vendor_start_date", id.vendor_start_date);
cmd.Parameters.AddWithValue("@vendor_end_date", id.vendor_end_date);
cmd.Parameters.AddWithValue("@vendor_meth_of_contact", id.vendor_meth_of_contact);
cmd.Parameters.AddWithValue("@vendor_status", id.vendor_status);
cmd.Parameters.AddWithValue("@vendor_meth_of_pay", id.vendor_meth_of_pay);
cmd.Parameters.AddWithValue("@vendor_type", id.vendor_type);
cmd.Parameters.AddWithValue("@vendor_comments", id.vendor_comments);
cmd.Parameters.AddWithValue("@primary_fName", id.primary_fName);
cmd.Parameters.AddWithValue("@primary_lName", id.primary_lName);
cmd.Parameters.AddWithValue("@primary_phone", id.primary_phone);
cmd.Parameters.AddWithValue("@sec_fName", id.sec_fName);
cmd.Parameters.AddWithValue("@sec_lName", id.sec_lName);
cmd.Parameters.AddWithValue("@sec_phone", id.sec_phone);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
id.vendor_id = rdr.GetInt32(0);
}
}
catch (Exception ex)
{
id.SetColumnDefaults();
}
finally
{
con.Close();
}
return id;
}
public vendor Select(int id)
{
vendor vendor = new vendor();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_VENDOR", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@vendor_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
vendor.vendor_id = rdr.GetInt32(0);
}
else
{
vendor.vendor_id = 0;
}
if (!rdr.IsDBNull(1))
{
vendor.vendor_name = rdr.GetString(1);
}
else
{
vendor.vendor_name = " ";
}
if (!rdr.IsDBNull(2))
{
vendor.phone_num = rdr.GetString(2);
}
else
{
vendor.phone_num = " ";
}
if (!rdr.IsDBNull(3))
{
vendor.email = rdr.GetString(3);
}
else
{
vendor.email = " ";
}
if (!rdr.IsDBNull(4))
{
vendor.address_id = rdr.GetInt32(4);
}
else
{
vendor.address_id = 0;
}
if (!rdr.IsDBNull(5))
{
vendor.Vendor_address2 = rdr.GetInt32(5);
}
else
{
vendor.Vendor_address2 = 0;
}
if (!rdr.IsDBNull(6))
{
vendor.vendor_job_assign = rdr.GetString(6);
}
else
{
vendor.vendor_job_assign = " ";
}
if (!rdr.IsDBNull(7))
{
vendor.vendor_start_date = rdr.GetDateTime(7);
}
else
{
vendor.vendor_start_date = DateTime.Now;
}
if (!rdr.IsDBNull(8))
{
vendor.vendor_end_date = rdr.GetDateTime(8);
}
else
{
vendor.vendor_end_date = DateTime.Now;
}
if (!rdr.IsDBNull(9))
{
vendor.vendor_meth_of_contact = rdr.GetString(9);
}
else
{
vendor.vendor_meth_of_contact = " ";
}
if (!rdr.IsDBNull(10))
{
vendor.vendor_status = rdr.GetString(10);
}
else
{
vendor.vendor_status = " ";
}
if (!rdr.IsDBNull(11))
{
vendor.vendor_meth_of_pay = rdr.GetString(11);
}
else
{
vendor.vendor_meth_of_pay = " ";
}
if (!rdr.IsDBNull(12))
{
vendor.vendor_type = rdr.GetString(12);
}
else
{
vendor.vendor_type = " ";
}
if (!rdr.IsDBNull(13))
{
vendor.vendor_comments = rdr.GetString(13);
}
else
{
vendor.vendor_comments = " ";
}
if (!rdr.IsDBNull(14))
{
vendor.primary_fName = rdr.GetString(14);
}
else
{
vendor.primary_fName = " ";
}
if (!rdr.IsDBNull(15))
{
vendor.primary_lName = rdr.GetString(15);
}
else
{
vendor.primary_lName = " ";
}
if (!rdr.IsDBNull(16))
{
vendor.primary_phone = rdr.GetString(16);
}
else
{
vendor.primary_phone = " ";
}
if (!rdr.IsDBNull(17))
{
vendor.sec_fName = rdr.GetString(17);
}
else
{
vendor.sec_fName = " ";
}
if (!rdr.IsDBNull(18))
{
vendor.sec_lName = rdr.GetString(18);
}
else
{
vendor.sec_lName = " ";
}
if (!rdr.IsDBNull(19))
{
vendor.sec_phone = rdr.GetString(19);
}
else
{
vendor.sec_phone = " ";
}
}
else
{
vendor.SetColumnDefaults();
}
}
catch (Exception ex)
{
vendor.SetColumnDefaults();
return(vendor);
}
finally
{
con.Close();
}
return(vendor);
}
