void SendResultInfoAsJson(CreateStoreResponse res)
{
string strJson = JsonConvert.SerializeObject(res);
Response.ContentType = "application/json; charset=utf-8";
Response.AppendHeader("Access-Control-Allow-Origin", "*");
Response.Write(strJson);
Response.End();
}
public static CreateStoreResponse Unmarshall(UnmarshallerContext context)
{
CreateStoreResponse createStoreResponse = new CreateStoreResponse();
createStoreResponse.HttpResponse = context.HttpResponse;
createStoreResponse.RequestId = context.StringValue("CreateStore.RequestId");
createStoreResponse.Success = context.BooleanValue("CreateStore.Success");
createStoreResponse.Message = context.StringValue("CreateStore.Message");
createStoreResponse.ErrorCode = context.StringValue("CreateStore.ErrorCode");
createStoreResponse.StoreId = context.StringValue("CreateStore.StoreId");
return(createStoreResponse);
}
public static CreateStoreResponse Unmarshall(UnmarshallerContext _ctx)
{
CreateStoreResponse createStoreResponse = new CreateStoreResponse();
createStoreResponse.HttpResponse = _ctx.HttpResponse;
createStoreResponse.ErrorMessage = _ctx.StringValue("CreateStore.ErrorMessage");
createStoreResponse.ErrorCode = _ctx.StringValue("CreateStore.ErrorCode");
createStoreResponse.Message = _ctx.StringValue("CreateStore.Message");
createStoreResponse.StoreId = _ctx.StringValue("CreateStore.StoreId");
createStoreResponse.DynamicCode = _ctx.StringValue("CreateStore.DynamicCode");
createStoreResponse.Code = _ctx.StringValue("CreateStore.Code");
createStoreResponse.DynamicMessage = _ctx.StringValue("CreateStore.DynamicMessage");
createStoreResponse.RequestId = _ctx.StringValue("CreateStore.RequestId");
createStoreResponse.Success = _ctx.BooleanValue("CreateStore.Success");
return(createStoreResponse);
}
/// <summary>
/// Create a new store on the Plot back-end server
/// </summary>
/// <param name="store">Entity containing the v1 data of the store to create</param>
/// <returns>ID (string) of the created v1 store</returns>
public string CreateStore(CreateStoreV1 store)
{
const string FunctionAdmin = "createPlace";
const string Function = "place";
store.Check();
CreateStoreRequest request = new CreateStoreRequest()
{
accountId = this.accountId,
name = store.Name,
address = store.Address,
postalCode = store.PostalCode,
city = store.City,
country = store.Country.ToLower(),
location = new CreateStoreRequest.StoreLocation()
{
latitude = store.Latitude,
longitude = store.Longitude
}
};
HttpWebRequest webRequest = GetWebRequestAndSendRequest("POST", isAdminConnection ? FunctionAdmin : Function, request);
CreateStoreResponse response = GetJSONresponse <CreateStoreResponse>(webRequest);
// check the result codes:
response.Check();
string ret = response.Result;
if (string.IsNullOrWhiteSpace(ret))
{
throw new Exception("No ID returned.");
}
return(ret);
}
protected void Page_Load(object sender, EventArgs e)
{
CreateStoreRequest req;
CreateStoreResponse res = new CreateStoreResponse();
res.error = String.Empty;
// 1. Deserialize the incoming Json.
try
{
req = GetRequestInfo();
}
catch (Exception ex)
{
res.error = ex.Message.ToString();
// Return the results as Json.
SendResultInfoAsJson(res);
return;
}
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
try
{
connection.Open();
string sql = "INSERT INTO Store (StoreName, StoreNumber, Address, State, City, Zip) VALUES (@StoreName, @StoreNumber, @Address, @State, @City, @Zip)";
SqlCommand createStore = new SqlCommand(sql, connection);
createStore.Parameters.Add("@StoreName", SqlDbType.NVarChar);
createStore.Parameters.Add("@StoreNumber", SqlDbType.NVarChar);
createStore.Parameters.Add("@Address", SqlDbType.NVarChar);
createStore.Parameters.Add("@State", SqlDbType.NVarChar);
createStore.Parameters.Add("@City", SqlDbType.NVarChar);
createStore.Parameters.Add("@Zip", SqlDbType.NVarChar);
createStore.Parameters["@StoreName"].Value = req.StoreName;
createStore.Parameters["@StoreNumber"].Value = req.StoreNumber;
createStore.Parameters["@Address"].Value = req.Address;
createStore.Parameters["@State"].Value = req.State;
createStore.Parameters["@City"].Value = req.City;
createStore.Parameters["@Zip"].Value = req.Zip;
createStore.ExecuteNonQuery();
string getStoreInfo = "SELECT StoreID FROM Store WHERE StoreNumber = @StoreNumber AND StoreName = @StoreName AND Address = @Address AND State = @State AND City = @City AND Zip = @Zip";
SqlCommand getStoreInfoCommand = new SqlCommand(getStoreInfo, connection);
getStoreInfoCommand.Parameters.Add("@StoreName", SqlDbType.NVarChar);
getStoreInfoCommand.Parameters.Add("@StoreNumber", SqlDbType.NVarChar);
getStoreInfoCommand.Parameters.Add("@Address", SqlDbType.NVarChar);
getStoreInfoCommand.Parameters.Add("@State", SqlDbType.NVarChar);
getStoreInfoCommand.Parameters.Add("@City", SqlDbType.NVarChar);
getStoreInfoCommand.Parameters.Add("@Zip", SqlDbType.NVarChar);
getStoreInfoCommand.Parameters["@StoreName"].Value = req.StoreName;
getStoreInfoCommand.Parameters["@StoreNumber"].Value = req.StoreNumber;
getStoreInfoCommand.Parameters["@Address"].Value = req.Address;
getStoreInfoCommand.Parameters["@State"].Value = req.State;
getStoreInfoCommand.Parameters["@City"].Value = req.City;
getStoreInfoCommand.Parameters["@Zip"].Value = req.Zip;
SqlDataReader reader = getStoreInfoCommand.ExecuteReader();
if (!reader.HasRows)
{
res.error = "Store not found";
SendResultInfoAsJson(res);
return;
}
else
if (reader.Read())
{
res.StoreID = Convert.ToInt32(reader["StoreID"]);
}
}
catch (Exception ex)
{
res.error = ex.Message.ToString();
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
// Return the results as Json.
SendResultInfoAsJson(res);
}
