public void ExecuteAddRoomTimer()
{
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.proc_AddRoomInventoryTimer1", conn);
cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@vendorId", Convert.ToInt32(vendorId));
cmd.ExecuteNonQuery();
}
public DataSet GetRoomsRate(int propId)
{
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@prop_Id", propId), //0
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_SelectAllRoomRatesByPropId", Params);
ds.Locale = CultureInfo.InvariantCulture;
return(ds);
}
public DataSet GetBookedTransactionById(string Cons_Id)
{
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Cons_Id", Cons_Id), //0
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_SelectAllTransactionByConsumerID]", Params);
return(ds);
}
//Get Vendor to Edit
public List <Object> Edit(int Id)
{
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("proc_SelectVendorById", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Vndr_Id", Id);
SqlDataReader reader = cmd.ExecuteReader();
List <Object> lstvendor = new List <Object>();
while (reader.Read())
{
lstvendor.Add(
new
{
Vndr_Id = reader["Vndr_Id"].ToString(),
Vndr_Name = reader["Vndr_Name"].ToString(),
Vndr_Cinno = reader["Vndr_Cinno"].ToString(),
Vndr_Addr1 = reader["Vndr_Addr1"].ToString(),
Vndr_Gps_Pos = reader["Vndr_Gps_Pos"].ToString(),
Vndr_Overview = reader["Vndr_Overview"].ToString(),
Vndr_Contact_person = reader["Vndr_Contact_person"].ToString(),
Vndr_Contact_Email = reader["Vndr_Contact_Email"].ToString(),
Vndr_Contact_Nos = reader["Vndr_Contact_Nos"].ToString(),
Vndr_Alternate_person = reader["Vndr_Alternate_person"].ToString(),
Vndr_Alternate_Email = reader["Vndr_Alternate_Email"].ToString(),
Vndr_Alternate_Nos = reader["Vndr_Alternate_Nos"].ToString(),
Vndr_Alternate_Mobile = reader["Vndr_Alternate_Mobile"].ToString(),
Vndr_Alternate_Designation = reader["Vndr_Alternate_Designation"].ToString(),
Vndr_Contact_Mobile = reader["Vndr_Contact_Mobile"].ToString(),
Vndr_Contact_Designation = reader["Vndr_Contact_Designation"].ToString(),
Image_dir = reader["Image_dir"].ToString(),
City_Id = reader["Id"].ToString(),
City_Area = reader["Location"].ToString(),
City_Name = reader["City"].ToString(),
State_Name = reader["State"].ToString(),
Pincode = reader["pincode"].ToString(),
});
}
conn.Close();
return(lstvendor);
}
public DataSet GetLocationByCity(string name)
{
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@name", name), //0
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_getlocationbycity]", Params);
return(ds);
}
public DataSet GetSuperAdminsPermission(int authId, int userId)
{
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@authorityId", authId),
new SqlParameter("@userId", userId),
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_Select_SuperAdminPagesbyUserId]", Params);
return(ds);
}
public DataSet CheckCorporateUser(string Cons_Id)
{
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@userid", Cons_Id), //0
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_SelectCorporateUser_By_ConsId]", Params);
return(ds);
}
public DataSet GetRoomDetailsByID(int Prop_Id, int Room_Id)
{
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Prop_Id", Prop_Id), //0
new SqlParameter("@Room_Id", Room_Id), //0
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_Select_RoomDetailsbyID]", Params);
return(ds);
}
//Consumer Details
public DataSet ConsumerDetails(ConsumerDetailsBo consBo)
{
var transactionStatus = new TransactionStatus();
var consumer = BuiltConsumerDetailsDomain(consBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Cons_Id", consumer.Cons_Id), //0
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_ConsumerDetailsById", Params);
return(ds);
}
public TransactionStatus DeleteFacility(FacilityBo facilityBo)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Facility_Id", facilityBo.Facility_Id), //0
new SqlParameter("@opReturnValue", SqlDbType.Int), //1
};
Params[1].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_DeleteFacility", Params);
return(transactionStatus);
}
public DataSet CheckBookingStatus(string Invce_Num, int Cons_Id)
{
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Invce_Num", Invce_Num), //0
new SqlParameter("@Cons_Id", Cons_Id), //0
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_SelectBookingStatus_by_ConsId]", Params);
return(ds);
}
public TransactionStatus Edit(PropertyBo propertyBo)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
var property = BuiltPropertyDomain(propertyBo);
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", SqlDbType.Int), //0
new SqlParameter("@Prop_Id", property.Prop_Id), //1
new SqlParameter("@Prop_Name", property.Prop_Name), //2
new SqlParameter("@Prop_Cin_No", property.Prop_Cin_No), //3
new SqlParameter("@Prop_Addr1", property.Prop_Addr1), //4
new SqlParameter("@Prop_Addr2", property.Prop_Addr2), //5
new SqlParameter("@CityID", property.City_Id), //7 property.CityId
new SqlParameter("@Prop_Star_Rating", property.Prop_Star_Rating), //12
new SqlParameter("@Prop_GPS_Pos", property.Prop_GPS_Pos), //13
new SqlParameter("@Prop_Booking_MailId", property.Prop_Booking_MailId), //14
new SqlParameter("@Prop_Booking_Mob", property.Prop_Booking_Mob), //15
new SqlParameter("@Prop_Pricing_MailId", property.Prop_Pricing_MailId), //16
new SqlParameter("@Prop_Pricing_Mob", property.Prop_Pricing_Mob), //17
new SqlParameter("@Prop_Inventory_MailId", property.Prop_Inventory_MailId), //18
new SqlParameter("@Prop_Inventory_Mob", property.Prop_Inventory_Mob), //19
// new SqlParameter("@Image_dir", property.Image_dir),//20
new SqlParameter("@Pricing_Type", property.Pricing_Type), //19
new SqlParameter("@Prop_Type", property.Prop_Type), //19
new SqlParameter("@Prop_Overview", property.Prop_Overview), //22
new SqlParameter("@Room_Checkin", property.Room_Checkins), //22
new SqlParameter("@Room_Checkout", property.Room_Checkouts), //22
new SqlParameter("@Location_Name", property.Location_Name), //22
new SqlParameter("@City_Name", property.City_Name), //22
new SqlParameter("@State_Name", property.State_Name), //22
new SqlParameter("@Pin_Code", property.Pin_Code), //22
new SqlParameter("@TripAdvi", property.TripAdv), //22
};
Params[0].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateProperty", Params);
return(transactionStatus);
}
public TransactionStatus Delete(int loc_Id)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@id", loc_Id), //0
new SqlParameter("@output", SqlDbType.Int) //1
};
Params[1].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_DeleteCityLocation_Master", Params);
ds.Locale = CultureInfo.InvariantCulture;
return(transactionStatus);
}
public static void SaveException(ApplicationErrorLog appErrorLog)
{
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.proc_AddApplicationErrors", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@error", appErrorLog.Error);
cmd.Parameters.AddWithValue("@stackTrace", appErrorLog.Stacktrace);
cmd.Parameters.AddWithValue("@innerException", appErrorLog.InnerException);
cmd.Parameters.AddWithValue("@source", appErrorLog.Source);
cmd.ExecuteNonQuery();
}
public TransactionStatus ActivePromotion(int promotion_Id)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.proc_UpdatePromotionActive_flag", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Promo_Id", promotion_Id);
cmd.Parameters.AddWithValue("@Promo_Active_flag", "true");
cmd.Parameters.AddWithValue("@opReturnValue", SqlDbType.Int);
cmd.ExecuteNonQuery();
return(transactionStatus);
}
public TransactionStatus SuspendLoyalty(int loyalty_Id)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.proc_UpdateLoyaltyActive_flag", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Loyal_Id", loyalty_Id);
cmd.Parameters.AddWithValue("@Loyal_Active_flag", "false");
cmd.Parameters.AddWithValue("@opReturnValue", SqlDbType.Int);
cmd.ExecuteNonQuery();
return(transactionStatus);
}
public DataSet GetAllTransaction(PrebookingBo PreBo)
{
var transactionStatus = new TransactionStatus();
var Listing = BuiltPreBookingDomain(PreBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Cons_Id", Listing.Cons_Id), //0
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_SelectAllTransaction]", Params);
return(ds);
}
public bool UpdateCorporateUserToAdmin(string CorpEmail, string CorpCompany)
{
List <string> lstcorpCompany = new List <string>();
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Corp_Email", CorpEmail), //0
new SqlParameter("@Corp_Company", CorpCompany),
};
SqlHelper.ExecuteScalar(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateCoporateUserToAdmin", Params);
return(true);
}
public DataSet GetTransaction(string Invce_Num)
{
var transactionStatus = new TransactionStatus();
// var Listing = BuiltPreBookingDomain(PreBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Invce_Num", Invce_Num), //0
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_SelectTransaction]", Params);
return(ds);
}
//Get Facility to bind
public List <Object> BindFacilityimage(int prop_id)
{
try
{
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("proc_SelectAllPropertyFacility", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Prop_Id", prop_id);
SqlDataReader reader = cmd.ExecuteReader();
List <Object> lstpolicy = new List <Object>();
while (reader.Read())
{
lstpolicy.Add(
new
{
Id = reader["Id"].ToString(),
Prop_Id = reader["Prop_Id"].ToString(),
Facility_Id = reader["Facility_Id"].ToString(),
Facility_Name = reader["Facility_Name"].ToString(),
Facility_Type = reader["Facility_Type"].ToString(),
//Facility_descr = reader["Facility_descr"].ToString(),
Facility_Image_dir = reader["Facility_Image_dir"].ToString(),
Active_flag = reader["Active_flag"].ToString(),
IsHeader = reader["IsHeader"].ToString(),
FTypecount = reader["FTypecount"].ToString(),
});
}
conn.Close();
return(lstpolicy);
}
catch (Exception ex)
{
ApplicationErrorLogServices.AppException(ex);
return(null);
}
}
public TransactionStatus UpdateRackPrice(int Inv_Id, int race_price)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", SqlDbType.Int), //0
new SqlParameter("@inv_Id", Inv_Id), //0
new SqlParameter("@Room_Standard_rate", race_price) //0
};
Params[0].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateRacePrice", Params);
return(transactionStatus);
}
public TransactionStatus DeteteImage(PropertyBo propertyBo)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
var property = BuiltPropertyDomain(propertyBo);
SqlParameter[] Params =
{
new SqlParameter("@Image_Id", property.Image_Id), //0
new SqlParameter("@opReturnValue", SqlDbType.Int), //4
};
Params[1].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_DeleteImage", Params);
return(transactionStatus);
}
public TransactionStatus SetDefaultImage(int PropId, int ImageId)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", SqlDbType.Int), //0
new SqlParameter("@prop_Id", PropId), //0
new SqlParameter("@image_Id", ImageId) //0
};
Params[0].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateProperty_Default_Image", Params);
return(transactionStatus);
}
public TransactionStatus UpdateParamPermission(int Id, string flag)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", SqlDbType.Int), //0
new SqlParameter("@Id", Id), //0
new SqlParameter("@flag", flag) //0
};
Params[0].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateParam_Permission", Params);
return(transactionStatus);
}
public TransactionStatus updaterackRates(int Inv_Id, int Vndr_Amnt)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", SqlDbType.Int), //0
new SqlParameter("@inv_Id", Inv_Id), //0
new SqlParameter("@Vndr_Amnt", Vndr_Amnt) //0
};
Params[0].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateRack_Amount", Params);
return(transactionStatus);
}
public TransactionStatus UpdateAvailableRoom(int Inv_Id, int Available)
{
var transactionStatus = new TransactionStatus();
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", SqlDbType.Int), //0
new SqlParameter("@inv_Id", Inv_Id), //0
new SqlParameter("@available", Available) //0
};
Params[0].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateInventry_Available_Room", Params);
return(transactionStatus);
}
public TransactionStatus EditCity(CityBo1 cityBo)
{
var transactionStatus = new TransactionStatus();
var city = BuiltCityDomain1(cityBo);
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.proc_UpdateCity", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@City_Id", Convert.ToInt32(cityBo.City_Id));
cmd.Parameters.AddWithValue("@City_Name", city.City_Name);
cmd.Parameters.AddWithValue("@opReturnValue", SqlDbType.Int);
cmd.ExecuteNonQuery();
return(transactionStatus);
}
public TransactionStatus CreateLocation(LocationBo locationbo)
{
var transactionStatus = new TransactionStatus();
var con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Location_desc", locationbo.Location_desc), //0
new SqlParameter("@opReturnValue", SqlDbType.Int) //1
};
Params[1].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddLocation", Params);
ds.Locale = CultureInfo.InvariantCulture;
return(transactionStatus);
}
public String CreateProperty(PropertyBo propertyBo)
{
CemexDb con = new CemexDb();
var property = BuiltPropertyDomain(propertyBo);
if (property.TripAdv == null)
{
property.TripAdv = "";
}
SqlParameter[] Params =
{
new SqlParameter("@Prop_Name", property.Prop_Name), //0
new SqlParameter("@Prop_Cin_No", property.Prop_Cin_No), //1
new SqlParameter("@Prop_Addr1", property.Prop_Addr1), //2
new SqlParameter("@Prop_Addr2", property.Prop_Addr2), //3
new SqlParameter("@CityID", property.City_Id), //5
new SqlParameter("@Prop_Star_Rating", property.Prop_Star_Rating), //10
new SqlParameter("@Prop_GPS_Pos", property.Prop_GPS_Pos), //11
new SqlParameter("@Prop_Booking_MailId", property.Prop_Booking_MailId), //12
new SqlParameter("@Prop_Booking_Mob", property.Prop_Booking_Mob), //13
new SqlParameter("@Prop_Pricing_MailId", property.Prop_Pricing_MailId), //14
new SqlParameter("@Prop_Pricing_Mob", property.Prop_Pricing_Mob), //15
new SqlParameter("@Prop_Inventory_MailId", property.Prop_Inventory_MailId), //16
new SqlParameter("@Prop_Inventory_Mob", property.Prop_Inventory_Mob), //17
new SqlParameter("@Vndr_Id", property.Vndr_Id), //18
new SqlParameter("@Image_dir", property.Image_dir), //19
new SqlParameter("@Pricing_Type", property.Pricing_Type), //20
new SqlParameter("@Prop_Type", property.Prop_Type), //21
new SqlParameter("@Prop_Overview", property.Prop_Overview), //22
new SqlParameter("@Room_Checkin", property.Room_Checkins), //22
new SqlParameter("@Room_Checkout", property.Room_Checkouts), //22
new SqlParameter("@Location_Name", property.Location_Name), //22
new SqlParameter("@City_Name", property.City_Name), //22
new SqlParameter("@State_Name", property.State_Name), //22
new SqlParameter("@Pin_Code", property.Pin_Code), //22
new SqlParameter("@TripAdv", property.TripAdv) //22
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddProperty", Params);
return(ds.Tables[0].Rows[0][0].ToString());
}
public DataSet BookingHotel_Details(BookNowDetailsBo booknowBo)
{
var transactionStatus = new TransactionStatus();
var booknow = BuiltBookNowDetailsDomain(booknowBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@PropId", booknow.Prop_Id), //0
new SqlParameter("@RoomId", booknow.Room_Id), //0
new SqlParameter("@Room_Checkin", booknow.Room_Checkin), //1
new SqlParameter("@Room_Checkout", booknow.Room_Checkout), //2
new SqlParameter("@No_Of_Rooms", booknow.No_Of_Rooms), //3
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_Booking_HotelDetailes_ById", Params);
return(ds);
}
