public int updatealldal(vendor_updation_entity obj1)
{
try
{
con.Open();
SqlCommand cmd1 = new SqlCommand("updatevendor2", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@vendor_id", obj1.Vendor_id);
cmd1.Parameters.AddWithValue("@contact_number", obj1.Contact_number);
cmd1.Parameters.AddWithValue("@Email_id", obj1.Email_id1);
cmd1.Parameters.AddWithValue("@website", obj1.Website);
cmd1.Parameters.AddWithValue("@address_details", obj1.Address_details);
cmd1.Parameters.AddWithValue("@country_id", obj1.Country_id);
cmd1.Parameters.AddWithValue("@certificate_issue_date", obj1.Certificate_issue_date);
cmd1.Parameters.AddWithValue("@employees_count", obj1.Employees_count);
cmd1.Parameters.AddWithValue("@customer_count", obj1.Customer_count);
cmd1.Parameters.AddWithValue("@certificate_validity_date", obj1.Certificate_validity_date);
int r = cmd1.ExecuteNonQuery();
//con.Dispose();
return(r);
}
catch (Exception ex)
{
throw ex;
}
}
public int bal_update_country_in_vendor_table(vendor_updation_entity obj1)
{
try
{
vendor_updation_dal dal3 = new vendor_updation_dal();
dal3.CreateCon();
return(dal3.dal_update_country_in_vendor_table(obj1));
}
catch (Exception ex)
{
throw ex;
}
}
public SqlDataReader get_country_id_bl(vendor_updation_entity obj1)
{
try
{
vendor_updation_dal dal2 = new vendor_updation_dal();
dal2.CreateCon();
return(dal2.get_country_id(obj1));
}
catch (Exception ex)
{
throw ex;
}
}
public SqlDataReader insert1(vendor_updation_entity obj1)
{
try
{
vendor_updation_dal vendor_dal = new vendor_updation_dal();
vendor_dal.CreateCon();
return(vendor_dal.insert(obj1));
}
catch (Exception ex)
{
throw ex;
}
}
public int updateallbal(vendor_updation_entity obj1)
{
try
{
vendor_updation_dal dal1 = new vendor_updation_dal();
dal1.CreateCon();
return(dal1.updatealldal(obj1));
//return dal1.update1(obj1);
}
catch (Exception ex)
{
throw ex;
}
}
public SqlDataReader insert(vendor_updation_entity obj1)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("vendrdetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@vendor_id", obj1.vendor_id);
SqlDataReader rd;
rd = cmd.ExecuteReader();
// con.Dispose();
return(rd);
}
catch (Exception ex)
{
throw ex;
}
}
public int dal_update_country_in_vendor_table(vendor_updation_entity obj1)
{
try
{
con.Open();
SqlCommand cmd4 = new SqlCommand("country_id1", con);
cmd4.CommandType = CommandType.StoredProcedure;
cmd4.Parameters.AddWithValue("@country_id", obj1.Country_id);
cmd4.Parameters.AddWithValue("@vendor_id", obj1.vendor_id);
int f = cmd4.ExecuteNonQuery();
//con.Dispose();
return(f);
}
catch (Exception ex)
{
throw ex;
}
}
public SqlDataReader get_country_id(vendor_updation_entity obj1)
{
try
{
con.Open();
SqlCommand cmd3 = new SqlCommand("get_country_id3", con);
cmd3.CommandType = CommandType.StoredProcedure;
cmd3.Parameters.AddWithValue("@country_name", obj1.Country_name);
cmd3.Parameters.AddWithValue("@state_name", obj1.State_name);
SqlDataReader rd3 = cmd3.ExecuteReader();
//con.Dispose();
return(rd3);
}
catch (Exception ex)
{
throw ex;
}
}