public bool CopyContacts(int SourceAccomodationId, int DestinationAccomodationId)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Copy_AccomodationContacts";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iSourceAccomodationId", DbType.Int32, SourceAccomodationId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iDestinationAccomodationId", DbType.Int32, DestinationAccomodationId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsAccomodationContact.CopyContacts", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool Delete(EventMessageDTO oEventMessageData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_EventMessage";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iMessageId", DbType.Int32, oEventMessageData.MessageId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsEventMessage.Delete", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool Delete(SMTPDTO SMTPDTO)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_SMTPMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@SMTPID", DbType.String, SMTPDTO.SMTPId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsSMTPMaster.Delete", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
protected void dgBookings_ItemCommand(object source, DataGridCommandEventArgs e)
{
string cFormUrl = string.Empty;
try
{
if (e.Item.ItemIndex >= 0)
{
int iBookingID = Convert.ToInt32(dgTouristCount.DataKeys[e.Item.ItemIndex].ToString());
switch (e.CommandName.ToString().ToUpper())
{
case "VIEWBOOKING":
Response.Redirect("Booking.aspx?bid=" + iBookingID.ToString() + "&mode=view");
break;
case "VIEWTOURIST":
Response.Redirect("ViewTourists.aspx?bid=" + iBookingID.ToString());
break;
default:
break;
}
}
}
catch (Exception exp)
{
GF.LogError("TouristCount.dgBookings_ItemCommand", exp.Message);
return;
}
}
public bool CancelBookingConfirmation(int BookingId)
{
BookingMealPlanHandler oBMPH;
string sProcName;
try
{
if (oDB == null)
{
oDB = new DatabaseManager();
}
oBMPH = new BookingMealPlanHandler();
oBMPH.DeleteBookingMealPlan(BookingId);
sProcName = "up_Booking_Confirmation_Cancel";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iBookingID", DbType.Int32, BookingId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsBookingConfirmationHandler.CancelBookingConfirmation", exp.Message);
return(false);
}
return(true);
}
public bool Update(DepartmentDTO oDepartmentData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_DepartmentMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@DepartmentId", DbType.Int32, oDepartmentData.DepartmentId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sDepartmentCode", DbType.String, oDepartmentData.DepartmentCode);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sDepartmentName", DbType.String, oDepartmentData.DepartmentName);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oDepartmentData = null;
GF.LogError("clsDepartmentMaster.Insert", exp.Message);
return(false);
}
finally
{
oDepartmentData = null;
oDB = null;
}
return(true);
}
public TreeTypeDTO GetDefaultTreeType()
{
DataSet dsTreeTypeDefault = null;
DataRow dr = null;
DatabaseManager oDB;
TreeTypeDTO oTreeTypeDefault = null;
string sProcName;
dsTreeTypeDefault = null;
oTreeTypeDefault = null;
try
{
oDB = new DatabaseManager();
sProcName = "up_Get_TreeTypeDefault";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
dsTreeTypeDefault = oDB.ExecuteDataSet(oDB.DbCmd);
if (dsTreeTypeDefault != null)
{
oTreeTypeDefault = new TreeTypeDTO();
dr = dsTreeTypeDefault.Tables[0].Rows[0];
oTreeTypeDefault.TreeTypeId = Convert.ToInt32(dr.ItemArray.GetValue(0));
oTreeTypeDefault.TreeType = Convert.ToString(dr.ItemArray.GetValue(1));
oTreeTypeDefault.Description = Convert.ToString(dr.ItemArray.GetValue(2));
oTreeTypeDefault.Selected = Convert.ToBoolean(dr.ItemArray.GetValue(3));
}
}
catch (Exception exp)
{
GF.LogError("clsTreeTypeMaster.GetTreeType", exp.Message);
}
return(oTreeTypeDefault);
}
public bool Update(BookingStatusDTO oBookingStatusData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_BookingStatusMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iBookingStatusId", DbType.Int32, oBookingStatusData.BookingStatusId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sBookingStatusType", DbType.String, oBookingStatusData.BookingStatusType);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iBookingStatusColor", DbType.Int64, oBookingStatusData.BookingStatusColor);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oBookingStatusData = null;
GF.LogError("clsBookingStatusMaster.Update", exp.Message);
return(false);
}
finally
{
oBookingStatusData = null;
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);
}
public bool Insert(RoomTypeDTO oRoomTypeData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Ins_RoomTypeMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sRoomType", DbType.String, oRoomTypeData.RoomType.Trim());
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iDefaultNoOfBeds", DbType.Int32, oRoomTypeData.DefaultNoOfBeds);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oRoomTypeData = null;
GF.LogError("clsRoomtypeMaster.Insert", exp.Message);
return(false);
}
finally
{
oDB = null;
oRoomTypeData = null;
}
return(true);
}
public bool Update(FloorDTO oFloorData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_FloorMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iFloorID", DbType.Int32, oFloorData.FloorId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iFloor", DbType.Int32, oFloorData.Floor);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oFloorData = null;
GF.LogError("clsFloorMaster.Update", exp.Message);
return(false);
}
finally
{
oDB = null;
oFloorData = null;
}
return(true);
}
public bool Insert(UserRoleDTO oUserRoleData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Ins_UserRoleMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@UserRoleName", DbType.String, oUserRoleData.UserRoleName);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oUserRoleData = null;
GF.LogError("clsUserRoleMaster.Insert", exp.Message);
return(false);
}
finally
{
oUserRoleData = null;
oDB = null;
}
return(true);
}
private bool GenerateCFormNumbers(int bookingId)
{
DatabaseManager oDB = null;
try
{
if (oDB == null)
{
oDB = new DatabaseManager();
}
string sProcName = "up_Upd_BookingCFormNos";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bookingId", DbType.Int32, bookingId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
GF.LogError("clsBCFormReport.GenerateCFormNumbers", exp.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool DeleteRemovedRoomCategoryAndType(BookedRooms[] TotallyRemovedRCRT)
{
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
string sProcName = "up_DeleteRemovedRoomCategoryAndType";
for (int i = 0; i < TotallyRemovedRCRT.Length; i++)
{
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingId", DbType.Int32, TotallyRemovedRCRT[i].BookingId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomID", DbType.Int32, TotallyRemovedRCRT[i].AccomodationId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RoomCategory", DbType.String, TotallyRemovedRCRT[i].RoomCategory);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RoomType", DbType.String, TotallyRemovedRCRT[i].RoomType);
oDB.ExecuteNonQuery(oDB.DbCmd);
oDB.DbCmd.Parameters.Clear();
}
}
catch (Exception exp)
{
oDB = null;
//oRoomsDeletion = null;
GF.LogError("clsBookingRoomHandler.DeleteBookings", exp.Message);
return(false);
}
return(true);
}
public bool Update(AccomTypeDTO oAccomTypeData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_AccomodationTypeMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomTypeId", DbType.Int32, oAccomTypeData.AccomodationTypeId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sAccomType", DbType.String, oAccomTypeData.AccomodationType);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
GF.LogError("clsAccomodationMaster.Update", exp.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool Update(CityDTO oCityData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_CityMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@CityId", DbType.Int32, oCityData.CityId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sCityCode", DbType.String, oCityData.CityCode);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sCityName", DbType.String, oCityData.CityName);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oCityData = null;
GF.LogError("clsCityMaster.Update", exp.Message);
return(false);
}
finally
{
oDB = null;
oCityData = null;
}
return(true);
}
public bool Update(MealPlanDTO oMealPlanData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_MealPlanMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@MealPlanId", DbType.Int32, oMealPlanData.MealPlanId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sMealPlanCode", DbType.String, oMealPlanData.MealPlanCode);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sMealPlan", DbType.String, oMealPlanData.MealPlan);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sMealPlanDesc", DbType.String, oMealPlanData.MealPlanDesc);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bWelcomeDrink", DbType.Boolean, oMealPlanData.WelcomeDrink);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bBreakFast", DbType.Boolean, oMealPlanData.Breakfast);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bLunch", DbType.Boolean, oMealPlanData.Lunch);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bEveSnacks", DbType.Boolean, oMealPlanData.EveningSnacks);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bDinner", DbType.Boolean, oMealPlanData.Dinner);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oMealPlanData = null;
GF.LogError("clsMealPlanMaster.Update", exp.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool Delete(RoleRightsDTO roleRights)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_RoleRightsMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@roleId", DbType.Int32, roleRights.RoleId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
GF.LogError("RoleRightsMaster.Delete", exp.Message);
throw exp;
}
finally
{
oDB = null;
}
return(true);
}
public bool Delete(UserAgentMapperDTO userAgentData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_UserAgentMaster";
foreach (AgentDTO agent in userAgentData.AgentList)
{
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@UserId", DbType.String, userAgentData.UserId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AgentId", DbType.Int32, agent.AgentId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
}
catch (Exception exp)
{
oDB = null;
userAgentData = null;
GF.LogError("UserAgentMaster.Delete", exp.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool Update(RoomCategoryDTO oRoomCategoryData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_RoomCategoryMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iRoomCategoryID", DbType.Int32, oRoomCategoryData.RoomCategoryId);
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.Update", exp.Message);
return(false);
}
finally
{
oDB = null;
oRoomCategoryData = null;
}
return(true);
}
public BookingTouristDTO[] SearchTourists(string Firstname, string Lastname, string Passportno, int Nationality)
{
DataSet ds;
BookingTouristDTO[] oBookingTouristDTO;
oBookingTouristDTO = null;
string sProcName;
try
{
oDB = new DatabaseManager();
sProcName = "up_SearchTourists";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sFirstName", DbType.String, DataSecurityManager.Encrypt(Firstname));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sLastName", DbType.String, DataSecurityManager.Encrypt(Lastname));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sPassportNo", DbType.String, DataSecurityManager.Encrypt(Passportno));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iNationalityid", DbType.Int32, Nationality);
ds = oDB.ExecuteDataSet(oDB.DbCmd);
oDB = null;
}
catch (Exception exp)
{
oDB = null;
ds = null;
GF.LogError("clsBookingTouristhandler.GetTouristDetails", exp.Message);
}
oBookingTouristDTO = FillTouristDetails(ds);
return(oBookingTouristDTO);
}
private bool DeleteBookingWaitList(int BookingId, int RoomCategoryId, int RoomTypeId, int AccomId)
{
if (oDB == null)
{
oDB = new DatabaseManager();
}
string sProcName = "up_DeleteBookingWaitlistRooms";
try
{
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingId", DbType.Int32, BookingId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RoomCategoryId", DbType.Int32, RoomCategoryId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RoomTypeId", DbType.Int32, RoomTypeId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomId", DbType.Int32, AccomId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
GF.LogError("clsBookingWaitListHandler.DeleteBookingWaitList", exp.Message);
return(false);
}
return(true);
}
public bool Delete(TransportDTO oTransportData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_TransportMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@TransportId", DbType.Int32, oTransportData.TransportId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oTransportData = null;
GF.LogError("clsTransportMaster.Delete", exp.Message);
return(false);
}
finally
{
oDB = null;
oTransportData = null;
}
return(true);
}
public bool AllocateRoomsToWaitListedBooking(int BookingId, string RoomList, int RoomCategoryId, int RoomTypeId)
{
try
{
if (oDB == null)
{
oDB = new DatabaseManager();
}
string sProcName = "up_AllocateRooms_To_WaitListedLBookings";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingId", DbType.Int32, BookingId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RoomNoList", DbType.String, RoomList);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RoomCategoryId", DbType.Int32, RoomCategoryId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RoomTypeId", DbType.Int32, RoomTypeId);
oDB.ExecuteNonQuery(oDB.DbCmd);
oDB.DbCmd.Parameters.Clear();
}
catch (Exception exp)
{
oDB = null;
GF.LogError("clsBookingWaitListHandler.AllocateRoomsToWaitListedBooking", exp.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool Update(EventMessageDTO oEventMessageData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_EventMessage";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@MessageId", DbType.String, oEventMessageData.MessageId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@EventName", DbType.String, oEventMessageData.EventName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@EventMessage", DbType.String, oEventMessageData.EventMessage);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@EventSubject", DbType.String, oEventMessageData.EventSubject);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@MailAllowed", DbType.Boolean, oEventMessageData.MailAllowed);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsEventMessageMaster.Update", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool DeleteRole(UserRoleDTO UserRoleDTO)
{
DatabaseManager oDB;
oDB = new DatabaseManager();
string sProcName = "up_DeleteRole";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iRoleID", DbType.Int32, UserRoleDTO.UserRoleId);
try
{
oDB.ExecuteNonQuery(oDB.DbCmd);
//return true;
}
catch (Exception e)
{
GF.LogError("clsUserRoleHandler.DeleteRole", e.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool Update(SMTPDTO oSMTPData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_SMTPMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@SMTPID", DbType.String, oSMTPData.SMTPId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@SMTPServer", DbType.String, oSMTPData.SMTPServer);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@FromId", DbType.String, oSMTPData.FromEmailId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ReplyToId", DbType.String, oSMTPData.ReplyToId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@FromDisplayName", DbType.String, oSMTPData.FromDisplayName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@UserId", DbType.String, oSMTPData.SMTPUserId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Password", DbType.String, oSMTPData.SMTPPassword);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Port", DbType.Int32, oSMTPData.Port);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Active", DbType.Boolean, oSMTPData.Active);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsSMTPMaster.Update", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public BookingChartTreeDTO[] GetTreeData(out string DefaultTreeTypeCode)
{
DataSet dsTreeData = null;
DatabaseManager oDB = null;
BookingChartTreeDTO[] oBookingChartDTO = null;
String sProcName = String.Empty;
String DefaultTreeType = String.Empty;
try
{
oDB = new DatabaseManager();
sProcName = "up_Get_BookingTreeData";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddOutParameter(oDB.DbCmd, "@sDefaultTreeType", DbType.String, 20); //, DefaultTreeType);
dsTreeData = oDB.ExecuteDataSet(oDB.DbCmd);
oBookingChartDTO = MapDBDataToObject(dsTreeData);
DefaultTreeType = oDB.DbCmd.Parameters[0].Value.ToString();
}
catch (Exception exp)
{
oDB = null;
dsTreeData = null;
GF.LogError("clsTreeViewManager.GetTreeData", exp.Message);
}
DefaultTreeTypeCode = DefaultTreeType;
return(oBookingChartDTO);
}
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(UserDTO oUserData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Ins_UserMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@UserId", DbType.String, oUserData.UserId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sUserName", DbType.String, DataSecurityManager.Encrypt(oUserData.UserName));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Password", DbType.String, DataSecurityManager.Encrypt(oUserData.Password));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Active", DbType.Boolean, oUserData.Active);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Administrator", DbType.Boolean, oUserData.Administrator);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@UserRoleId", DbType.Int32, oUserData.UserRoleData.UserRoleId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@UserEmailId", DbType.String, DataSecurityManager.Encrypt(oUserData.EmailId));
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oUserData = null;
GF.LogError("clsUserMaster.Insert", exp.Message);
return(false);
}
finally
{
oDB = null;
oUserData = null;
}
return(true);
}
