public static bool SendEmail(string[] _email, string Subject, string body, string[] _cc = null)
{
// return false;
var account = SqlModule.GetDataTable(" SELECT TOP 1 * FROM dbo.SetupMailSMTP order by NEWID()").Rows[0];
MailMessage mail = new MailMessage();
try
{
foreach (var item in _email)
{
try
{
if (item.Contains("@"))
{
mail.To.Add(item);
}
}
catch
{
}
}
if (mail.To.Count == 0)
{
return(false);
}
if (_cc != null)
{
foreach (var item in _cc)
{
mail.CC.Add(item);
}
}
mail.From = new MailAddress(account["SetupMailSMTP_Email"].ToString());
mail.Subject = Subject;
mail.Body = body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = account["SetupMailSMTP_Host"].ToString(); //Or Your SMTP Server Address
smtp.Credentials = new System.Net.NetworkCredential(account["SetupMailSMTP_Email"].ToString(), account["SetupMailSMTP_Password"].ToString());
smtp.Port = int.Parse(account["SetupMailSMTP_Port"].ToString());
smtp.EnableSsl = (account["SetupMailSMTP_SSL"].ToString() == "True" ? true : false);
smtp.Send(mail);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult UpdateGiaoDich(int ID)
{
var data = SqlModule.GetDataTable(" exec spBookingHotel_history " + ID);
ViewBag.Config_id = data.Select("ID IS NULL and Config_id <> 1").ToList().Select(z => z["Config_id"]).FirstOrDefault();
ViewBag.Booking_Surcharge = SqlModule.GetDataTable("SELECT Booking_Surcharge FROM [VBookingHotel] where BookingHotel_ID=" + ID).Rows[0][0].ToString();
ViewBag.ID = ID;
if (ViewBag.Config_id == null)
{
return(Content("<H1>Giao dịch đã hoàn thành</H1>"));
}
return(PartialView(data));
}
public ActionResult Details(int ID)
{
var data = SqlModule.GetDataTable($@"SELECT t1.* , t2.[Hotel_Content], t2.[Hotel_ListImage]
FROM VHotel t1
left join[Hotel] t2 on t1.Hotel_ID = t2.Hotel_ID where t1.Hotel_ID = {ID}");
if (data.Rows.Count == 0)
{
return(Content("Không tìm thấy"));
}
ViewBag.Room = SqlModule.GetDataTable("SELECT * FROM [V_RoomHotel] where Hotel_ID=" + ID);
ViewBag.RoomHotel_Extensions = SqlModule.GetDataTable("SELECT * FROM [RoomHotel_Extensions]");
return(View(data.Rows[0]));
}
public ActionResult GridData(int Tour_Active = 2)
{
var data = SqlModule.GetDataTable($"SELECT * FROM VTour where {Tour_Active} in (Tour_Active,2)");
data.Columns.Add("Tour_StarRateHTML");
foreach (DataRow item in data.Rows)
{
float.TryParse(item["Tour_StarRate"].ToString(), out float star);
item["Tour_StarRateHTML"] = Funtions.FillStar(star);
}
var json = ToJson(data);
return(JsonMax(new { result = "Success", data = json }));
}
public static List <string> ConvertIDtoText(string ID = "")
{
List <string> Result = new List <string>();
var ListID = ID.Split(',');
var data = SqlModule.GetDataTable("SELECT [Hotel_Facilities_ID] ,[Name] FROM [Hotel_Facilities]");
foreach (DataRow item in data.Rows)
{
if (ListID.Contains(item["Hotel_Facilities_ID"].ToString()))
{
Result.Add(item["Name"].ToString());
}
}
return(Result);
}
private static void InitSubs()
{
ReportsEngModule.New();
ReportsNorModule.New();
ReportsEngUtvModule.New();
ReportsNorUtvModule.New();
DataSetModule.New();
DataSourceModule.New();
IntegrationPacksModule.New();
BatchModule.New();
DeploymentModule.New();
SqlModule.New();
InformationModule.New();
ZipModule.New();
}
public ActionResult Create(int ID = 0, int Hotel_ID = 0)
{
var Hotel_Name = SqlModule.GetDataTable("SELECT Hotel_Name FROM HOTEL WHERE Hotel_ID=" + Hotel_ID).FirstOrDefault("Hotel_Name");
ViewBag.title = "Quản lý phòng khách sạn : " + Hotel_Name;
ViewBag.Hotel_Name = Hotel_Name;
ViewBag.RoomType = SqlModule.GetDataTable("SELECT * FROM [RoomType]");
ViewBag.RoomHotel_Extensions = SqlModule.GetDataTable("SELECT [ID] ,[Name] ,[Type] FROM [RoomHotel_Extensions]");
RoomHotel item = new RoomHotel().GetRoomHotelByID(ID);
if (item.Hotel_ID == 0)
{
item.Hotel_ID = Hotel_ID;
}
return(View(item));
}
public ActionResult Add(string TYPE, string img, int STT)
{
string sql = @"INSERT INTO [dbo].[BANNER]
([UrlFile]
,[STT]
,[TYPE])
VALUES
(N'#UrlFile#'
,#STT#
,'#TYPE#')";
sql = sql.Replace("#UrlFile#", img);
sql = sql.Replace("#STT#", STT.ToString());
sql = sql.Replace("#TYPE#", TYPE);
SqlModule.ExcuteCommand(sql);
return(JsonMax(new { result = "OK" }));
}
public ActionResult SendEmailGiaoDich(int ID, string To)
{
var data = SqlModule.GetDataTable($"SELECT * FROM VBookingHotel where BookingHotel_ID={ID}");
if (data.Rows.Count == 0)
{
return(Content("<H1>Không tìm thấy thông tin</H1>"));
}
var item = data.Rows[0];
string NewNoiDungMail = RenderPartialViewToString("~/Views/BookingHotels/EmailGiaoDich.cshtml", item);
Task.Run(() =>
{
SendMailExtentions.SendEmail(new string[] { To }, $"Đơn hàng {item["BookingHotel_ID"]}:" + item["Hotel_Name"], NewNoiDungMail);
});
return(JsonMax("OK"));
}
public ActionResult Details(int ID)
{
var data = SqlModule.GetDataTable($@"SELECT t1.*,t2.[Tour_Description]
, t2.[Tour_Content]
, t2.[Tour_Itinerary]
, t2.[Tour_Schedule]
, t2.[Tour_Rules]
, t2.[Tour_ListImage] FROM VTour t1 left join[Tour] t2
on t1.Tour_ID = t2.Tour_ID where t1.Tour_ID = {ID}");
ViewBag.Room = SqlModule.GetDataTable(" SELECT * FROM [Room]");
ViewBag.AirType = SqlModule.GetDataTable(" SELECT [Config_Title] as AirType FROM [ConfigInfomation] where [Config_Field]='AirType'");
ViewBag.CarType = SqlModule.GetDataTable(" SELECT [Config_Title] as CarType,Config_Value as Price FROM [ConfigInfomation] where [Config_Field]='CarType'");
if (data.Rows.Count == 0)
{
return(Content("Không tìm thấy"));
}
return(View(data.Rows[0]));
}
public ActionResult UpdateGiaoDich(int ID, string NoiDung, string PhuPhi, int TinhTrang)
{
PhuPhi = (PhuPhi + "").Replace(",", "");
var nd = LoginAuth.StaffInfo(Session);
//1. Update tình trạng
SqlModule.ExcuteCommand($"UPDATE BookingHotel SET Booking_Status={TinhTrang},Booking_Surcharge='{PhuPhi}' WHERE BookingHotel_ID=" + ID);
//2. Lưu lại lịch sử
SqlModule.ExcuteCommand($@"INSERT INTO [dbo].[BookingHotel_history]
([BookingHotel_ID]
,[Content]
,[Booking_Status]
,[CreatedBy]
,[Created])
VALUES
({ID}
,N'{NoiDung}'
,{TinhTrang}
,{nd.User_ID}
,getdate())");
return(JsonMax("OK"));
}
public ActionResult ListHotelGrid(string star = "", string price = "", string night = "", string KeySearch = "")
{
if (string.IsNullOrEmpty(star))
{
star = "*";
}
if (string.IsNullOrEmpty(price))
{
price = "*";
}
if (string.IsNullOrEmpty(night))
{
night = "*";
}
if (string.IsNullOrEmpty(KeySearch))
{
KeySearch = "*";
}
string sql = $@"SELECT TOP 10 * FROM VHotel where Hotel_ID in (select Hotel_ID FROM [VHotel_FILTER] WHERE
(DayFILTER in (select value from string_split('#night#',',')) OR '#night#'='*')
AND (PriceFILTER in (select value from string_split('#price#',',')) OR '#price#'='*')
AND (StarFILTER in (select value from string_split('#star#',',')) OR '#star#'='*'))
AND CHARINDEX(dbo.fChuyenCoDauThanhKhongDau(N'*'),dbo.fChuyenCoDauThanhKhongDau(Hotel_Name+'*')) !=0";
sql = sql.Replace("#star#", star);
sql = sql.Replace("#price#", price);
sql = sql.Replace("#night#", night);
sql = sql.Replace("#KeySearch#", KeySearch);
var data = SqlModule.GetDataTable(sql);
ViewBag.Hotel_Facilities = SqlModule.GetDataTable(" SELECT * FROM [Hotel_Facilities]");
ViewBag.KeySearch = KeySearch == "*" ? "Danh sách Hotel" : KeySearch;
return(PartialView(data));
}
public ActionResult DanhGia(int TourID)
{
var data = SqlModule.GetDataTable("SELECT * FROM V_Tour_Evaluate ORDER BY Created desc");
return(PartialView(data));
}
public ActionResult DanhGiaNoiBat(int TourID)
{
var data = SqlModule.GetDataTable("SELECT top 2 * FROM V_Tour_Evaluate ORDER BY Score desc");
return(PartialView(data));
}
public ActionResult DelHotel(int ID = 0)
{
SqlModule.ExcuteCommand(" DELETE [Hotel] WHERE Hotel_ID=" + ID);
return(JsonMax(new { result = "Success" }));
}
public ActionResult onRowRemoving(int Banner_ID)
{
SqlModule.ExcuteCommand("delete banner where Banner_ID=" + Banner_ID);
return(JsonMax(new { result = "OK" }));
}
// GET: CamNang
public ActionResult Index()
{
ViewBag.CamNang = SqlModule.GetDataTable(" SELECT top 4 t1.[Post_id] ,t1.[Post_Tile] ,t1.[Post_Images] ,t1.[Post_CategoryID] ,t1.[Post_Slug],t1.Post_CreateDate,T1.Post_Location FROM [Post] t1");
ViewBag.DiaDiem = SqlModule.GetDataTable(" SELECT top 4 [Location_ID],[Location_Name] ,[Location_images] FROM [Location]");
return(View());
}
public ActionResult DelTour(int ID = 0)
{
SqlModule.ExcuteCommand(" DELETE [Tour] WHERE Tour_ID=" + ID);
return(JsonMax(new { result = "Success" }));
}
public ActionResult LienQuan(float Hotel_Score)
{
var data = SqlModule.GetDataTable(" SELECT top 4 Hotel_ID,Hotel_Name,Hotel_Price,HotelImage ,Hotel_Score,Hotel_StarRate FROM [VHotel] WHERE Hotel_Score=" + Hotel_Score);
return(PartialView(data));
}
public ActionResult Support()
{
var data = SqlModule.GetDataTable("select * from [ContactInfo]");
return(PartialView(data));
}
public ActionResult HuyVoucher(int ID = 0)
{
SqlModule.ExcuteCommand(" UPDATE[Voucher] SET[Voucher_Active] = 0 WHERE Voucher_ID=" + ID);
return(JsonMax(new { result = "Success" }));
}
// GET: Tours
public ActionResult Index()
{
ViewBag.Status = SqlModule.GetDataTable(" select Tour_Active , StatusTour,count(StatusTour) as Qty from VTour GROUP BY Tour_Active, StatusTour ");
return(View());
}
public void Insert()
{
string sql = @"INSERT INTO [dbo].[BookingTour]
([Tour_ID]
,[BookingTour_NumberPassenger]
,[Booking_CreateDate]
,[Booking_DepartureDate]
,[Booking_ArrivalDate]
,[Booking_Status]
,[Booking_TotalPrice]
,[HoTen]
,[Phone]
,[Email]
,[YeuCauDacBiet]
,[adult_number]
,[child_number]
,[BABY_number]
,[CarType]
,[AirType]
,[Room_ID]
)
VALUES
(N'#Tour_ID#'
, N'#BookingTour_NumberPassenger#'
, GETDATE()
, '#Booking_DepartureDate#'
, '#Booking_ArrivalDate#'
, N'#Booking_Status#'
, N'#Booking_TotalPrice#'
, N'#HoTen#'
, N'#Phone#'
, N'#Email#'
, N'#YeuCauDacBiet#'
, #adult_number#
, #child_number#
, #BABY_number#
, N'#CarType#'
, N'#AirType#'
, N'#Room_ID#'
)";
sql = sql.Replace("#Tour_ID#", this.Tour_ID.ToString());
sql = sql.Replace("#BookingTour_NumberPassenger#", this.BookingTour_NumberPassenger.ToString());
var status = SqlModule.GetDataTable("SELECT top 1 Config_id FROM [ConfigInfomation] WHERE [Config_Field]='BookingTourStatus' order by Config_Value").FirstOrDefault("Config_id");
sql = sql.Replace("#Booking_Status#", status);
sql = sql.Replace("#Booking_TotalPrice#", this.Booking_TotalPrice.ToString());
sql = sql.Replace("#Phone#", this.Phone);
sql = sql.Replace("#HoTen#", this.HoTen);
sql = sql.Replace("#Email#", this.Email);
sql = sql.Replace("#YeuCauDacBiet#", this.YeuCauDacBiet);
sql = sql.Replace("#adult_number#", this.adult_number.ToString());
sql = sql.Replace("#child_number#", this.child_number.ToString());
sql = sql.Replace("#BABY_number#", this.BABY_number.ToString());
sql = sql.Replace("#CarType#", this.CarType);
sql = sql.Replace("#AirType#", this.AirType);
sql = sql.Replace("#Room_ID#", this.Room_ID);
sql = sql.Replace("#Booking_DepartureDate#", this.Booking_DepartureDate.ToString("yyyy-MM-dd"));
sql = sql.Replace("#Booking_ArrivalDate#", this.Booking_ArrivalDate.ToString("yyyy-MM-dd"));
SqlModule.ExcuteCommand(sql);
}
public ActionResult HotelInfo(int Hotel_ID)
{
var data = SqlModule.GetDataTable(" SELECT Hotel_Name,Hotel_Content ,Hotel_Facilities_ID,Tag_ID FROM Hotel WHERE Hotel_ID=" + Hotel_ID);
return(PartialView(data));
}
public ActionResult LienQuan(int Tour_Location)
{
var data = SqlModule.GetDataTable(" SELECT top 4 Tour_ID,Tour_Name,Tour_Price,Tour_Image,Tour_TimeZoneText,Tour_StarRate FROM [VTour] WHERE Tour_Fixed =1 AND Tour_Active=1 and Tour_Location=" + Tour_Location);
return(PartialView(data));
}
public ActionResult Index()
{
ViewBag.Status = SqlModule.GetDataTable(" select Voucher_Active , StatusVoucher,count(StatusVoucher) as Qty from VVoucher GROUP BY Voucher_Active, StatusVoucher ");
return(View());
}
protected override void Act()
{
SqlModule.New();
}
public ActionResult DangLaiTour(int ID = 0)
{
SqlModule.ExcuteCommand(" UPDATE[Tour] SET[Tour_Active] = 1 WHERE Tour_ID=" + ID);
return(JsonMax(new { result = "Success" }));
}
public ActionResult AddTour()
{
Models.Tour tuor = new Tour();
ViewBag.Hotel = SqlModule.GetDataTable("SELECT [Hotel_ID],[Hotel_Name] FROM [Hotel]");
return(View(tuor));
}
public ActionResult ThongTinKhach(int ID)
{
var data = SqlModule.GetDataTable($"SELECT * FROM VBookingTour where {ID} IN ( BookingTour_ID)");
return(PartialView(data));
}
