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(); }