public bool Delete(RoomCategoryDTO oRoomCategoryData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_RoomCategoryMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iRoomCategoryId", DbType.Int32, oRoomCategoryData.RoomCategoryId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oRoomCategoryData = null;
GF.LogError("clsRoomCategoryMaster.Delete", exp.Message);
return(false);
}
finally
{
oDB = null;
oRoomCategoryData = null;
}
return(true);
}
public bool Insert(RoomCategoryDTO oRoomCategoryData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Ins_RoomCategoryMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sRoomCategory", DbType.String, oRoomCategoryData.RoomCategory.Trim());
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@categoryAlias", DbType.String, oRoomCategoryData.CategoryAlias.Trim());
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oRoomCategoryData = null;
GF.LogError("clsRoomCategoryMaster.Insert", exp.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
private void Save()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add))
{
return;
}
bool bActionCompleted = false;
RoomCategoryDTO oNationalityData = new RoomCategoryDTO();
oNationalityData.RoomCategory = txtRoomcategory.Text.ToString();
oNationalityData.CategoryAlias = txtCategoryAlias.Text;
RoomCategoryMaster oNationalityMaster = new RoomCategoryMaster();
bActionCompleted = oNationalityMaster.Insert(oNationalityData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been inserted successfully");
txtRoomcategory.Text = "";
lblStatus.Text = "Data Saved Successfully";
lblStatus.ForeColor = System.Drawing.Color.Green;
}
else
{
lblStatus.Text = "Error Occured while insertion: Please refer to the error log.";
}
lblStatus.ForeColor = System.Drawing.Color.Red;
oNationalityData = null;
oNationalityMaster = null;
}
private void Delete()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Delete))
{
return;
}
if (ValidateValues() == false)
{
return;
}
bool bActionCompleted = false;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit button again.";
return;
}
RoomCategoryDTO oNationalityData = new RoomCategoryDTO();
oNationalityData.RoomCategoryId = Id;
RoomCategoryMaster oNationalityMaster = new RoomCategoryMaster();
/*
* ADDED BY VIJAY
* CHECK IF THE NATIONALITY 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
*
*/
string sMessage = "";
GF.HasRecords(Convert.ToString(Id), "nationality", out sMessage);
if (sMessage != "")
{
base.DisplayAlert(sMessage);
btnDelete.Enabled = true;
}
else
{
bActionCompleted = oNationalityMaster.Delete(oNationalityData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been deleted successfully");
txtRoomcategory.Text = "";
//lblStatus.Text = "Deleted";
RefreshGrid();
}
else
{
base.DisplayAlert("Error Occured while deletion: Please refer to the error log.");
}
}
oNationalityData = null;
oNationalityMaster = null;
}
private void Update()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update))
{
return;
}
if (ValidateValues() == false)
{
return;
}
bool bActionCompleted = false;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit button again.";
return;
}
RoomCategoryDTO oNationalityData = new RoomCategoryDTO();
oNationalityData.RoomCategoryId = Id;
oNationalityData.RoomCategory = txtRoomcategory.Text.ToString();
oNationalityData.CategoryAlias = txtCategoryAlias.Text;
RoomCategoryMaster oNationalityMaster = new RoomCategoryMaster();
bActionCompleted = oNationalityMaster.Update(oNationalityData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been updated successfully");
txtRoomcategory.Text = "";
txtCategoryAlias.ReadOnly = false;
lblStatus.Text = "Updated";
}
else
{
lblStatus.Text = "Error Occured while updation: Please refer to the error log.";
}
oNationalityData = null;
oNationalityMaster = null;
}
private RoomCategoryDTO[] PopulateDataObject(string Query)
{
RoomCategoryDTO[] oRoomCategoryData;
DataSet ds;
oRoomCategoryData = null;
ds = GetDataFromDB(Query);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
oRoomCategoryData = new RoomCategoryDTO[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oRoomCategoryData[i] = new RoomCategoryDTO();
oRoomCategoryData[i].RoomCategoryId = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
oRoomCategoryData[i].RoomCategory = Convert.ToString(ds.Tables[0].Rows[i][1]).Trim();
oRoomCategoryData[i].CategoryAlias = Convert.ToString(ds.Tables[0].Rows[i][2]).Trim();
}
}
return(oRoomCategoryData);
}
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);
}
public IHttpActionResult Put([FromUri] int id, [FromBody] RoomCategoryDTO RoomCategory)
{
RoomCategoryService.PrePutDTO(ModelState, currentClient, id, RoomCategory);
return(Ok());
}
public RoomCategoryDTO Post([FromBody] RoomCategoryDTO RoomCategory)
{
return(RoomCategoryService.PrePostDTO(ModelState, currentClient, RoomCategory));
}
