private void BindData()
{
Advertisments obj = new Advertisments();
obj.AdvID = Convert.ToInt32(Request.QueryString["id"]);
DataTable dt = obj.SelectOneDataTable();
if (dt != null && dt.Rows.Count > 0)
{
string _tmp = string.Empty;
string _imageDomain = ConfigurationManager.AppSettings["ImageUrl"].ToString();
switch (dt.Rows[0]["Type"].ToString())
{
//Ảnh
case "1":
if (!string.IsNullOrEmpty(dt.Rows[0]["FilePath"].ToString()))
{
_tmp = "<img src=\"" + _imageDomain + dt.Rows[0]["FilePath"] + "\" border=\"0\">";
}
break;
default:
break;
}
ltrAdv.Text = _tmp;
}
}
protected void grdList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow editRow = grdList.Rows[e.RowIndex];
Advertisments adv = new Advertisments();
adv.AdvID = Convert.ToInt32((editRow.FindControl("hiddenAdvID") as HiddenField).Value);
adv.Delete();
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Advertisments obj = new Advertisments();
List <Advertisments> dt = new List <Advertisments>();
int page = 0, pos = 0;
page = function.Obj2Int(this.ddlPages.SelectedValue);
pos = function.Obj2Int(this.ddlPosition.SelectedValue);
dt = obj.SelectAllLikeByPagePosition("%" + this.txtKeyword.Text.Trim() + "%", page, pos);
grdList.DataSource = dt;
grdList.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
int advID = 0;
if (!string.IsNullOrEmpty(Request.QueryString["advId"]))
{
advID = function.Obj2Int(Request.QueryString["advId"]);
}
adver = new Advertisments();
adver.AdvID = advID;
if (advID > 0)
{
adver = adver.SelectOne();
}
adver.Name = adv_name.Text;
adver.FilePath = txtSelectedFile.Value;
adver.StartDate = !string.IsNullOrEmpty(ui_date_picker_range_from.Value)?Convert.ToDateTime(ui_date_picker_range_from.Value):DateTime.Now;
adver.EndDate = !string.IsNullOrEmpty(ui_date_picker_range_to.Value)?Convert.ToDateTime(ui_date_picker_range_to.Value):DateTime.Now.AddYears(3);
adver.Embed = "";
adver.Description = adv_description.Text;
adver.IsActive = adv_isActive.Checked;
adver.IsRotate = false;
adver.Link = txtIcon.Value;
adver.Order = function.Obj2Int(adv_order.Text);
adver.Type = function.Obj2Int(adv_type.SelectedValue);
//adver.Width = function.Obj2Int(Request.Form["txtContent"].ToString());
//adver.Height = function.Obj2Int(Request.Form["txtContent"].ToString());
if (advID > 0)
{
adver.Update();
}
else
{
adver.Insert();
}
Response.Redirect("/office/bannerlist.aspx");
}
private void BindData()
{
Adv_Position objPos = new Adv_Position();
List <Adv_Position> _pos = objPos.SelectAllLike("");// AdvHelper.AdvGetAllPositions();
if (_pos != null && _pos.Count > 0)
{
ddlPosition.DataSource = _pos;
ddlPosition.DataBind();
ddlPosition.Items.Insert(0, new ListItem("chon vi tri", "0"));
}
Adv_Page_Position objPage = new Adv_Page_Position();
DataTable _pages = CategoryHelper.GetCategoriesByParent(0);//.SelectAllLike("");//.AdvGetAllPages();
if (_pages != null && _pages.Rows.Count > 0)
{
ddlPages.DataSource = _pages;
ddlPages.DataBind();
ddlPages.Items.Insert(0, new ListItem("Trang chủ", "0"));
}
Advertisments obj = new Advertisments();
List <Advertisments> dt = new List <Advertisments>();
dt = obj.SelectAllLike("");
if (dt != null && dt.Count > 0)
{
grdList.DataSource = dt;
grdList.DataBind();
grdList.Attributes.Add("ria-describedby", "sample_editable_1_info");
grdList.HeaderRow.TableSection = TableRowSection.TableHeader;
grdList.HeaderRow.Attributes.Add("role", "row");
}
}
public double GetCompanyOrder()
{
var SP1 = Advertisments.Count(_ => _.Value.GetQResultTypeExtended() == QResultTypeExtended.SP1);
var SP2 = Advertisments.Count(_ => _.Value.GetQResultTypeExtended() == QResultTypeExtended.SP2);
var SP3 = Advertisments.Count(_ => _.Value.GetQResultTypeExtended() == QResultTypeExtended.SP3);
var G1 = Advertisments.Count(_ => _.Value.GetQResultTypeExtended() == QResultTypeExtended.G1);
var G2 = Advertisments.Count(_ => _.Value.GetQResultTypeExtended() == QResultTypeExtended.G2);
var G3 = Advertisments.Count(_ => _.Value.GetQResultTypeExtended() == QResultTypeExtended.G3);
var G4 = Advertisments.Count(_ => _.Value.GetQResultTypeExtended() == QResultTypeExtended.G4);
var G5 = Advertisments.Count(_ => _.Value.GetQResultTypeExtended() == QResultTypeExtended.G5);
var advCount = SP1 + SP2 + SP3 + G1 + G2 + G3 + G4 + G5;
var notCoveredQueries = _totalQueriesCount - advCount;
var advRaiting =
SP1 * 1.6 +
SP2 * 1.5 +
SP3 * 1.4 +
G1 * 0.7 +
G2 * 0.6 +
G3 * 0.5 +
G4 * 0.4 +
G5 * 0.3 +
notCoveredQueries * 0.3;
/*
* 0,3 Пустых
* 1,6 СР1
* 1,5 СР2
* 1,4 СР3
* 0,7 Г1
* 0,6 Г2
* 0,5 Г3
* 0,4 Г4
* 0,3 Г5*/
return(advRaiting);
}
private void BindData()
{
Adv_Page_Position objPage = new Adv_Page_Position();
DataTable _pages = CategoryHelper.GetCategoriesByParent(0);
if (_pages != null && _pages.Rows.Count > 0)
{
cblPages.DataSource = _pages;
cblPages.DataBind();
cblPages.Items.Insert(0, new ListItem("Trang chủ", "0"));
}
if (cblPages.Items.Count > 0)
{
foreach (ListItem item in cblPages.Items)
{
item.Attributes.Add("cid", item.Value);
}
}
Adv_Position objPos = new Adv_Position();
List <Adv_Position> _pos = objPos.SelectAllLike("");// AdvHelper.AdvGetAllPositions();
if (_pos != null && _pos.Count > 0)
{
ddlPos.DataSource = _pos;
ddlPos.DataBind();
}
if (Request.QueryString["AdvId"] != null && Request.QueryString["AdvId"].ToString() != "")
{
int advID = function.Obj2Int(Request.QueryString["AdvId"]);
// hidAdvId.Value = advID.ToString();
btnSave.OnClientClick = String.Format("Save({0}, {1})", advID, "false");
// btnDelete.OnClientClick = String.Format("return Delete({0})", advID);
if (advID > 0)
{
Advertisments objAdver = new Advertisments();
objAdver.AdvID = advID;
objAdver = objAdver.SelectOne();
this.adv_name.Text = objAdver.Name.ToString();
this.adv_type.SelectedValue = objAdver.Type.ToString();
//adv_embed.Text = objAdver.Embed;
adv_description.Text = objAdver.Description;
txtIcon.Value = objAdver.Link;
ui_date_picker_range_from.Value = objAdver.StartDate.ToString("MM/dd/yyyy");
ui_date_picker_range_to.Value = objAdver.EndDate.ToString("MM/dd/yyyy");
txtSelectedFile.Value = objAdver.FilePath;
adv_isRotate.Checked = objAdver.IsRotate; // Convert.ToBoolean(row["IsRotate"]);
adv_isActive.Checked = objAdver.IsActive; // Convert.ToBoolean(row["IsActive"]);
adv_order.Text = objAdver.Order.ToString(); // row["Order"].ToString();
List <Adv_Page_Position> lsPagePos = new List <Adv_Page_Position>();
lsPagePos = objPage.SelectAllByAdvID(advID);
//DataTable pages = AdvHelper.GetAllPosByAd(advID);
if (lsPagePos != null && lsPagePos.Count > 0)
{
foreach (ListItem item in cblPages.Items)
{
for (int i = 0; i < lsPagePos.Count; i++)
{
if (item.Value == lsPagePos[i].CatID.ToString())
{
item.Selected = true;
}
}
}
}
}
}
}
