Exemple #1
0
 public static bool Update(MB_Pipeline.Controllers.Models.Contact contact)
 {
     using (SqlCommand cmd = new SqlCommand())
     {
         cmd.CommandType = System.Data.CommandType.StoredProcedure;
         cmd.CommandText = "[dbo].[usp_UpdateContact]";
         cmd.Parameters.Add("id", System.Data.SqlDbType.Int).Value = contact.id;
         cmd.Parameters.Add("title", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(contact.title) ? contact.title : DBNull.Value.ToString());
         cmd.Parameters.Add("name", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(contact.name) ? contact.name : DBNull.Value.ToString());
         cmd.Parameters.Add("address", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(contact.address) ? contact.address : DBNull.Value.ToString());
         cmd.Parameters.Add("address_line2", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(contact.address_line2) ? contact.address_line2 : DBNull.Value.ToString());
         cmd.Parameters.Add("state", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(contact.state) ? contact.state : DBNull.Value.ToString());
         cmd.Parameters.Add("zip_code", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(contact.zip_code) ? contact.zip_code : DBNull.Value.ToString());
         cmd.Parameters.Add("email", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(contact.email) ? contact.email : DBNull.Value.ToString());
         cmd.Parameters.Add("country", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(contact.country) ? contact.country : DBNull.Value.ToString());
         cmd.Parameters.Add("phone_number", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(contact.phone_number) ? contact.phone_number : DBNull.Value.ToString());
         cmd.Parameters.Add("secondary_number", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(contact.secondary_number) ? contact.secondary_number : DBNull.Value.ToString());
         cmd.Parameters.Add("city", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(contact.city) ? contact.city : DBNull.Value.ToString());
         if (Helper.SqlHelper.ExecuteQuery(cmd))
         {
             return true;
         }
         return false;
     }
 }
Exemple #2
0
        public static bool New(MB_Pipeline.Controllers.Models.Location location, int account)
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.CommandText = "[dbo].[usp_NewAccountLocation]";
                cmd.Parameters.Add("account", System.Data.SqlDbType.Int).Value = account;
                cmd.Parameters.Add("address", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.address) ? location.address : DBNull.Value.ToString());
                cmd.Parameters.Add("address_line2", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.address_line2) ? location.address_line2 : DBNull.Value.ToString());
                cmd.Parameters.Add("state", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.state) ? location.state : DBNull.Value.ToString());
                cmd.Parameters.Add("zip_code", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.zip_code) ? location.zip_code : DBNull.Value.ToString());
                //cmd.Parameters.Add("country", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.country) ? location.country : DBNull.Value.ToString());
                cmd.Parameters.Add("city", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.city) ? location.city : DBNull.Value.ToString());
                cmd.Parameters.Add("location_type", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.location_type) ? location.location_type : DBNull.Value.ToString());
                cmd.Parameters.Add("role", System.Data.SqlDbType.Int).Value = Helper.Sessions.GetUserFromSession().ID;

                var l = Helper.SqlHelper.ReadQuery<int>(cmd);
                if (l.Count > 0)
                {
                    location.id = l[0];
                    Helper.MapsHelper.UpdateCords(location);
                    return true;
                }
                return false;
            }
        }
 public static bool UpdateCords(MB_Pipeline.Controllers.Models.Location location)
 {
     var address = location.address.Replace(' ', '+') + ',' + location.city.Replace(' ', '+') + ',' + location.state.Replace(' ', '+') + ' ' + location.zip_code;
     var result = get_coords_service(address);
     var obj = JsonConvert.DeserializeObject<GoogleGeoCodeResponse>(result);
     var r = false;
     using (SqlCommand cmd = new SqlCommand())
     {
         cmd.CommandType = System.Data.CommandType.StoredProcedure;
         cmd.CommandText = "[dbo].[usp_updateAddGeoCodes]";
         cmd.Parameters.Add("location_id", System.Data.SqlDbType.Int).Value = location.id;
         cmd.Parameters.Add("lat", System.Data.SqlDbType.NVarChar).Value = obj.results[0].geometry.location.lat;
         cmd.Parameters.Add("long", System.Data.SqlDbType.NVarChar).Value = obj.results[0].geometry.location.lng;
         r = MB_Pipeline.Helper.SqlHelper.ExecuteQuery(cmd);
     }
     return r;
 }
Exemple #4
0
 public static bool Update(MB_Pipeline.Controllers.Models.Location location)
 {
     using (SqlCommand cmd = new SqlCommand())
     {
         cmd.CommandType = System.Data.CommandType.StoredProcedure;
         cmd.CommandText = "[dbo].[usp_UpdateLocation]";
         cmd.Parameters.Add("id", System.Data.SqlDbType.Int).Value = location.id;
         cmd.Parameters.Add("name", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.name) ? location.name : DBNull.Value.ToString());
         cmd.Parameters.Add("address", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.address) ? location.address : DBNull.Value.ToString());
         cmd.Parameters.Add("address_line2", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.address_line2) ? location.address_line2 : DBNull.Value.ToString());
         cmd.Parameters.Add("state", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.state) ? location.state : DBNull.Value.ToString());
         cmd.Parameters.Add("zip_code", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.zip_code) ? location.zip_code : DBNull.Value.ToString());
         //cmd.Parameters.Add("country", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.country) ? location.country : DBNull.Value.ToString());
         cmd.Parameters.Add("city", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.city) ? location.city : DBNull.Value.ToString());
         //cmd.Parameters.Add("location_type", System.Data.SqlDbType.NVarChar).Value = (!string.IsNullOrEmpty(location.location_type) ? location.location_type : DBNull.Value.ToString());
         //cmd.Parameters.Add("role", System.Data.SqlDbType.Int).Value = Helper.Sessions.GetUserFromSession().ID;
         if (Helper.SqlHelper.ExecuteQuery(cmd))
         {
             Helper.MapsHelper.UpdateCords(location);
             return true;
         }
         return false;
     }
 }