public static void UpdateRestrictione(string data, string restriction, string roomType)
{
string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
var giorno = DateTime.Parse(data);
if (!string.IsNullOrEmpty(restriction))
{
switch (roomType)
{
case "camera":
DataBaseUtilities.InsertCameraMatrimonialeAvailability(connectionString, giorno, null, null, int.Parse(restriction));
break;
case "app1":
DataBaseUtilities.InsertApaprtamento1Availability(connectionString, giorno, null, null, int.Parse(restriction));
break;
case "app2":
DataBaseUtilities.InsertAppartamento2Availability(connectionString, giorno, null, null, int.Parse(restriction));
break;
case "Tripla":
DataBaseUtilities.InsertCameraTriplaAvailability(connectionString, giorno, null, null, int.Parse(restriction));
break;
case "Quadrupla":
DataBaseUtilities.InsertCameraQuadruplaAvailability(connectionString, giorno, null, null, int.Parse(restriction));
break;
}
}
}
public static void UpdatePrice(string data, string price, string roomType)
{
string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
var giorno = DateTime.Parse(data);
if (!string.IsNullOrEmpty(price))
{
if (price.Contains("€"))
{
price = price.Split('€')[0];
}
switch (roomType)
{
case "camera":
DataBaseUtilities.InsertCameraMatrimonialeAvailability(connectionString, giorno, null, long.Parse(price), null);
break;
case "app1":
DataBaseUtilities.InsertApaprtamento1Availability(connectionString, giorno, null, long.Parse(price), null);
break;
case "app2":
DataBaseUtilities.InsertAppartamento2Availability(connectionString, giorno, null, long.Parse(price), null);
break;
case "Tripla":
DataBaseUtilities.InsertCameraTriplaAvailability(connectionString, giorno, null, long.Parse(price), null);
break;
case "Quadrupla":
DataBaseUtilities.InsertCameraQuadruplaAvailability(connectionString, giorno, null, long.Parse(price), null);
break;
}
}
}