public int validate_vendor_dal(vendor_registration_entity ObjBO)
{
try
{
SqlCommand cmd4 = new SqlCommand("validate_vendor", con);
cmd4.CommandType = CommandType.StoredProcedure;
cmd4.Parameters.AddWithValue("@Company_registration_number", ObjBO.Company_registration_number);
con.Open();
SqlDataReader rd = cmd4.ExecuteReader();
if (rd.HasRows)
{
flag = 1;
// con.Dispose();
}
else
{
flag = 0;
// con.Dispose();
}
return(flag);
}
catch (Exception ex)
{
throw ex;
}
}
public int Insert_Details_dal(vendor_registration_entity ObjBO)
{
SqlCommand cmd1 = new SqlCommand("get_countryid", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@country_name", ObjBO.Country_name);
cmd1.Parameters.AddWithValue("@state_name", ObjBO.State_name);
con.Open();
SqlDataReader rd = cmd1.ExecuteReader();
if (rd.HasRows)
{
rd.Read();
cid = (string)rd["country_id"];
}
ObjBO.Country_id = cid;
// rd.Close();
con.Close();
SqlCommand cmd = new SqlCommand("insert_vendor_details", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@company_registration_number", ObjBO.Company_registration_number);
cmd.Parameters.AddWithValue("@vendor_name", ObjBO.Vendor_name);
cmd.Parameters.AddWithValue("@vendor_type", ObjBO.Vendor_type);
cmd.Parameters.AddWithValue("@contact_number", ObjBO.Contact_number);
cmd.Parameters.AddWithValue("@Email_id", ObjBO.Email_id1);
cmd.Parameters.AddWithValue("@website", ObjBO.Website);
cmd.Parameters.AddWithValue("@address_details", ObjBO.Address_details);
cmd.Parameters.AddWithValue("@country_id", ObjBO.Country_id);
cmd.Parameters.AddWithValue("@certificate_issue_date", ObjBO.Certificate_issue_date);
cmd.Parameters.AddWithValue("@employees_count", ObjBO.Employees_count);
cmd.Parameters.AddWithValue("@customer_count", ObjBO.Customer_count);
cmd.Parameters.AddWithValue("@Year_of_establishment", ObjBO.Year_of_establishment);
cmd.Parameters.AddWithValue("@certificate_id", ObjBO.Certificate_id);
cmd.Parameters.AddWithValue("@certificate_validity_date", ObjBO.Certificate_validity_date);
// con.Dispose();
con.Open();
int result = cmd.ExecuteNonQuery();
cmd.Dispose();
// con.Dispose();
return(result);
}
public SqlDataReader vendor_details_dal(vendor_registration_entity ObjBO)
{
SqlCommand cmd3 = new SqlCommand("get_vendor_details", con);
cmd3.CommandType = CommandType.StoredProcedure;
cmd3.Parameters.AddWithValue("@company_registration_number", ObjBO.Company_registration_number);
con.Open();
SqlDataReader rd1 = cmd3.ExecuteReader();
// con.Dispose();
return(rd1);
}
public int validate_vendor_bal(vendor_registration_entity objjbl)
{
try
{
objdal.databaseconnection();
return(objdal.validate_vendor_dal(objjbl));
}
catch (Exception ex)
{
throw ex;
}
}
public SqlDataReader vendor_details(vendor_registration_entity objjbl)
{
try
{
objdal.databaseconnection();
return(objdal.vendor_details_dal(objjbl));
}
catch (Exception ex)
{
throw ex;
}
}
public int insert(vendor_registration_entity objbl)
{
try
{
objdal.databaseconnection();
return(objdal.Insert_Details_dal(objbl));
}
catch
{
throw;
}
}
public DataSet getstatelist(vendor_registration_entity objbl)
{
try
{
objdal.databaseconnection();
return(objdal.getstate_dal(objbl));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet getstate_dal(vendor_registration_entity ObjBO)
{
SqlCommand cmd2 = new SqlCommand("autopopulation_state", con);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@country_name", ObjBO.Country_name);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd2);
DataSet ds = new DataSet();
da.Fill(ds);
// con.Dispose();
return(ds);
}