public void xemTour(String id)
{
System.Diagnostics.Debug.WriteLine("3");
matour.Value = id;
using (SqlConnection cnn = new SqlConnection(cnnString))
{
cnn.Open();
SqlCommand cmd = new SqlCommand("sp_xemTourId", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idTour", id);
SqlDataReader rd = cmd.ExecuteReader();
if (rd.HasRows)
{
while (rd.Read())
{
idt_.InnerHtml = "<input type='hidden' id='matour_' value='" + rd["imatour"].ToString() + "'>";
txtMaTour.Value = rd["imatour"].ToString();
txtTieuDe.Text = rd["sTieuDe"].ToString();
txtMoTaTour.Text = rd["sMoTa"].ToString();
//String date = String.Format("{0:yyyy-MM-dd}", rd["dNgayKhoiHanh"]);
// txtNgayKhoiHanh1.Text = date;
txtSoNgayDi.Text = rd["sTongThoiGian"].ToString();
txtSoCho.Text = rd["iSoCho"].ToString();
txtGiaNLgiam.Text = rd["igianlgiam"].ToString();
txtGIaNL.Text = rd["igianl"].ToString();
txtGiaTE.Text = rd["igiate"].ToString();
txtGiaTEgiam.Text = rd["igiategiam"].ToString();
txtNoiKhoiHanh.Text = rd["snoikhoihanh"].ToString();
ddlNhomtour.SelectedValue = rd["iMaNhomTour"].ToString();
txtHanGiamNL.Text = DateTime.Parse(rd["hanGiamNL"].ToString()).ToString("yyyy-MM-dd");
txtHanGiamTE.Text = DateTime.Parse(rd["hanGiamTE"].ToString()).ToString("yyyy-MM-dd");
// anhtour.Value = rd["sUrlAnh"].ToString();
/*string[] tokens = rd["sUrlAnh"].ToString().Split('/');
* // Label2.Text = "< button type = 'button' class='btn btn-primary'>Primary</button>";//;;tokens[0] + tokens.Length.ToString();
* // Label2.Text = tokens[0];
* //soAnh.Value = tokens.Length.ToString();
*
* DataTable dt = new DataTable();
* dt.Clear();
* dt.Columns.Add("url");
* dt.Columns.Add("id");
*
* for (int i = 0; i < tokens.Length; i++)
* {
* DataRow row = dt.NewRow();
* row["url"] = tokens[i];
* row["id"] = i;
* dt.Rows.Add(row);
* }
* //Repeater Rpt1 = Page.FindControl("rptDSanh") as Repeater;*/
DataTable dataHinHAnh = tourController.layHinhAnh(id);
rptDSanh.DataSource = dataHinHAnh;
rptDSanh.DataBind();
}
}
}
}
public void xemTour(String id)
{
//System.Diagnostics.Debug.WriteLine("3");
maTour_.Value = id;
matourhidden.InnerHtml = "<input type='hidden' id='txtMaTour_' value = '" + id + "'>";
SqlDataReader rd = tourController.xemTour(id);
if (rd.HasRows)
{
while (rd.Read())
{
txtDanhGia.InnerHtml = "" + rd["soSao"] + "<i class='fa fa-star' style='font - size: 18px; color: #ffca08;'></i>";
txtNKH.InnerHtml = rd["sNoiKhoiHanh"] + "";
txtTG.InnerHtml = rd["stongthoigian"] + "";
// txtTE.InnerHtml = "<strike style='color: red; display: inline;'>"+Convert.ToInt32(rd["igiate"].ToString()).ToString("#,##0") + "</strike>   <b style='color: green; display: inline;'>" + Convert.ToInt32(rd["igiategiam"].ToString()).ToString("#,##0") + "</b>VND";
// Debug.WriteLine("ss " + (DateTime.Parse(rd["hangiamte"].ToString()) > DateTime.Now) );
if (DateTime.Parse(rd["hangiamte"].ToString()) > DateTime.Now) //Convert.ToInt32(rd["igiategiam"].ToString()) == 0 &&
{
txtTE.InnerHtml = "<strike style='color: red; display: inline;'>" + Convert.ToInt32(rd["igiate"].ToString()).ToString("#,##0") + "</strike>   <b style='color: green; display: inline;'>" + Convert.ToInt32(rd["igiategiam"].ToString()).ToString("#,##0") + "</b>VND";
}
else
{
txtTE.InnerHtml = "<p style='color: green;display: inline;'>" + Convert.ToInt32(rd["igiate"].ToString()).ToString("#,##0") + "</p>   <b style='color: green; display: inline;'>" + "</b>VND";
}
if (DateTime.Parse(rd["hangiamnl"].ToString()) > DateTime.Now) //Convert.ToInt32(rd["igiategiam"].ToString()) == 0 &&
{
txtNL.InnerHtml = "<strike style='color: red;display: inline;'>" + Convert.ToInt32(rd["igianl"].ToString()).ToString("#,##0") + "</strike>   <b style='color: green; display: inline;'>" + Convert.ToInt32(rd["igianlgiam"].ToString()).ToString("#,##0") + "</b>VND";
}
else
{
txtNL.InnerHtml = "<p style='color: green;display: inline;'>" + Convert.ToInt32(rd["igianl"].ToString()).ToString("#,##0") + "</p>   <b style='color: green; display: inline;'>" + "</b>VND";
}
DataTable dataTable = tourController.layHinhAnh(id);
anhDD.InnerHtml = "<img src='../../Upload/" + dataTable.Rows[0]["sDuongDan"] + "' alt=' 'class='alignleft img-responsive'>";
dataTable.Rows[0].Delete();
rpt1.DataSource = dataTable;
rpt1.DataBind();
rpt2.DataSource = dataTable;
rpt2.DataBind();
txtNoiDung.Text = rd["sMoTa"].ToString();
// System.Diagnostics.Debug.WriteLine(rd["sMoTa"].ToString());
txtTieuDe.Text = rd["sTieuDe"].ToString();
int giaTE = Convert.ToInt32(rd["igiate"]);//.ToString();
int giaTEgiam = Convert.ToInt32(rd["igiategiam"]);
int giaNL = Convert.ToInt32(rd["igianl"]);
int giaNLgiam = Convert.ToInt32(rd["igianlgiam"]);
string htmlGia = "<input type='hidden' id='giaNL' value ='";
if (giaNLgiam == 0 || (DateTime.Parse(rd["hangiamnl"].ToString()) < DateTime.Now))
{
htmlGia += giaNL;
}
else
{
htmlGia += giaNLgiam;
}
if (giaTEgiam == 0 || (DateTime.Parse(rd["hangiamte"].ToString()) < DateTime.Now))
{
htmlGia += "' /><input type='hidden' id ='giaTE' value = '" + giaTE;
}
else
{
htmlGia += "' /><input type='hidden' id ='giaTE' value = '" + giaTEgiam;
}
gia.InnerHtml = htmlGia + "' /> ";
hiddenIdTour.InnerHtml = "<input type='hidden' id='idTour' name='idTour' value='" + rd["iMaTour"].ToString() + "' />";
}
}
}
