public object CreateNewStore([FromBody] StoreRequestDTO storeData) { Logger.Info(Request.RequestUri + " || Method: " + Request.Method, Request.Headers.ToString(), JsonConvert.SerializeObject(storeData), Level.INFO); ResponseDTO Response = new ResponseDTO(); ErrorDTO ErrorResponse = new ErrorDTO(); Response = StoreBUS.AddOrUpdateStore(storeData); return(Response); }
public static ResponseDTO AddOrUpdateStore(StoreRequestDTO StoreData) { ErrorDTO ErrorResponse = new ErrorDTO(); ResponseDTO Response = new ResponseDTO(); SqlConnection con = connection.loadDB(); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = StoreData.id == null ? "AddStoreData" : "UpdateStoreData"; if (StoreData.id != null) { SqlParameter param1 = new SqlParameter(); param1.ParameterName = "ID"; param1.SqlDbType = SqlDbType.Int; param1.Value = StoreData.id; cmd.Parameters.Add(param1); } SqlParameter param6 = new SqlParameter(); param6.ParameterName = "WardCode"; param6.SqlDbType = SqlDbType.NVarChar; param6.Value = StoreData.ward_code != "" ? StoreData.ward_code : ""; cmd.Parameters.Add(param6); SqlParameter param2 = new SqlParameter(); param2.ParameterName = "Code"; param2.SqlDbType = SqlDbType.NVarChar; param2.Value = StoreData.code != "" ? StoreData.code : ""; cmd.Parameters.Add(param2); SqlParameter param10 = new SqlParameter(); param10.ParameterName = "Adress"; param10.SqlDbType = SqlDbType.NVarChar; param10.Value = StoreData.adress != "" ? StoreData.adress : ""; cmd.Parameters.Add(param10); SqlParameter param3 = new SqlParameter(); param3.ParameterName = "Name"; param3.SqlDbType = SqlDbType.NVarChar; param3.Value = StoreData.name != "" ? StoreData.name : ""; cmd.Parameters.Add(param3); SqlParameter param4 = new SqlParameter(); param4.ParameterName = "Information"; param4.SqlDbType = SqlDbType.NVarChar; param4.Value = StoreData.information != "" ? StoreData.information : ""; cmd.Parameters.Add(param4); SqlParameter param5 = new SqlParameter(); param5.ParameterName = "Latitude"; param5.SqlDbType = SqlDbType.NVarChar; param5.Value = StoreData.latitude != "" ? StoreData.latitude : ""; cmd.Parameters.Add(param5); SqlParameter param7 = new SqlParameter(); param7.ParameterName = "Longitude"; param7.SqlDbType = SqlDbType.NVarChar; param7.Value = StoreData.longitude != "" ? StoreData.longitude : ""; cmd.Parameters.Add(param7); SqlParameter param8 = new SqlParameter(); param8.ParameterName = "Note"; param8.SqlDbType = SqlDbType.NChar; param8.Value = StoreData.note != "" ? StoreData.note : ""; cmd.Parameters.Add(param8); SqlParameter param9 = new SqlParameter(); param9.ParameterName = "Type"; param9.SqlDbType = SqlDbType.NChar; param9.Value = StoreData.type != "" ? StoreData.type : ""; cmd.Parameters.Add(param9); SqlParameter param11 = new SqlParameter(); param11.ParameterName = "CategoryCode"; param11.SqlDbType = SqlDbType.NChar; param11.Value = StoreData.category_code != "" ? StoreData.category_code : ""; cmd.Parameters.Add(param11); try { cmd.ExecuteNonQuery(); Response.Data = StoreData.id == null ? "CREATED" : "UPDATED"; } catch (Exception ex) { ErrorResponse.Code = 400; ErrorResponse.Message = ex.ToString(); Response.Error = ErrorResponse; } finally { con.Close(); } return(Response); }