Beispiel #1
0
        public static string InsertEnterpriseAdress(EnterpriseUserAdress user)
        {
            //validations will add


            FUser.InsertEnterpriseAdress(user);
            return("");
        }
Beispiel #2
0
        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();
        }