protected void btDelete_Click(object sender, EventArgs e)
{
string ArrayId = "";
for (int i = 0; i < rptList.Items.Count; i++)
{
CheckBox chkDelete = (CheckBox)rptList.Items[i].FindControl(("chk_item"));
if (chkDelete != null)
{
if (chkDelete.Checked)
{
ArrayId += chkDelete.ToolTip;
ArrayId += ",";
}
}
else
{
return;
}
}
if (ArrayId.Length > 0)
{
ArrayId = ArrayId.Substring(0, (ArrayId.Length - 1));
}
else
{
return;
}
condition = " isid in(" + ArrayId + ") ";
Subitems.DeleteSubitemsCondition(condition);
chk_list.Checked = false;
GetListComments();
}
protected void btOK_Click(object sender, EventArgs e)
{
Subitems.InsertSubitems(iid, lang, app, tbName.Text, tbNoiDung.Text, "", "", tbName.Text, isid, DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), "1");
tbName.Text = "";
tbNoiDung.Text = "";
GetListReply();
}
protected void btnTest_Click(object sender, EventArgs e)
{
if (btnHandler != null)
{
btnHandler(string.Empty);
}
if (suc.Equals(TypePage.UpdateItem))
{
GetInfoUpdate();
Subitems.DeleteSubitemsCondition(DataExtension.AndConditon(SubitemsTSql.GetSubitemsByIid(iid),
SubitemsTSql.GetSubitemsByVskey(keysubitem),
SubitemsTSql.GetSubitemsByVslang(lang)));
Subitems.InsertSubitems(iid, lang, keysubitem, "", "", "", "", "", "",
DateTime.Now.ToString(), "", "", "1");
}
else
{
GetIidNew();
Subitems.InsertSubitems(iid, lang, keysubitem, "", "", "", "", "", "",
"", "", "", "1");
}
Response.Redirect(LinkAdmin.GoAdminCategory(CodeApplications.Tour, TypePage.Item, igid));
}
protected void btOK_Click(object sender, EventArgs e)
{
#region Trạng thái
string trangThai = "0";
if (cbTrangThai.Checked == true)
{
trangThai = "1";
}
#endregion
if (isid != "")
{
string image = flAnhDaiDien.Save(true, "");
Subitems.UpdateSubitems(iid, lang, app, tbTieuDe.Text, tbMoTa.Text, image, "", tbThuTu.Text, "",
DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), trangThai, isid);
//ScriptManager.RegisterStartupScript(this, this.GetType(), "",
//"jAlert('Đã sửa: " + tbTieuDe.Text + "','Thông báo')", true);
ltrThongBao.Text = "Thông báo: đã sửa " + tbTieuDe.Text;
}
else
{
string image = flAnhDaiDien.Save(false, "");
Subitems.InsertSubitems(iid, lang, app, tbTieuDe.Text, tbMoTa.Text, image, "", tbThuTu.Text, "",
DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), trangThai);
//ScriptManager.RegisterStartupScript(this, this.GetType(), "",
//"jAlert('Đã tạo: " + tbTieuDe.Text + "','Thông báo')", true);
ltrThongBao.Text = "Thông báo: đã tạo " + tbTieuDe.Text;
}
ResetControls();
}
string LayLichTrinh(string iid)
{
string s = "";
string condition = DataExtension.AndConditon(
SubitemsTSql.GetSubitemsByVskey(TatThanhJsc.TourModul.CodeApplications.TourItinerary),
SubitemsTSql.GetSubitemsByIid(iid),
SubitemsTSql.GetSubitemsByVslang(lang),
SubitemsColumns.IsenableColumn + "<>2");
string order = "[dbo].[RemoveTextIfNotIsFloat](" + SubitemsColumns.VsatuthorColumn + ")";
DataTable dt = Subitems.GetSubItems("", "*", condition, order);
for (int i = 0; i < dt.Rows.Count; i++)
{
s += @"
<div class='nb-card'>
<div class='nb-head'>
<a href='#' class='title nb-collapse-toggle'>
<span>" + StringExtension.LayChuoi(dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", 1) + @"</span> - " + StringExtension.LayChuoi(dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", 2) + @"
<span class='icon-toggle'></span>
</a>
</div>
<div class='nb-body'>
<div class='wap'>
" + dt.Rows[i][SubitemsColumns.VscontentColumn].ToString() + @"
</div>
</div>
</div>";
}
return(s);
}
void OpenUpdatePanel(string isid)
{
ltrInsertUpdate.Text = "Cập nhật hình ảnh";
update = true;
currentIsid.Value = isid;
pnList.Visible = false;
pnInsert.Visible = true;
condition = SubitemsTSql.GetSubitemsByIsid(isid);
DataTable dt = new DataTable();
dt = Subitems.GetSubItems("", "*", condition, "");
if (dt.Rows.Count > 0)
{
try
{
rblColors.SelectedValue = dt.Rows[0][SubitemsColumns.VsemailColumn].ToString();
}
catch { }
tbName.Text = dt.Rows[0][SubitemsColumns.VstitleColumn].ToString();
tbOrder.Text = dt.Rows[0][SubitemsColumns.VsatuthorColumn].ToString();
ddlStatus.SelectedValue = dt.Rows[0][SubitemsColumns.IsenableColumn].ToString();
ltimg.Text = ImagesExtension.GetImage(pathFolderPic, dt.Rows[0][SubitemsColumns.VsimageColumn].ToString(), "", "hotelImage", false, false, "");
hd_img = dt.Rows[0][SubitemsColumns.VsimageColumn].ToString();
}
}
private void Add()
{
Subitems.Add(new HierarchicalElementViewModel(this)
{
Name = "Child Element"
});
}
void OpenUpdatePanel(string isid)
{
ltrInsertUpdate.Text = "Cập nhật loại";
update = true;
currentIsid.Value = isid;
pnList.Visible = false;
pnInsert.Visible = true;
condition = SubitemsTSql.GetSubitemsByIsid(isid);
DataTable dt = new DataTable();
dt = Subitems.GetSubItems("", "*", condition, "");
if (dt.Rows.Count > 0)
{
tbName.Text = dt.Rows[0][SubitemsColumns.VstitleColumn].ToString();
tbOrder.Text = dt.Rows[0][SubitemsColumns.VsatuthorColumn].ToString();
ddlStatus.SelectedValue = dt.Rows[0][SubitemsColumns.IsenableColumn].ToString();
ltimg.Text = ImagesExtension.GetImage(pathFolderPic, dt.Rows[0][SubitemsColumns.VsimageColumn].ToString(), "", "hotelImage", false, false, "");
hd_img = dt.Rows[0][SubitemsColumns.VsimageColumn].ToString();
tbMoTa.Text = StringExtension.LayChuoi(dt.Rows[0][SubitemsColumns.VscontentColumn].ToString(), "", 1);
tbParam2.Text = StringExtension.LayChuoi(dt.Rows[0][SubitemsColumns.VscontentColumn].ToString(), "", 2);
tbParam3.Text = StringExtension.LayChuoi(dt.Rows[0][SubitemsColumns.VscontentColumn].ToString(), "", 3);
tbParam1.Text = dt.Rows[0][SubitemsColumns.VsurlColumn].ToString();
tbPrice.Text = StringExtension.LayChuoi(dt.Rows[0][SubitemsColumns.VsemailColumn].ToString(), "", 1);
tbPriceOld.Text = StringExtension.LayChuoi(dt.Rows[0][SubitemsColumns.VsemailColumn].ToString(), "", 2);
tbCreateDate.Text = dt.Rows[0][SubitemsColumns.DscreatedateColumn].ToString();
tbEnddate.Text = dt.Rows[0][SubitemsColumns.DsenddateColumn].ToString();
}
}
private void GetOtherImages(string iid)
{
string condition = DataExtension.AndConditon(
SubitemsTSql.GetSubitemsByVskey(CodeApplications.HotelPhoto),
SubitemsTSql.GetSubitemsByIid(iid),
SubitemsTSql.GetSubitemsByVslang(lang),
SubitemsColumns.IsenableColumn + "<>2"
);
string order = "[dbo].[RemoveTextIfNotIsFloat](" + SubitemsColumns.VsatuthorColumn + ")";
DataTable dt = Subitems.GetSubItems("", "*", condition, order);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ltrMainImages.Text += @"
<div class='item'>
<a href='javascript:void(0)' class='imgc'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString(), dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", true, false, "", false) + @"
</a>
</div>";
ltrOtherImages.Text += @"
<div class='item'>
<a href='javascript:void(0)' class='imgc'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString(), dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", true, false, "", false) + @"
</a>
</div>";
}
}
}
protected void RpListNoticeBQT_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string c = e.CommandName.Trim();
string p = e.CommandArgument.ToString().Trim();
top = "";
fields = "*";
condition = DataExtension.AndConditon(SubitemsTSql.GetSubitemsByIsid(p));
order = "";
DataTable dt = new DataTable();
dt = Subitems.GetSubItems(top, fields, condition, order);
switch (c)
{
case "edit":
PnShow.Visible = false;
PnFormNotice.Visible = true;
TbTtl.Text = dt.Rows[0]["VSTITLE"].ToString();
TbContent.Text = dt.Rows[0]["VSCONTENT"].ToString();
HdInsertUpdate.Value = "update";
HdIsid.Value = p;
GetListMes();
break;
case "del":
Subitems.DeleteSubitems(p);
GetListMes();
break;
}
}
private string GetOtherImages2(string iid)
{
string s = "";
string s1 = "";
string condition = DataExtension.AndConditon
(
SubitemsTSql.GetSubitemsByIid(iid),
SubitemsTSql.GetSubitemsByVskey(CodeApplications.ProductImagesOther),
SubitemsTSql.GetByEnable("1")
);
string pic = TatThanhJsc.ProductModul.FolderPic.Product;
string orderby = SubitemsColumns.VsatuthorColumn;
DataTable dt = new DataTable();
dt = Subitems.GetSubItems("", "*", condition, orderby);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
s1 += @"
<div class='list-picture__item fade-up'>
<div class='img'>
<a href='" + UrlExtension.WebisteUrl + pic + "/" + dt.Rows[i][SubitemsColumns.VsimageColumn] + @"' data-fancybox='gallery' class='img__crop'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString(), dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", true, false, "", false) + @"
</a>
</div>
</div>";
}
}
return(s1);
}
protected override bool IsValidSubType(IHTMLItem item)
{
// may appear only once and only as first element
if (item is TableCaption)
{
if (Subitems.Count > 0)
{
return(false);
}
IHTMLItem seekItem = Subitems.Find(x => x is TableCaption);
if (seekItem != null)
{
return(false);
}
return(item.IsValid());
}
if (item is ColElement)
{
return(item.IsValid());
}
if (item is ColGroup)
{
return(item.IsValid());
}
if (item is TableBody)
{
IHTMLItem seekItem = Subitems.Find(x => x is TableBody);
if (seekItem != null)
{
return(false);
}
seekItem = Subitems.Find(x => x is TableRow);
if (seekItem != null)
{
return(false);
}
return(item.IsValid());
}
if (item is TableRow)
{
IHTMLItem seekItem = Subitems.Find(x => x is TableBody);
if (seekItem != null)
{
return(false);
}
seekItem = Subitems.Find(x => x is TableHead);
if (seekItem != null)
{
return(false);
}
seekItem = Subitems.Find(x => x is TableFooter);
if (seekItem != null)
{
return(false);
}
return(item.IsValid());
}
return(false);
}
private void LayDanhSachLichTrinh()
{
string s = "";
string iid = "";
if (Request["iid"] != null)
{
iid = StringExtension.RemoveSqlInjectionChars(Request["iid"]);
}
string condition = DataExtension.AndConditon(
SubitemsTSql.GetSubitemsByVskey(app),
SubitemsTSql.GetSubitemsByIid(iid),
SubitemsTSql.GetSubitemsByVslang(lang),
SubitemsColumns.IsenableColumn + "<>2"
);
string order = "[dbo].[RemoveTextIfNotIsFloat](" + SubitemsColumns.VsatuthorColumn + ")";
DataTable dt = Subitems.GetSubItems("", "*", condition, order);
if (dt.Rows.Count > 0)
{
s += @"
<table class='formatted'>
<tr>
<th class='stt'>TT</th>
<th>Hoạt động</th>
<th>Điểm đến</th>
<th>Bữa ăn</th>
<th class='thuTu'>Thứ tự</th>
<th class='trangThai'>Trạng thái</th>
<th class='congCu'>Công cụ</th>
</tr>";
for (int i = 0; i < dt.Rows.Count; i++)
{
s += @"
<tr id='row_" + dt.Rows[i][SubitemsColumns.IsidColumn] + @"'>
<td class='tac'>" + (i + 1) + @"</td>
<td>" + StringExtension.LayChuoi(dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", 1) + ": " + StringExtension.LayChuoi(dt.Rows[i][SubitemsColumns.VstitleColumn].ToString(), "", 2) + @"<br/>
" + ImagesExtension.GetImage(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString(), "", "itiImage", false, true, dt.Rows[i][SubitemsColumns.VscontentColumn].ToString()) + @"
</td>
<td>" + HienThiDiemDen(dt.Rows[i][SubitemsColumns.VsurlColumn].ToString()) + @"</td>
<td>" + HienThiBuaAn(dt.Rows[i][SubitemsColumns.VsemailColumn].ToString()) + @"</td>
<td class='tac'>" + dt.Rows[i][SubitemsColumns.VsatuthorColumn].ToString() + @"</td>
<td class='tac'><span class='EnableIcon" + dt.Rows[i][SubitemsColumns.IsenableColumn] + @"'> </span></td>
<td class='tac'>
<a href='javascript:EditItinerary(" + dt.Rows[i][SubitemsColumns.IsidColumn] + @")' class='iconEdit'>Sửa</a>
<a href='javascript:DeleteItinerary(" + dt.Rows[i][SubitemsColumns.IsidColumn] + @")' class='iconDelete'>Xóa</a>
</td>
</tr>";
}
s += "</table>";
}
Response.Write(s);
}
private void LayDanhSachLoaiPhong()
{
string s = "";
string iid = "";
if (Request["iid"] != null)
{
iid = StringExtension.RemoveSqlInjectionChars(Request["iid"]);
}
string condition = DataExtension.AndConditon(
SubitemsTSql.GetSubitemsByVskey(app),
SubitemsTSql.GetSubitemsByIid(iid),
SubitemsTSql.GetSubitemsByVslang(lang),
SubitemsColumns.IsenableColumn + "<>2"
);
string order = SubitemsColumns.isOrder;
DataTable dt = Subitems.GetSubItems("", "*", condition, order);
if (dt.Rows.Count > 0)
{
s += @"
<table class='formatted'>
<tr>
<th class='stt'>TT</th>
<th>Loại phòng</th>
<th>Sức chứa</th>
<th>Giá</th>
<th class='thuTu'>Thứ tự</th>
<th class='trangThai'>Trạng thái</th>
<th class='congCu'>Công cụ</th>
</tr>";
for (int i = 0; i < dt.Rows.Count; i++)
{
s += @"
<tr id='row_" + dt.Rows[i][SubitemsColumns.IsidColumn] + @"'>
<td class='tac'>" + (i + 1) + @"</td>
<td>" + dt.Rows[i][SubitemsColumns.VstitleColumn] + @"<br/>
" + ImagesExtension.GetImage(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString(), "", "itiImage", false, true, dt.Rows[i][SubitemsColumns.VscontentColumn].ToString()) + @"
</td>
<td class='tac'>" + dt.Rows[i][SubitemsColumns.isTotalSubitem] + @"</td>
<td class='tac'>" + PriceExtension.HienThiGia(dt.Rows[i][SubitemsColumns.fsPrice].ToString(), dt.Rows[i][SubitemsColumns.fsSalePrice].ToString()) + @"</td>
<td class='tac'>" + dt.Rows[i][SubitemsColumns.isOrder] + @"</td>
<td class='tac'><span class='EnableIcon" + dt.Rows[i][SubitemsColumns.IsenableColumn] + @"'> </span></td>
<td class='tac'>
<a href='javascript:EditRoomType(" + dt.Rows[i][SubitemsColumns.IsidColumn] + @")' class='iconEdit'>Sửa</a>
<a href='javascript:DeleteRoomType(" + dt.Rows[i][SubitemsColumns.IsidColumn] + @")' class='iconDelete'>Xóa</a>
</td>
</tr>";
}
s += "</table>";
}
Response.Write(s);
}
/// <summary>
/// Xoá tên trường và xoá dữ liệu trong subitems theo mã ứng dụng, mã trường này
/// </summary>
/// <param name="igid">igid của trường</param>
void DeleteDealFields(string igid)
{
string condition = GroupsTSql.GetGroupsByIgid(igid);
DataTable dt = new DataTable();
dt = Groups.GetGroups("", GroupsColumns.VgdescColumn, condition, "");
Subitems.DeleteSubitemsCondition(DataExtension.AndConditon(SubitemsTSql.GetSubitemsByVslang(language), SubitemsTSql.GetSubitemsByVskey(app), SubitemsTSql.GetSubitemsByVsemail(dt.Rows[0][GroupsColumns.VgdescColumn].ToString())));
Groups.DeleteGroups(GroupsTSql.GetGroupsByIgid(igid));
}
private void DeleteSubItems(string iid, string pic)
{
DataTable dt = new DataTable();
dt = Subitems.GetSubItems("", SubitemsColumns.IsidColumn, SubitemsTSql.GetSubitemsByIid(iid), "");
for (int i = 0; i < dt.Rows.Count; i++)
{
subItemControl.DeleteSubItem(dt.Rows[i][SubitemsColumns.IsidColumn].ToString(), pic);
}
}
protected void btOK_Click(object sender, EventArgs e)
{
#region Bao gồm - included
string baoGom = "";
for (int i = 0; i < cblBaoGom.Items.Count; i++)
{
if (cblBaoGom.Items[i].Selected)
{
baoGom += cblBaoGom.Items[i].Value + ",";
}
}
if (baoGom != "")
{
baoGom = baoGom.Remove(baoGom.Length - ",".Length);
}
#endregion
string chiTiet = ContentExtendtions.ProcessStringContent(tbChiTiet.Text, hdChiTiet.Value, pic);
#region Trạng thái
string trangThai = "0";
if (cbTrangThai.Checked == true)
{
trangThai = "1";
}
#endregion
if (isid != "")
{
string image = flAnhDaiDien.Save(true, chiTiet);
Subitems.UpdateSubitemsFull(iid, lang, app, tbLoaiPhong.Text, chiTiet, image, baoGom, "", tbHuongPhong.Text,
DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), trangThai, isid,
tbGiaNiemYet.Text,
tbGiaKhuyenMai.Text, "", "", "", tbSuChuaToiDa.Text, tbThuTu.Text,
ddlCoTheTraPhongKhong.SelectedValue, ddlCoGomBuaSangKhong.SelectedValue, tbDienTichPhong.Text,
tbLoaiGiuong.Text, DateTime.Now.ToString(), DateTime.Now.ToString());
ltrThongBao.Text = "Thông báo: đã sửa " + tbLoaiPhong.Text;
}
else
{
string image = flAnhDaiDien.Save(false, chiTiet);
Subitems.InsertSubitemsFull(iid, lang, app, tbLoaiPhong.Text, chiTiet, image, baoGom, "", tbHuongPhong.Text,
DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), trangThai, tbGiaNiemYet.Text,
tbGiaKhuyenMai.Text, "", "", "", tbSuChuaToiDa.Text, tbThuTu.Text,
ddlCoTheTraPhongKhong.SelectedValue, ddlCoGomBuaSangKhong.SelectedValue, tbDienTichPhong.Text,
tbLoaiGiuong.Text, DateTime.Now.ToString(), DateTime.Now.ToString());
ltrThongBao.Text = "Thông báo: đã tạo " + tbLoaiPhong.Text;
}
ResetControls();
}
/// <summary>
/// Đếm số hình ảnh trong một album
/// </summary>
/// <param name="iid"></param>
/// <returns></returns>
public static string CountSubItems(string iid)
{
string condition = DataExtension.AndConditon(
SubitemsTSql.GetSubitemsByIid(iid),
SubitemsTSql.GetSubitemsByIsenable("1"),
SubitemsTSql.GetSubitemsByVskey(TatThanhJsc.PhotoAlbumModul.CodeApplications.PhotoAlbumImagesOther));
DataTable dt = new DataTable();
dt = Subitems.GetSubItems("", SubitemsColumns.IsidColumn, condition, "");
return(NumberExtension.FormatNumber(dt.Rows.Count.ToString()));
}
private void DeletePhoto()
{
string isid = "";
if (Request["isid"] != null)
{
isid = StringExtension.RemoveSqlInjectionChars(Request["isid"]);
}
Subitems.UpdateSubitems(SubitemsTSql.GetSubitemsByIsenable("2"), SubitemsTSql.GetSubitemsByIsid(isid));
}
protected void UpdateTitle(object sender, EventArgs e)
{
TextBox textbox = sender as TextBox;
string[] fields = { SubitemsColumns.VstitleColumn };
string[] values = { "N'" + textbox.Text + "'" };
string condition = SubitemsTSql.GetSubitemsByIsid(textbox.ToolTip);
Subitems.UpdateSubitems(DataExtension.UpdateTransfer(fields, values), condition);
//GetListDeals("");
}
/// <summary>
/// Đếm comment cho một blog
/// </summary>
/// <param name="iid"></param>
/// <returns></returns>
public static string CountComment(string iid)
{
string app = TatThanhJsc.BlogModul.CodeApplications.BlogComment;
string condition = DataExtension.AndConditon(
SubitemsTSql.GetByIid(iid),
SubitemsTSql.GetByApp(app),
SubitemsTSql.GetByEnable("1")
);
DataTable dt = Subitems.GetSubItems("", SubitemsColumns.IsidColumn, condition, "");
return(NumberExtension.FormatNumber(dt.Rows.Count.ToString()));
}
void DeleteComment(string isid)
{
#region Xoá trả lời của comment
DataTable dt = new DataTable();
dt = Subitems.GetSubItems("", "*", DataExtension.AndConditon(SubitemsTSql.GetSubitemsByVskey(app + "Reply"), SubitemsTSql.GetSubitemsByVsurl(isid)), "");
for (int i = 0; i < dt.Rows.Count; i++)
{
ImagesExtension.DeleteImageWhenDeleteItem(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString());
Subitems.DeleteSubitems(dt.Rows[i][SubitemsColumns.IsidColumn].ToString());
}
#endregion
Subitems.DeleteSubitems(isid);
}
void GetList(string iid)
{
DataTable dt = new DataTable();
condition = DataExtension.AndConditon(
SubitemsTSql.GetSubitemsByIid(iid),
SubitemsTSql.GetSubitemsByVskey(app)
);
orderBy = SubitemsColumns.VstitleColumn;
dt = Subitems.GetSubItems("", "*", condition, orderBy);
rptList.DataSource = dt;
rptList.DataBind();
}
public override bool IsValid()
{
IEnumerable <IHTMLItem> captions = Subitems.FindAll(x => x is FigCaption);
foreach (var figCaption in captions) // figcaption can be only first or last element
{
if (figCaption != Subitems.First() && figCaption != Subitems.Last())
{
return(false);
}
}
return(true);
}
void GetInfoUpdate()
{
condition = DataExtension.AndConditon(SubitemsTSql.GetSubitemsByIid(iid),
SubitemsTSql.GetSubitemsByVskey(keysubitem),
SubitemsTSql.GetSubitemsByVslang(lang));
DataTable dt = new DataTable();
dt = Subitems.GetSubItems("1", " isid, VSTITLE ", condition, "");
if (dt.Rows.Count > 0)
{
isid = dt.Rows[0][SubitemsColumns.IsidColumn].ToString();
}
}
void GetList()
{
condition = DataExtension.AndConditon
(
SubitemsTSql.GetSubitemsByIid(iid),
SubitemsTSql.GetSubitemsByVskey(app)
);
orderby = SubitemsColumns.VsemailColumn + " asc," + SubitemsColumns.VsatuthorColumn + " asc";
DataTable dt = new DataTable();
dt = Subitems.GetSubItems("", "*", condition, orderby);
rptList.DataSource = dt;
rptList.DataBind();
}
void GetListComments()
{
condition = DataExtension.AndConditon
(
SubitemsTSql.GetSubitemsByIid(iid),
SubitemsTSql.GetSubitemsByVskey(app)
);
orderby = SubitemsColumns.DscreatedateColumn + " desc ";
DataTable dt = new DataTable();
dt = Subitems.GetSubItems("", "*", condition, orderby);
rptList.DataSource = dt;
rptList.DataBind();
}
private void InitialControlsValue()
{
//Trường hợp sửa loại phòng
if (isid != "")
{
string condition = DataExtension.AndConditon(SubitemsTSql.GetSubitemsByVskey(app),
SubitemsTSql.GetSubitemsByIsid(isid));
DataTable dt = Subitems.GetSubItems("1", "*", condition, "");
if (dt.Rows.Count > 0)
{
tbLoaiPhong.Text = dt.Rows[0][SubitemsColumns.VstitleColumn].ToString();
tbSuChuaToiDa.Text = dt.Rows[0][SubitemsColumns.isTotalSubitem].ToString();
tbGiaNiemYet.Text = dt.Rows[0][SubitemsColumns.fsPrice].ToString();
tbGiaKhuyenMai.Text = dt.Rows[0][SubitemsColumns.fsSalePrice].ToString();
#region Bao gồm
string baoGom = "," + dt.Rows[0][SubitemsColumns.VsemailColumn] + ",";
for (int i = 0; i < cblBaoGom.Items.Count; i++)
{
if (baoGom.IndexOf("," + cblBaoGom.Items[i].Value + ",") > -1)
{
cblBaoGom.Items[i].Selected = true;
}
else
{
cblBaoGom.Items[i].Selected = false;
}
}
#endregion
tbChiTiet.Text = dt.Rows[0][SubitemsColumns.VscontentColumn].ToString();
hdChiTiet.Value = dt.Rows[0][SubitemsColumns.VscontentColumn].ToString();
flAnhDaiDien.Load(dt.Rows[0][SubitemsColumns.VsimageColumn].ToString());
ddlCoTheTraPhongKhong.SelectedValue = dt.Rows[0][SubitemsColumns.isParam1].ToString();
ddlCoGomBuaSangKhong.SelectedValue = dt.Rows[0][SubitemsColumns.isParam2].ToString();
tbDienTichPhong.Text = dt.Rows[0][SubitemsColumns.vsParam1].ToString();
tbLoaiGiuong.Text = dt.Rows[0][SubitemsColumns.vsParam2].ToString();
tbHuongPhong.Text = dt.Rows[0][SubitemsColumns.VsurlColumn].ToString();
tbThuTu.Text = dt.Rows[0][SubitemsColumns.isOrder].ToString();
cbTrangThai.Checked = (dt.Rows[0][SubitemsColumns.IsenableColumn].ToString() == "1");
}
}
}
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string name = e.CommandName;
string id = e.CommandArgument.ToString();
switch (name)
{
case "delete":
Subitems.DeleteSubitems(id);
GetListReply();
break;
default: break;
}
}
protected void btnadd_Click(object sender, EventArgs e)
{
int[] iidArry = new int[lstnotadded.Rows + 1];
iidArry = lstnotadded.GetSelectedIndices();
if (iidArry.Length > 0)
{
for (int i = 0; i < iidArry.Length; i++)
{
Subitems.InsertSubitems(igid, language, "PIP", lstnotadded.Items[iidArry[i]].Value, "", "", "", "", "", DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), "1");
}
lstnotadded.Items.Clear();
lstadded.Items.Clear();
GetProductGroups(ddl_groups.SelectedValue);
}
}
