public static string InsertEnterpriseAdress(EnterpriseUserAdress user) { //validations will add FUser.InsertEnterpriseAdress(user); return(""); }
public static void InsertEnterpriseAdress(EnterpriseUserAdress user) { MySqlCommand cmd = new MySqlCommand("insert_enterprise_adress", Connection.Con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new MySqlParameter("Pcity", user.city)); cmd.Parameters.Add(new MySqlParameter("Pdistrict", user.district)); cmd.Parameters.Add(new MySqlParameter("Pneighbourhood", user.neighbourhood)); cmd.Parameters.Add(new MySqlParameter("Pbuilding_name", user.building_name)); cmd.Parameters.Add(new MySqlParameter("Pzip_code", user.zip_code)); cmd.Connection.Open(); var result = cmd.ExecuteNonQuery(); cmd.Connection.Close(); }