private void Update()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update))
{
return;
}
if (!ValidateValues("update"))
{
return;
}
bool bActionCompleted;
AccomodationDTO oAccomData = null;
AccomodationMaster oAccomMaster = new AccomodationMaster();
oAccomData = MapControlsToObject();
bActionCompleted = oAccomMaster.Update(oAccomData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been updated successfully");
ClearControls();
lblStatus.Text = "Updated Successfully";
}
else
{
lblStatus.Text = "Error Occured while updating: Please refer to the error log.";
}
oAccomData = null;
oAccomMaster = null;
//lblStatus.Text = "Updated";
}
public bool updateStatus(AccomodationDTO oAccomData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_Activate";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomId", DbType.Int32, oAccomData.AccomodationId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsAccomodationMaster.updateStatus", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool Insert(AccomodationDTO oAccomData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Ins_AccomodationMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomodationTypeId", DbType.Int32, oAccomData.AccomodationTypeId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sAccomodation", DbType.String, oAccomData.AccomodationName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RegionId", DbType.Int32, oAccomData.RegionId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomInitial", DbType.String, oAccomData.AccomInitial);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomPolicyUrl", DbType.String, oAccomData.AccomPolicyUrl);
int accomId = Convert.ToInt32(oDB.ExecuteScalar(oDB.DbCmd));
}
catch (Exception exp)
{
GF.LogError("clsAccomodationMaster.Insert", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
private void Delete()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Delete))
{
return;
}
bool bActionCompleted;
string sMessage = "";
AccomodationDTO oAccomData = new AccomodationDTO();
AccomodationMaster oAccomMaster = new AccomodationMaster();
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit again.";
return;
}
oAccomData.AccomodationId = Id;
/*
*
* CHECK IF THE ACCOMODATION WHICH IS TO BE DELETED HAS ANY ASSOCIATED RECORDS...IF YES, MOVE OUT OF THE FUNCTION ELSE PROCEED
* IF THE OUTPUT OF sMessage IS "", THEN RECORD CAN BE DELETED, ELSE NOT
*
*/
GF.HasRecords(Convert.ToString(Id), "accomodation", out sMessage);
if (sMessage != "")
{
base.DisplayAlert(sMessage);
btnDelete.Enabled = true;
}
else
{
bActionCompleted = oAccomMaster.Delete(oAccomData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been deleted successfully.");
ClearControls();
//lblStatus.Text = "Deleted";
}
else
{
base.DisplayAlert("Error Occured while deletion: Please refer to the error log.");
}
//lblStatus.Text = "Error Occured while updating: Please refer to the error log.";
}
oAccomMaster = null;
oAccomData = null;
}
private AccomodationDTO MapControlsToObject()
{
AccomodationDTO oAccomData = new AccomodationDTO();
int id = 0;
int.TryParse(hfId.Value, out id);
oAccomData.AccomodationId = id;
oAccomData.AccomodationName = txtAccomName.Text.ToString();
oAccomData.AccomodationTypeId = Convert.ToInt32(ddlAccomTypeId.SelectedValue.ToString());
oAccomData.RegionId = Convert.ToInt32(ddlRegion.SelectedValue.ToString());
oAccomData.AccomInitial = txtAccomInitial.Text.ToString();
oAccomData.AccomPolicyUrl = txtAccomPolicyUrl.Text.ToString();
return(oAccomData);
}
public AccomodationDTO GetAccomodation(int accomodationTypeId, int accomodationId)
{
AccomodationDTO[] accomodationDTOList = GetAccomodations(accomodationTypeId);
AccomodationDTO accomodation = null;
for (int i = 0; i < accomodationDTOList.Length; i++)
{
if (accomodationDTOList[i].AccomodationId == accomodationId)
{
accomodation = accomodationDTOList[i];
}
}
return(accomodation);
}
public AccomodationDTO[] GetData1(int RegionId, int AccomodationTypeId, int AccomodationId)
{
DataSet ds;
AccomodationDTO[] AccomData;
AccomData = null;
ds = null;
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Get_Accomodations1";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomTypeId", DbType.Int32, AccomodationTypeId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomId", DbType.Int32, AccomodationId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iRegionId", DbType.Int32, RegionId);
ds = oDB.ExecuteDataSet(oDB.DbCmd);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
AccomData = new AccomodationDTO[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
AccomData[i] = new AccomodationDTO();
AccomData[i].AccomodationTypeId = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
AccomData[i].AccomodationType = Convert.ToString(ds.Tables[0].Rows[i][1]);
AccomData[i].AccomodationId = Convert.ToInt32(ds.Tables[0].Rows[i][2]);
AccomData[i].AccomodationName = Convert.ToString(ds.Tables[0].Rows[i][3]);
AccomData[i].RegionId = Convert.ToInt32(ds.Tables[0].Rows[i][4]);
AccomData[i].Region = Convert.ToString(ds.Tables[0].Rows[i][5]);
AccomData[i].AccomInitial = Convert.ToString(ds.Tables[0].Rows[i][6]);
AccomData[i].AccomPolicyUrl = Convert.ToString(ds.Tables[0].Rows[i][7]);
AccomData[i].AccomodationSeasonList = GetAccomodationSeasonDates(AccomData[i].AccomodationId);
}
}
}
catch (Exception exp)
{
GF.LogError("clsAccomodationMaster.Update", exp.Message.ToString());
oDB = null;
}
finally
{
oDB = null;
}
return(AccomData);
}
public AccomodationDTO[] GetAccomodations(int AccomodationTypeId)
{
DataSet ds;
AccomodationDTO[] AccomData;
//CombinedAccomData[] oCombinedAccomData = null; ;
AccomData = null;
ds = null;
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_GetAccomodations";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomodationTypeID", DbType.Int32, AccomodationTypeId);
ds = oDB.ExecuteDataSet(oDB.DbCmd);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
AccomData = new AccomodationDTO[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
AccomData[i] = new AccomodationDTO();
AccomData[i].AccomodationId = Convert.ToInt32(ds.Tables[0].Rows[i][0].ToString());
AccomData[i].AccomodationName = Convert.ToString(ds.Tables[0].Rows[i][1].ToString());
AccomData[i].AccomInitial = Convert.ToString(ds.Tables[0].Rows[i][2].ToString());
}
}
}
catch (Exception exp)
{
GF.LogError("clsAccomodationMaster.Update", exp.Message.ToString());
oDB = null;
return(null);
}
finally
{
oDB = null;
}
// return oCombinedAccomData;
return(AccomData);
}
protected void btnInactive_Click(object sender, EventArgs e)
{
AccomodationMaster oAccomMaster = new AccomodationMaster();
AccomodationDTO oAccomData = new AccomodationDTO();
int accomid = 0;
if (Session["accomid"] != null)
{
accomid = Convert.ToInt32(Session["accomid"].ToString());
oAccomData.AccomodationId = accomid;
}
if (btnInactive.Text == "Inactive")
{
bool n = updateStatus(oAccomData);
if (n == true)
{
lblStatus.Text = "Successfully Inctive";
lblStatus.ForeColor = System.Drawing.Color.Green;
btnInactive.Text = "Active";
}
}
else
{
bool n = updateStatus(oAccomData);
if (n == true)
{
lblStatus.Text = "Successfully Active";
lblStatus.ForeColor = System.Drawing.Color.Green;
btnInactive.Text = "Inactive";
}
}
//ScriptManager.RegisterStartupScript(this, this.GetType(), "showPopup", "if (!confirm('Do you want to continue?')) return false;", true);
}
public Accomodation GetReleasedRooms(int BookingId)
{
Accomodation accomodation;
DataSet dsAccomodationData;
DataRow dr;
string sProcName;
DatabaseManager oDB;
dsAccomodationData = null;
accomodation = null;
try
{
oDB = new DatabaseManager();
sProcName = "up_Get_ReleasedRooms";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iBookingId", DbType.Int32, BookingId);
dsAccomodationData = oDB.ExecuteDataSet(oDB.DbCmd);
oDB = null;
}
catch (Exception exp)
{
oDB = null;
dsAccomodationData = null;
GF.LogError("clsBookingRoomReleaseHandler.GetReleasedRooms", exp.Message);
}
#region Populate the Object
if (dsAccomodationData != null && dsAccomodationData.Tables[0].Rows.Count > 0)
{
accomodation = new Accomodation();
List <AccomodationRoomType> accomodationRoomTypes = null;
List <AccomodationRoom> accomodationRooms = null;
for (int i = 0; i < dsAccomodationData.Tables[0].Rows.Count; i++)
{
dr = dsAccomodationData.Tables[0].Rows[i];
int AccomodationId = Convert.ToInt32(dr.ItemArray.GetValue(3));
int bId = Convert.ToInt32(dr.ItemArray.GetValue(1));
int CategoryId = Convert.ToInt32(dr.ItemArray.GetValue(11));
int TypeId = Convert.ToInt32(dr.ItemArray.GetValue(12));
string RoomCategoryName = Convert.ToString(dr.ItemArray.GetValue(13));
string RoomTypeName = Convert.ToString(dr.ItemArray.GetValue(14));
string RoomNo = Convert.ToString(dr.ItemArray.GetValue(4));
if (accomodation.AccomodationDetail == null)
{
AccomodationDTO accomodationDetail = new AccomodationDTO();
accomodationDetail.AccomodationId = AccomodationId;
accomodation.AccomodationDetail = accomodationDetail;
}
AccomodationRoomCategory Category = null;
if (accomodation.Categories != null)
{
Category = accomodation.Categories.Find(delegate(AccomodationRoomCategory CategoryTypes)
{ return(CategoryTypes.RoomCategory.RoomCategoryId == CategoryId); });
if (Category != null && Category.RoomTypes != null)
{
accomodationRoomTypes = Category.RoomTypes;
}
else
{
accomodationRoomTypes = null;
}
}
if (Category == null)
{
RoomCategoryDTO newRoomCategory = new RoomCategoryDTO();
newRoomCategory.RoomCategoryId = CategoryId;
newRoomCategory.RoomCategory = RoomCategoryName;
Category = new AccomodationRoomCategory();
Category.RoomCategory = newRoomCategory;
accomodationRoomTypes = null;
accomodationRooms = null;
}
AccomodationRoomType AccomodationRoomType = null;
if (Category.RoomTypes != null)
{
AccomodationRoomType = Category.RoomTypes.Find(delegate(AccomodationRoomType type)
{ return(type.RoomType.RoomTypeId == TypeId); });
if (AccomodationRoomType != null && AccomodationRoomType.Rooms != null)
{
accomodationRooms = AccomodationRoomType.Rooms;
}
else
{
accomodationRooms = null;
}
}
if (AccomodationRoomType == null)
{
RoomTypeDTO newRoomType = new RoomTypeDTO();
newRoomType.RoomTypeId = TypeId;
newRoomType.RoomType = RoomTypeName;
AccomodationRoomType = new AccomodationRoomType();
AccomodationRoomType.RoomType = newRoomType;
if (accomodationRoomTypes == null)
{
accomodationRoomTypes = new List <AccomodationRoomType>();
}
accomodationRoomTypes.Add(AccomodationRoomType);
Category.RoomTypes = accomodationRoomTypes;
accomodationRooms = null;
}
AccomodationRoom AccomodationRoom = null;
if (AccomodationRoomType.Rooms != null)
{
AccomodationRoom = AccomodationRoomType.Rooms.Find(delegate(AccomodationRoom room)
{ return(room.RoomDetail.RoomNo == RoomNo); });
}
if (AccomodationRoom == null)
{
RoomDTO newRoom = new RoomDTO();
newRoom.RoomNo = RoomNo;
AccomodationRoom = new AccomodationRoom();
AccomodationRoom.RoomDetail = newRoom;
if (accomodationRooms == null)
{
accomodationRooms = new List <AccomodationRoom>();
}
accomodationRooms.Add(AccomodationRoom);
AccomodationRoomType.Rooms = accomodationRooms;
}
if (accomodation.Categories == null)
{
List <AccomodationRoomCategory> categories = new List <AccomodationRoomCategory>();
categories.Add(Category);
accomodation.Categories = categories;
}
else
{
if (!accomodation.Categories.Exists(delegate(AccomodationRoomCategory CategoryTypes)
{ return(CategoryTypes.RoomCategory.RoomCategoryId == CategoryId); }))
{
accomodation.Categories.Add(Category);
}
}
}
}
#endregion
return(accomodation);
}
