public void updateServiceProvider(BALServiceProvider obj)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "spUpdateServiceProvider";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@serviceproviderid", obj.ServiceProviderID);
cmd.Parameters.AddWithValue("@serviceprovidername", obj.ServiceProviderName);
cmd.Parameters.AddWithValue("@address", obj.Address);
cmd.Parameters.AddWithValue("@cityid", obj.CityID);
cmd.Parameters.AddWithValue("@pincode", obj.Pincode);
cmd.Parameters.AddWithValue("@mobile", obj.Mobile);
cmd.Parameters.AddWithValue("@email", obj.Email);
cmd.Parameters.AddWithValue("@website", obj.Email);
cmd.Parameters.AddWithValue("@aboutserviceprovider", obj.AboutServiceProvider);
cmd.Parameters.AddWithValue("@serviceproviderimage", obj.ServiceProviderImage);
cmd.Parameters.AddWithValue("@serviceprovidertypeid", obj.ServiceProviderTypeID);
cmd.Parameters.AddWithValue("@loginid", obj.LoginID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void updateServiceProviderImage(BALServiceProvider obj)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "spUpdateServiceProviderImage";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@serviceproviderid", obj.ServiceProviderID);
cmd.Parameters.AddWithValue("@serviceproviderimage", obj.ServiceProviderImage);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
