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