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