public void MakeReservation(string userPersistentId, string roomUuid, string start, string end, string mpk, string katering, string roomName, string desc, string isrec, string recrule,
string kateringDodatkoweInfo, string kateringDostawa, string iloscOsob)
{
string wsurl = Helpers.GetSetting("CAwsurl", false);
//string cs = Helpers.GetSetting("sdmdb", true);
try
{
string pcat = GetRoomReservationPersistentId();
if (!string.IsNullOrEmpty(pcat))
{
SDMWebServiceHelper helper = new SDMWebServiceHelper(wsurl, Helpers.GetSetting("CALogin", false), Helpers.GetSetting("CAPassword", true));
helper.CreateRequest(pcat, userPersistentId, roomUuid, start, end, mpk, katering, roomName, desc, isrec, recrule, kateringDodatkoweInfo, kateringDostawa, iloscOsob);
}
else
{
throw new Exception("Nie znaleziono persistent_id dla Administracja.Rezerwacja sali");
}
}
catch (Exception ex)
{
Context.Response.StatusCode = (int)HttpStatusCode.InternalServerError;
Context.Response.StatusDescription = ex.Message;
}
}
public void CancelReservation(string persid, string cancelAll)
{
string wsurl = Helpers.GetSetting("CAwsurl", false);
string rescode = string.Empty;
string cs = Helpers.GetSetting("sdmdb", true);
using (SqlConnection connection = new SqlConnection(cs))
{
connection.Open();
string cmd = "select persid from usp_resolution_code where del = 0 and sym like 'Anulowane przez u_ytkownika'";
SqlCommand sqlCommand = new SqlCommand(cmd, connection);
object o = sqlCommand.ExecuteScalar();
if (o != null)
{
rescode = o.ToString();
}
}
SDMWebServiceHelper helper = new SDMWebServiceHelper(wsurl, Helpers.GetSetting("CALogin", false), Helpers.GetSetting("CAPassword", true));
helper.CancelReservation(persid, rescode, cancelAll);
}