private void LoadSidebarItems(int curItem, DataTable dtCommands)
{
int _curCommandId = ConvertUtility.ToInt32(curItem);
DataRow[] _lstCommands = dtCommands.Select("CommandParentID = " + curItem + " AND CommandVisible = 1");
foreach (DataRow row in _lstCommands)
{
if (ConvertUtility.ToBoolean(row["CommandVisible"]) == false || ConvertUtility.ToBoolean(row["CommandEnable"]) == false)
{
continue;
}
string name = "";
string url = "";
name = row["CommandName"].ToString();
//_item.Value = row["CommandID"].ToString();
if (!String.IsNullOrEmpty(row["CommandUrl"].ToString().Trim()))
{
url = row["CommandUrl"].ToString();
}
else if (row["CommandKey"].ToString() != string.Empty)
{
url = AppEnv.AdminUrlParams(row["CommandKey"].ToString()) + row["CommandParams"].ToString();
}
curItem = ConvertUtility.ToInt32(row["CommandID"].ToString());
_lstCommands = dtCommands.Select("CommandParentID = " + curItem + " AND CommandVisible = 1");
if (listCmd.Contains(row["CommandID"].ToString()))
{
sb.Append("<li class=\"active\">");
}
else
{
sb.Append("<li>");
}
if (_lstCommands.Length > 0)
{
sb.Append(string.Format(fmAuS, url, name));
sb.Append("<ul class=\"sub-menu\">");
LoadSidebarItems(ConvertUtility.ToInt32(row["CommandID"].ToString()), dtCommands);
sb.Append("</ul>");
}
else
{
sb.Append(string.Format(fmAdS, url, name));
}
sb.Append("</li>");
}
}
public static ContentInfo GetInfo(int content_ID)
{
ContentInfo retVal = null;
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("CMS_Contents_GetInfo", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Content_ID", content_ID);
try
{
dbConn.Open();
var dr = dbCmd.ExecuteReader();
if (dr.Read())
{
retVal = new ContentInfo();
retVal.Content_ID = ConvertUtility.ToInt32(dr["Content_ID"]);
retVal.Content_Name = ConvertUtility.ToString(dr["Content_Name"]);
retVal.Content_Teaser = ConvertUtility.ToString(dr["Content_Teaser"]);
retVal.Content_Body = ConvertUtility.ToString(dr["Content_Body"]);
retVal.Content_CreateDate = ConvertUtility.ToDateTime(dr["Content_CreateDate"]);
retVal.Content_ModifiedDate = ConvertUtility.ToDateTime(dr["Content_ModifiedDate"]);
retVal.Content_Status = ConvertUtility.ToInt32(dr["Content_Status"]);
retVal.Content_OriginalZoneID = ConvertUtility.ToInt32(dr["Content_OriginalZoneID"]);
retVal.Content_UserID = ConvertUtility.ToInt32(dr["Content_UserID"]);
retVal.Content_ModifiedUserID = ConvertUtility.ToInt32(dr["Content_ModifiedUserID"]);
retVal.Content_Author = ConvertUtility.ToString(dr["Content_Author"]);
retVal.Content_EventDate = ConvertUtility.ToDateTime(dr["Content_EventDate"]);
retVal.Content_FriendlyUrl = ConvertUtility.ToString(dr["Content_FriendlyUrl"]);
retVal.Content_Comment = ConvertUtility.ToString(dr["Content_Comment"]);
retVal.Content_ExcludeFromSearch = ConvertUtility.ToBoolean(dr["Content_ExcludeFromSearch"]);
retVal.Content_IsPhoto = ConvertUtility.ToBoolean(dr["Content_IsPhoto"]);
retVal.Content_IsDownload = ConvertUtility.ToBoolean(dr["Content_IsDownload"]);
retVal.Content_IsVideo = ConvertUtility.ToBoolean(dr["Content_IsVideo"]);
retVal.Content_IsPoll = ConvertUtility.ToBoolean(dr["Content_IsPoll"]);
retVal.Content_IsProduct = ConvertUtility.ToBoolean(dr["Content_IsProduct"]);
retVal.Content_Visible = ConvertUtility.ToBoolean(dr["Content_Visible"]);
retVal.Content_IsTemp = ConvertUtility.ToBoolean(dr["Content_IsTemp"]);
}
if (dr != null)
{
dr.Close();
}
}
finally
{
dbConn.Close();
}
return(retVal);
}
protected void butUpdate_Click(object sender, EventArgs e)
{
var info = HocsinhDB.GetInfo(_hocsinhid);
info.Hocsinh_IsLearning = ConvertUtility.ToBoolean(chkIsLearning.Checked);
try
{
HocsinhDB.Update(info);
lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR;
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnInit(e);
if (CurrentUser.IsSuperAdmin)// || CurrentUser.IsAdmin
{
this.Visible = true;
}
else
{
DataTable dt = CommandController.GetRoleForUserByPortalID(CurrentUser.UserID, ConvertUtility.ToInt32(AppEnv.PortalId()));
if (dt.Rows.Count > 0)
{
if (dt.Rows.Count > 1)
{
pmsRole = ConvertUtility.ToBoolean(dt.Rows[0]["Role_Delete"]);
pmsRole1 = ConvertUtility.ToBoolean(dt.Rows[1]["Role_Delete"]);
if (!pmsRole && !pmsRole1)
{
this.Visible = false;
}
else
{
this.Visible = true;
}
}
else
{
pmsRole = ConvertUtility.ToBoolean(dt.Rows[0]["Role_Delete"]);
if (!pmsRole)
{
this.Visible = false;
}
else
{
this.Visible = true;
}
}
}
else
{
this.Visible = false;
}
}
}
public void ToBooleanTest()
{
Assert.AreEqual(true, ConvertUtility.ToBoolean("Y"));
Assert.AreEqual(true, ConvertUtility.ToBoolean("Yes"));
Assert.AreEqual(true, ConvertUtility.ToBoolean("T"));
Assert.AreEqual(true, ConvertUtility.ToBoolean("True"));
Assert.AreEqual(true, ConvertUtility.ToBoolean("1"));
Assert.AreEqual(false, ConvertUtility.ToBoolean("N"));
Assert.AreEqual(false, ConvertUtility.ToBoolean("No"));
Assert.AreEqual(false, ConvertUtility.ToBoolean("F"));
Assert.AreEqual(false, ConvertUtility.ToBoolean("False"));
Assert.AreEqual(false, ConvertUtility.ToBoolean("0"));
Assert.AreEqual(false, ConvertUtility.ToBoolean("Testing"));
Assert.AreEqual(true, ConvertUtility.ToBoolean("Testing", true));
}
protected void rptdv87_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemIndex < 0)
{
return;
}
DataRowView curData = (DataRowView)e.Item.DataItem;
HyperLink lnkdv87 = (HyperLink)e.Item.FindControl("lnkdv87");
Literal ltrDangCapNhat = (Literal)e.Item.FindControl("ltrDangCapNhat");
DataSet dtcheck = ThethaoController.GetAll_Sport87_DetailBy_PK_Game87ID(curData["PK_Game87_ID"].ToString());
if (ConvertUtility.ToBoolean(dtcheck.Tables[0].Rows[0]["IsFull"]))
{
if (lang == 1)
{
lnkdv87.Text = "<span class=\"blue\">" + curData["Name"].ToString() + "</span>";
}
else
{
lnkdv87.Text = "<span class=\"blue\">" + UnicodeUtility.UnicodeToKoDau(curData["Name"].ToString()) + "</span>";
}
//Charging
//string content = cpid + "&" + Constant.thethao + "9" + curData["Game87_Id"].ToString() + "&" + price + "&" + vmstransactionid;
//lnkdv87.NavigateUrl = UrlProcess.GetSportDV87Url(lang.ToString(), "support", width, curData["PK_Game87_ID"].ToString());
//lnkTaive.NavigateUrl = UrlProcess.GetSportDV87Url(lang.ToString(), "support", width, curData["PK_Game87_ID"].ToString());
//lnkdv87.NavigateUrl = ConfigurationSettings.AppSettings.Get("vms3g") + "?link=" + Server.UrlEncode(EAS.EncryptData(content, ConfigurationSettings.AppSettings.Get("vmskey")));
lnkdv87.NavigateUrl = "../TuVanDacBiet.aspx?id=" + curData["Game87_Id"].ToString() + "&lang=" + lang + "&w=" + width;
}
else
{
if (lang == 1)
{
lnkdv87.Text = curData["Name"].ToString();
ltrDangCapNhat.Text = "(đang cập nhật)";
}
else
{
ltrDangCapNhat.Text = "(dang cap nhat)";
lnkdv87.Text = UnicodeUtility.UnicodeToKoDau(curData["Name"].ToString());
}
lnkdv87.NavigateUrl = null;
}
}
public static MemberInfo GetInfo(int member_ID)
{
MemberInfo retVal = null;
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("Main_Members_GetInfo", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Member_ID", member_ID);
try
{
dbConn.Open();
var dr = dbCmd.ExecuteReader();
if (dr.Read())
{
retVal = new MemberInfo();
retVal.Member_ID = ConvertUtility.ToInt32(dr["Member_ID"]);
retVal.Member_Email = ConvertUtility.ToString(dr["Member_Email"]);
retVal.Member_Password = ConvertUtility.ToString(dr["Member_Password"]);
retVal.Member_Fullname = ConvertUtility.ToString(dr["Member_Fullname"]);
retVal.Member_Gender = ConvertUtility.ToInt32(dr["Member_Gender"]);
retVal.Member_Avatar = ConvertUtility.ToString(dr["Member_Avatar"]);
retVal.Member_Tel = ConvertUtility.ToString(dr["Member_Tel"]);
retVal.Member_Address = ConvertUtility.ToString(dr["Member_Address"]);
retVal.Member_District = ConvertUtility.ToString(dr["Member_District"]);
retVal.Member_City = ConvertUtility.ToString(dr["Member_City"]);
retVal.Member_Rank = ConvertUtility.ToInt32(dr["Member_Rank"]);
retVal.Member_Birthday = ConvertUtility.ToDateTime(dr["Member_Birthday"]);
retVal.Member_Active = ConvertUtility.ToBoolean(dr["Member_Active"]);
retVal.Member_ActiveCode = ConvertUtility.ToString(dr["Member_ActiveCode"]);
retVal.Member_IsForgotPassword = ConvertUtility.ToBoolean(dr["Member_IsForgotPassword"]);
}
if (dr != null)
{
dr.Close();
}
}
finally
{
dbConn.Close();
}
return(retVal);
}
public static VideoInfo GetInfo(int video_ID)
{
VideoInfo retVal = null;
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("CMS_Videos_GetInfo", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Video_ID", video_ID);
try
{
dbConn.Open();
var dr = dbCmd.ExecuteReader();
if (dr.Read())
{
retVal = new VideoInfo();
retVal.Video_ID = ConvertUtility.ToInt32(dr["Video_ID"]);
retVal.Video_Name = ConvertUtility.ToString(dr["Video_Name"]);
retVal.Video_Description = ConvertUtility.ToString(dr["Video_Description"]);
retVal.Video_Type = ConvertUtility.ToString(dr["Video_Type"]);
retVal.Video_File = ConvertUtility.ToString(dr["Video_File"]);
retVal.Video_YouTube = ConvertUtility.ToString(dr["Video_YouTube"]);
retVal.Video_Width = ConvertUtility.ToInt32(dr["Video_Width"]);
retVal.Video_Height = ConvertUtility.ToInt32(dr["Video_Height"]);
retVal.Video_CreateDate = ConvertUtility.ToDateTime(dr["Video_CreateDate"]);
retVal.Video_View = ConvertUtility.ToInt32(dr["Video_View"]);
retVal.User_ID = ConvertUtility.ToInt32(dr["User_ID"]);
retVal.Video_Visible = ConvertUtility.ToBoolean(dr["Video_Visible"]);
}
if (dr != null)
{
dr.Close();
}
}
finally
{
dbConn.Close();
}
return(retVal);
}
protected void rptdv87_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemIndex < 0)
{
return;
}
DataRowView curData = (DataRowView)e.Item.DataItem;
HyperLink lnkdv87 = (HyperLink)e.Item.FindControl("lnkdv87");
Literal ltrDangCapNhat = (Literal)e.Item.FindControl("ltrDangCapNhat");
DataSet dtcheck = ThethaoController.GetAll_Sport87_DetailBy_PK_Game87ID(curData["PK_Game87_ID"].ToString());
if (ConvertUtility.ToBoolean(dtcheck.Tables[0].Rows[0]["IsFull"]))
{
//if (lang == 1)
//{
lnkdv87.Text = "<span class=\"blue\">" + curData["Name"].ToString() + "</span>";
//}
//else
//{
// lnkdv87.Text = "<span class=\"blue\">" + UnicodeUtility.UnicodeToKoDau(curData["Name"].ToString()) + "</span>";
//}
//lnkdv87.NavigateUrl = "../TuVanDacBiet.aspx?id=" + curData["Game87_Id"].ToString() + "&lang=" + lang + "&w=" + width;
lnkdv87.NavigateUrl = UrlProcess.TheThaoTranCauVang(curData["Game87_Id"].ToString());
}
else
{
//if (lang == 1)
//{
lnkdv87.Text = curData["Name"].ToString();
ltrDangCapNhat.Text = "(đang cập nhật)";
//}
//else
//{
// ltrDangCapNhat.Text = "(dang cap nhat)";
// lnkdv87.Text = UnicodeUtility.UnicodeToKoDau(curData["Name"].ToString());
//}
lnkdv87.NavigateUrl = null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string httpMethod = Request.HttpMethod;
string estateId = ConvertUtility.Trim(Request.QueryString["id"]);
if (httpMethod.Equals("get", StringComparison.OrdinalIgnoreCase))
{
EstateFwService estateService = new EstateFwService();
this.Estate = estateService.GetEstateById(estateId);
}
else
{
//AddData
string buildName = ConvertUtility.Trim(Request.Form["buildName"]);
string address = ConvertUtility.Trim(Request.Form["address"]);
int x_cnt = ConvertUtility.ToInt(Request.Form["x_cnt"]);
bool x_except = ConvertUtility.ToBoolean(Request.Form["x_except"]);
int y_cnt_b = ConvertUtility.ToInt(Request.Form["y_cnt_b"]);
int y_cnt_e = ConvertUtility.ToInt(Request.Form["y_cnt_e"]);
bool y_except = ConvertUtility.ToBoolean(Request.Form["y_except"]);
BuildFwService buildService = new BuildFwService();
if (buildService.AddBuild(estateId, buildName, address, x_cnt, x_except, y_cnt_b, y_cnt_e, y_except))
{
Response.Write("true");
}
else
{
Response.Write("false");
}
Response.End();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static ImageInfo GetCover(int contentId)
{
ImageInfo retVal = null;
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("CMS_Images_GetCover", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Content_ID", contentId);
try
{
dbConn.Open();
var dr = dbCmd.ExecuteReader();
if (dr.Read())
{
retVal = new ImageInfo();
retVal.Image_ID = ConvertUtility.ToInt32(dr["Image_ID"]);
retVal.Image_Name = ConvertUtility.ToString(dr["Image_Name"]);
retVal.Image_Description = ConvertUtility.ToString(dr["Image_Description"]);
retVal.Image_File = ConvertUtility.ToString(dr["Image_File"]);
retVal.Image_CreateDate = ConvertUtility.ToDateTime(dr["Image_CreateDate"]);
retVal.Image_FileSize = ConvertUtility.ToDouble(dr["Image_FileSize"]);
retVal.Image_Width = ConvertUtility.ToInt32(dr["Image_Width"]);
retVal.Image_Height = ConvertUtility.ToInt32(dr["Image_Height"]);
retVal.Image_View = ConvertUtility.ToInt32(dr["Image_View"]);
retVal.User_ID = ConvertUtility.ToInt32(dr["User_ID"]);
retVal.Image_Visible = ConvertUtility.ToBoolean(dr["Image_Visible"]);
}
if (dr != null)
{
dr.Close();
}
}
finally
{
dbConn.Close();
}
return(retVal);
}
public static HocsinhInfo GetInfo(int hocsinh_ID)
{
HocsinhInfo retVal = null;
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("Solart_Hocsinh_GetInfo", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Hocsinh_ID", hocsinh_ID);
try
{
dbConn.Open();
var dr = dbCmd.ExecuteReader();
if (dr.Read())
{
retVal = new HocsinhInfo();
retVal.Hocsinh_ID = ConvertUtility.ToInt32(dr["Hocsinh_ID"]);
retVal.Hocsinh_Name = ConvertUtility.ToString(dr["Hocsinh_Name"]);
retVal.Hocsinh_Parent = ConvertUtility.ToString(dr["Hocsinh_Parent"]);
retVal.Hocsinh_Email = ConvertUtility.ToString(dr["Hocsinh_Email"]);
retVal.Hocsinh_Tel = ConvertUtility.ToString(dr["Hocsinh_Tel"]);
retVal.Hocsinh_Address = ConvertUtility.ToString(dr["Hocsinh_Address"]);
retVal.Hocsinh_Birthday = ConvertUtility.ToString(dr["Hocsinh_Birthday"]);
retVal.Hocsinh_Note = ConvertUtility.ToString(dr["Hocsinh_Note"]);
retVal.Hocsinh_CreateDate = ConvertUtility.ToDateTime(dr["Hocsinh_CreateDate"]);
retVal.Hocsinh_IsLearning = ConvertUtility.ToBoolean(dr["Hocsinh_IsLearning"]);
}
if (dr != null)
{
dr.Close();
}
}
finally
{
dbConn.Close();
}
return(retVal);
}
public static DownloadInfo GetInfo(int download_ID)
{
DownloadInfo retVal = null;
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("CMS_Download_GetInfo", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Download_ID", download_ID);
try
{
dbConn.Open();
var dr = dbCmd.ExecuteReader();
if (dr.Read())
{
retVal = new DownloadInfo();
retVal.Download_ID = ConvertUtility.ToInt32(dr["Download_ID"]);
retVal.Download_Name = ConvertUtility.ToString(dr["Download_Name"]);
retVal.Download_Description = ConvertUtility.ToString(dr["Download_Description"]);
retVal.Download_File = ConvertUtility.ToString(dr["Download_File"]);
retVal.Download_Extension = ConvertUtility.ToString(dr["Download_Extension"]);
retVal.Download_Visible = ConvertUtility.ToBoolean(dr["Download_Visible"]);
retVal.Download_CreateDate = ConvertUtility.ToDateTime(dr["Download_CreateDate"]);
retVal.Download_FileSize = ConvertUtility.ToDouble(dr["Download_FileSize"]);
retVal.Download_View = ConvertUtility.ToInt32(dr["Download_View"]);
retVal.User_ID = ConvertUtility.ToInt32(dr["User_ID"]);
}
if (dr != null)
{
dr.Close();
}
}
finally
{
dbConn.Close();
}
return(retVal);
}
public static DistributionInfo GetInfo(int distribution_ID)
{
DistributionInfo retVal = null;
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("CMS_Distributions_GetInfo", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Distribution_ID", distribution_ID);
try
{
dbConn.Open();
var dr = dbCmd.ExecuteReader();
if (dr.Read())
{
retVal = new DistributionInfo();
retVal.Distribution_ID = ConvertUtility.ToInt32(dr["Distribution_ID"]);
retVal.Distribution_ContentID = ConvertUtility.ToInt32(dr["Distribution_ContentID"]);
retVal.Distribution_ZoneID = ConvertUtility.ToInt32(dr["Distribution_ZoneID"]);
retVal.Distribution_CreateDate = ConvertUtility.ToDateTime(dr["Distribution_CreateDate"]);
retVal.Distribution_Rank = ConvertUtility.ToInt32(dr["Distribution_Rank"]);
retVal.Distribution_View = ConvertUtility.ToInt32(dr["Distribution_View"]);
retVal.Distribution_Priority = ConvertUtility.ToInt32(dr["Distribution_Priority"]);
retVal.Distribution_Layout = ConvertUtility.ToString(dr["Distribution_Layout"]);
retVal.Distribution_DisableTeaser = ConvertUtility.ToBoolean(dr["Distribution_DisableTeaser"]);
retVal.Distribution_DisableAvatar = ConvertUtility.ToBoolean(dr["Distribution_DisableAvatar"]);
}
if (dr != null)
{
dr.Close();
}
}
finally
{
dbConn.Close();
}
return(retVal);
}
protected void butUpdateAll_Click(object sender, EventArgs e)
{
try
{
foreach (DataGridItem item in dtgOrder.Items)
{
int id = ConvertUtility.ToInt32(item.Cells[0].Text);
HocsinhInfo info = HocsinhDB.GetInfo(id);
var chkIsLearning = (CheckBox)item.FindControl("chkIsLearning");
info.Hocsinh_IsLearning = ConvertUtility.ToBoolean(chkIsLearning.Checked);
HocsinhDB.Update(info);
}
lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR; //ex.ToString();
}
}
public static KhoahocInfo GetInfo(int contentId)
{
KhoahocInfo retVal = null;
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("Solart_Khoahoc_GetInfo", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Content_ID", contentId);
try
{
dbConn.Open();
var dr = dbCmd.ExecuteReader();
if (dr.Read())
{
retVal = new KhoahocInfo();
retVal.Khoahoc_ID = ConvertUtility.ToInt32(dr["Khoahoc_ID"]);
retVal.Content_ID = ConvertUtility.ToInt32(dr["Content_ID"]);
retVal.Zone_ID = ConvertUtility.ToInt32(dr["Zone_ID"]);
retVal.Khoehoc_NoiDungHoc = ConvertUtility.ToString(dr["Khoehoc_NoiDungHoc"]);
retVal.Khoahoc_DoTuoi = ConvertUtility.ToString(dr["Khoahoc_DoTuoi"]);
retVal.Khoahoc_DoTuoiText = ConvertUtility.ToString(dr["Khoahoc_DoTuoiText"]);
retVal.Khoahoc_GioHoc = ConvertUtility.ToString(dr["Khoahoc_GioHoc"]);
retVal.Khoahoc_KhaiGiang = ConvertUtility.ToString(dr["Khoahoc_KhaiGiang"]);
retVal.Khoahoc_Avaiable = ConvertUtility.ToBoolean(dr["Khoahoc_Avaiable"]);
}
if (dr != null)
{
dr.Close();
}
}
finally
{
dbConn.Close();
}
return(retVal);
}
protected void butDelAll_Click(object sender, EventArgs e)
{
try
{
foreach (DataGridItem item in dtgMail.Items)
{
// CheckBox chkSelect = (CheckBox)item.FindControl("chkSelect");
// if(chkSelect.Checked)
// {
int id = ConvertUtility.ToInt32(item.Cells[0].Text);
MailInfo info = MailDB.GetInfo(id);
CheckBox chkAnswer = (CheckBox)item.FindControl("chkAnswer");
info.Mail_Answer = ConvertUtility.ToBoolean(chkAnswer.Checked);
MailDB.Update(info);
// }
}
lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR; //ex.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (ConvertUtility.ToBoolean(AppEnv.AdvInZone))
{
ZoneUtility.LoadZones(lstZones.Items); lstZones.Enabled = true;
}
else
{
lstZones.Enabled = false;
}
lstZones.Items.Insert(0, new ListItem("Root 0", "0"));
lstZones.SelectedIndex = 0;
lstPositions.DataSource = PositionDB.GetAll();
lstPositions.DataTextField = "Pos_Name";
lstPositions.DataValueField = "Pos_ID";
lstPositions.DataBind();
lstPositions.SelectedIndex = -1;
MiscUtility.SetSelected(lstPositions.Items, PosSelected.ToString());
}
lblUpdateStatus.Text = string.Empty;
}
protected void dtgProduct_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "delete")
{
int id = ConvertUtility.ToInt32(e.Item.Cells[0].Text);
try
{
HocsinhDB.Delete(id);
lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR;
}
}
if (e.CommandName == "updaterow")
{
try
{
int id = ConvertUtility.ToInt32(e.Item.Cells[0].Text);
HocsinhInfo info = HocsinhDB.GetInfo(id);
var chkIsLearning = (CheckBox)e.Item.FindControl("chkIsLearning");
info.Hocsinh_IsLearning = ConvertUtility.ToBoolean(chkIsLearning.Checked);
HocsinhDB.Update(info);
lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR; //ex.ToString();
}
}
}
public List <UserInfo> GetListUser(int pageIndex, int pageSize, out int totalrow)
{
List <UserInfo> list = null;
var param = new[]
{
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@totalrow", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
SqlCommand cmd;
var r = DataHelper.ExecuteReader(Config.ConnectionString, "usp_User_GetList", param, out cmd);
list = new List <UserInfo>();
while (r.Read())
{
list.Add(new UserInfo
{
id = (int)r["id"],
sUsername = ConvertUtility.ToString(r["sUsername"]),
sFullName = r["sFullName"].ToString(),
sEmail = r["sEmail"].ToString(),
sAddress = r["sAddress"].ToString(),
sMobile = r["sMobile"].ToString(),
sCompany = r["sCompany"].ToString(),
sHomepage = r["sHomepage"].ToString(),
CreateDate = System.Convert.ToDateTime(r["CreateDate"]),
active = ConvertUtility.ToBoolean(r["active"])
});
}
r.Close(); r.Dispose();
totalrow = (int)cmd.Parameters[2].Value;
return(list);
}
private static MemberInfo CreateEntityFromReader(IDataReader reader)
{
var item = new MemberInfo();
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_ID")))
{
item.Member_ID = ConvertUtility.ToInt32(reader["Member_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_Email")))
{
item.Member_Email = ConvertUtility.ToString(reader["Member_Email"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_Password")))
{
item.Member_Password = ConvertUtility.ToString(reader["Member_Password"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_Fullname")))
{
item.Member_Fullname = ConvertUtility.ToString(reader["Member_Fullname"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_Gender")))
{
item.Member_Gender = ConvertUtility.ToInt32(reader["Member_Gender"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_Avatar")))
{
item.Member_Avatar = ConvertUtility.ToString(reader["Member_Avatar"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_Tel")))
{
item.Member_Tel = ConvertUtility.ToString(reader["Member_Tel"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_Address")))
{
item.Member_Address = ConvertUtility.ToString(reader["Member_Address"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_District")))
{
item.Member_District = ConvertUtility.ToString(reader["Member_District"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_City")))
{
item.Member_City = ConvertUtility.ToString(reader["Member_City"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_Rank")))
{
item.Member_Rank = ConvertUtility.ToInt32(reader["Member_Rank"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_Birthday")))
{
item.Member_Birthday = ConvertUtility.ToDateTime(reader["Member_Birthday"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_Active")))
{
item.Member_Active = ConvertUtility.ToBoolean(reader["Member_Active"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_ActiveCode")))
{
item.Member_ActiveCode = ConvertUtility.ToString(reader["Member_ActiveCode"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Member_IsForgotPassword")))
{
item.Member_IsForgotPassword = ConvertUtility.ToBoolean(reader["Member_IsForgotPassword"]);
}
}
catch { }
return(item);
}
private static ZoneInfo CreateEntityFromReader(IDataReader reader)
{
var item = new ZoneInfo();
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_ID")))
{
item.Zone_ID = ConvertUtility.ToInt32(reader["Zone_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_ParentID")))
{
item.Zone_ParentID = ConvertUtility.ToInt32(reader["Zone_ParentID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_Name")))
{
item.Zone_Name = ConvertUtility.ToString(reader["Zone_Name"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_Description")))
{
item.Zone_Description = ConvertUtility.ToString(reader["Zone_Description"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_FriendlyUrl")))
{
item.Zone_FriendlyUrl = ConvertUtility.ToString(reader["Zone_FriendlyUrl"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_RealUrl")))
{
item.Zone_RealUrl = ConvertUtility.ToString(reader["Zone_RealUrl"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_Avatar")))
{
item.Zone_Avatar = ConvertUtility.ToString(reader["Zone_Avatar"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_Priority")))
{
item.Zone_Priority = ConvertUtility.ToInt32(reader["Zone_Priority"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_MetaDescription")))
{
item.Zone_MetaDescription = ConvertUtility.ToString(reader["Zone_MetaDescription"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_MetaKeywords")))
{
item.Zone_MetaKeywords = ConvertUtility.ToString(reader["Zone_MetaKeywords"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_Layout")))
{
item.Zone_Layout = ConvertUtility.ToString(reader["Zone_Layout"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_SubcategoryDisplay")))
{
item.Zone_SubcategoryDisplay = ConvertUtility.ToString(reader["Zone_SubcategoryDisplay"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_ContentListingDisplay")))
{
item.Zone_ContentListingDisplay = ConvertUtility.ToString(reader["Zone_ContentListingDisplay"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_VisibleInMainNav")))
{
item.Zone_VisibleInMainNav = ConvertUtility.ToBoolean(reader["Zone_VisibleInMainNav"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_VisibleInLeftNav")))
{
item.Zone_VisibleInLeftNav = ConvertUtility.ToBoolean(reader["Zone_VisibleInLeftNav"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_VisibleInTopNav")))
{
item.Zone_VisibleInTopNav = ConvertUtility.ToBoolean(reader["Zone_VisibleInTopNav"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_VisibleInFooterNav")))
{
item.Zone_VisibleInFooterNav = ConvertUtility.ToBoolean(reader["Zone_VisibleInFooterNav"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_ExcludeFromNav")))
{
item.Zone_ExcludeFromNav = ConvertUtility.ToBoolean(reader["Zone_ExcludeFromNav"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_Visible")))
{
item.Zone_Visible = ConvertUtility.ToBoolean(reader["Zone_Visible"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_Disable")))
{
item.Zone_Disable = ConvertUtility.ToBoolean(reader["Zone_Disable"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_Lang")))
{
item.Zone_Lang = ConvertUtility.ToString(reader["Zone_Lang"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_IsStandAloneBox")))
{
item.Zone_IsStandAloneBox = ConvertUtility.ToBoolean(reader["Zone_IsStandAloneBox"]);
}
}
catch { }
return(item);
}
protected void dtgPix_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "delete")
{
int id = ConvertUtility.ToInt32(e.Item.Cells[0].Text);
DownloadInfo info = DownloadDB.GetInfo(id);
try
{
string file = info.Download_File;
if (file.Length > 0)
{
int lengUploadFile = AppEnv.UploadDocument.Length;
string filenameVideo = file.Substring(lengUploadFile);
FileInfo file5 = new FileInfo(Server.MapPath(AppEnv.UploadDocument) + filenameVideo);
if (file5.Exists)
{
file5.Delete();
}
}
ContentDownloadDB.Delete(_contentId, id);
DownloadDB.Delete(id);
lblStatusUpdate.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblStatusUpdate.Text = MiscUtility.UPDATE_ERROR;
}
}
if (e.CommandName == "updaterow")
{
try
{
int id = ConvertUtility.ToInt32(e.Item.Cells[0].Text);
DownloadInfo info = DownloadDB.GetInfo(id);
TextBox txtPriority = (TextBox)e.Item.FindControl("txtPriority");
CheckBox chkVisible = (CheckBox)e.Item.FindControl("chkVisible");
info.Download_Visible = ConvertUtility.ToBoolean(chkVisible.Checked);
DownloadDB.Update(info);
var ctinfo = ContentDownloadDB.GetInfo(_contentId, id);
ctinfo.Priority = ConvertUtility.ToInt32(txtPriority.Text);
ContentDownloadDB.Update(ctinfo);
lblStatusUpdate.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblStatusUpdate.Text = MiscUtility.UPDATE_ERROR; //ex.ToString();
}
}
if (e.CommandName == "editrow")
{
lblStatusUpdate.Text = lblStatusUpdate2.Text = string.Empty;
var id = ConvertUtility.ToInt32(e.Item.Cells[0].Text);
var info = DownloadDB.GetInfo(id);
chkVisible.Checked = info.Download_Visible;
txtName.Text = info.Download_Name;
txtTeaser.Text = info.Download_Description;
txtID.Text = id.ToString();
}
}
protected void dtgData_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "delete")
{
var id = ConvertUtility.ToInt32(e.Item.Cells[0].Text);
try
{
ContentVideoDB.Delete(_contentId, id);
VideoDB.Delete(id);
lblStatusUpdate.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblStatusUpdate.Text = MiscUtility.UPDATE_ERROR;
}
}
if (e.CommandName == "updaterow")
{
try
{
var id = ConvertUtility.ToInt32(e.Item.Cells[0].Text);
var info = VideoDB.GetInfo(id);
var txtPriority = (TextBox)e.Item.FindControl("txtPriority");
var chkVisible = (CheckBox)e.Item.FindControl("chkVisible");
info.Video_Visible = ConvertUtility.ToBoolean(chkVisible.Checked);
VideoDB.Update(info);
var ctinfo = ContentVideoDB.GetInfo(_contentId, id);
ctinfo.Priority = ConvertUtility.ToInt32(txtPriority.Text);
ContentVideoDB.Update(ctinfo);
lblStatusUpdate.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblStatusUpdate.Text = MiscUtility.UPDATE_ERROR; //ex.ToString();
}
}
if (e.CommandName == "editrow")
{
lblStatusUpdate.Text = lblStatusUpdate2.Text = string.Empty;
var id = ConvertUtility.ToInt32(e.Item.Cells[0].Text);
var info = VideoDB.GetInfo(id);
dropType.ClearSelection();
MiscUtility.SetSelected(dropType.Items, info.Video_Type);
chkVisible.Checked = info.Video_Visible;
txtFile.Text = info.Video_File;
txtYoutube.Text = info.Video_YouTube;
txtName.Text = info.Video_Name;
txtTeaser.Text = info.Video_Description;
txtID.Text = id.ToString();
}
}
private object TryConvert(object value, string toType, ref bool succes)
{
object retval = null;
if (toType == typeof(Object).Name)
{
succes = true;
return((object)value);
}
if (toType == typeof(Guid?).Name)
{
succes = true;
return(ConvertUtility.ToGuidNullable(value));
}
if (toType == typeof(Guid).Name)
{
succes = true;
return(ConvertUtility.ToGuid(value, Guid.Empty));
}
if (toType == typeof(Byte?).Name)
{
succes = true;
return(ConvertUtility.ToByteNullable(value));
}
if (toType == typeof(Byte).Name)
{
succes = true;
return(ConvertUtility.ToByte(value, 0));
}
if (toType == typeof(int?).Name)
{
succes = true;
return(ConvertUtility.ToInt32Nullable(value));
}
if (toType == typeof(int).Name)
{
succes = true;
return(ConvertUtility.ToInt32(value, 0));
}
if (toType == typeof(decimal?).Name)
{
succes = true;
return(ConvertUtility.ToDecimalNullable(value));
}
if (toType == typeof(decimal).Name)
{
succes = true;
return(ConvertUtility.ToDecimal(value, 0));
}
if (toType == typeof(Int16?).Name)
{
succes = true;
return(ConvertUtility.ToInt16Nullable(value));
}
if (toType == typeof(Int16).Name)
{
succes = true;
return(ConvertUtility.ToInt16(value, 0));
}
if (toType == typeof(Int32?).Name)
{
succes = true;
return(ConvertUtility.ToInt32Nullable(value));
}
if (toType == typeof(Int32).Name)
{
succes = true;
return(ConvertUtility.ToInt32(value, 0));
}
if (toType == typeof(Int64?).Name)
{
succes = true;
return(ConvertUtility.ToInt64Nullable(value));
}
if (toType == typeof(Int64).Name)
{
succes = true;
return(ConvertUtility.ToInt64(value, 0));
}
if (toType == typeof(float?).Name)
{
succes = true;
return(ConvertUtility.ToSingleNullable(value));
}
if (toType == typeof(float).Name)
{
succes = true;
return(ConvertUtility.ToSingle(value, 0));
}
if (toType == typeof(Single?).Name)
{
succes = true;
return(ConvertUtility.ToSingleNullable(value));
}
if (toType == typeof(Single).Name)
{
succes = true;
return(ConvertUtility.ToSingle(value, 0));
}
if (toType == typeof(double?).Name)
{
succes = true;
return(ConvertUtility.ToDoubleNullable(value));
}
if (toType == typeof(double).Name)
{
succes = true;
return(ConvertUtility.ToDouble(value, 0));
}
if (toType == typeof(Double?).Name)
{
succes = true;
return(ConvertUtility.ToDoubleNullable(value));
}
if (toType == typeof(Double).Name)
{
succes = true;
return(ConvertUtility.ToDouble(value, 0));
}
if (toType == typeof(bool?).Name)
{
succes = true;
return(ConvertUtility.ToBooleanNullable(value));
}
if (toType == typeof(bool).Name)
{
succes = true;
return(ConvertUtility.ToBoolean(value, false));
}
if (toType == typeof(DateTime).Name)
{
DateTime DateTimeValue = DateTime.Now;
succes = DateTime.TryParse(ConvertUtility.HandleNull(value, string.Empty).ToString(), out DateTimeValue);
retval = DateTimeValue;
}
if (toType == typeof(DateTime?).Name)
{
DateTime DateTimeValue = DateTime.Now;
succes = DateTime.TryParse(ConvertUtility.HandleNull(value, string.Empty).ToString(), out DateTimeValue);
if (!succes)
{
retval = null;
}
retval = DateTimeValue;
}
return(retval);
}
protected void butSend_Click(object sender, EventArgs e)
{
var contactEmail = AppEnv.ContactEmail;
if (txtName.Text.Trim().Length == 0 || txtEmail.Text.Trim().Length == 0 || txtContent.Text.Trim().Length == 0)
{
MessageBox.Show("Bạn phải điền tất cả các ô có dấu (*)");
return;
}
//if(txtCode.Text.Trim() != FormShield1.GetText())
//{
// MessageBox.Show("Bạn nhập không đúng mã bảo vệ");
// return;
//}
const string matchEmailPattern = @"^(([\w-]+\.)+[\w-]+|([a-zA-Z]{1}|[\w-]{2,}))@"
+ @"((([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\.([0-1]?
[0-9]{1,2}|25[0-5]|2[0-4][0-9])\."
+ @"([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\.([0-1]?
[0-9]{1,2}|25[0-5]|2[0-4][0-9])){1}|"
+ @"([a-zA-Z]+[\w-]+\.)+[a-zA-Z]{2,4})$";
if (Regex.IsMatch(txtEmail.Text.Trim(), matchEmailPattern) == false)
{
MessageBox.Show("Email không đúng !!!");
return;
}
var sb = new StringBuilder();
sb.Append("<b>Ho ten</b>: ");
sb.Append(txtName.Text);
sb.Append("<br><b>Email</b>: ");
sb.Append(txtEmail.Text);
sb.Append("<br><b>Dien thoai</b>:<br>");
sb.Append(txtPhone.Text);
sb.Append("<br><b>Gioi tinh</b>:<br>");
sb.Append(rdolGender.SelectedValue);
sb.Append("<br><b>Tieu de</b>:<br>");
sb.Append(txtSubject.Text);
sb.Append("<br><b>Content</b>:<br>");
sb.Append(txtContent.Text);
// new email solution start
var email = new MailMessage(txtEmail.Text, contactEmail)
{
Subject = "Lien he tu khach hang ghe tham website",
IsBodyHtml = true,
Body = sb.ToString()
};
var smtp = new SmtpClient
{
Host = AppEnv.MailServer.Length == 0 ? "localhost" : AppEnv.MailServer,
Port =
AppEnv.MailServerPort.Length == 0 ? 25 : ConvertUtility.ToInt32(AppEnv.MailServerPort)
};
// if authentication
if (AppEnv.MailUsername.Length > 0 && AppEnv.MailPassword.Length > 0)
{
smtp.Credentials = new NetworkCredential(AppEnv.MailUsername, AppEnv.MailPassword);
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
}
// if authentication end
var info = new MailInfo
{
Mail_Kind = "lienhe",
Mail_Name = HTMLUtility.SecureHTML(txtName.Text),
Mail_Email = HTMLUtility.SecureHTML(txtEmail.Text),
Mail_Phone = HTMLUtility.SecureHTML(txtPhone.Text),
Mail_Address = "",
Mail_Content = HTMLUtility.SecureHTML(txtContent.Text),
Pix_ID = 0,
Mail_Answer = ConvertUtility.ToBoolean(false),
Mail_Datetime = DateTime.Now
};
MailDB.Insert(info);
try
{
smtp.Send(email);
notice.InnerHtml = "<br><br><br><font color=red><b>Email đã được gửi tới " + contactEmail + "...</b></font>";
}
catch (Exception ex)
{
notice.InnerHtml = "<br><br><br><font color=red><b>Email đã được gửi đi... Xin chân thành cảm ơn.</b></font>";
ErrorReportDB.NewReport(Request.RawUrl, ex.ToString());
//notice.InnerHtml = "<br><br><br><font color=red><b>Lỗi trong quá trình gửi mail...</b></font><br>" + ex.Message;
}
finally
{
pnform.Visible = false;
notice.Visible = true;
}
}
private void LoadSidebar()
{
radmMenu.Text = "";
//GetPath();
try
{
cmd = ConvertUtility.ToString(Request.QueryString["cmd"]);
}
catch
{
cmd = "";
}
portalid = ConvertUtility.ToInt32(Request.QueryString["portalid"]);
DataTable dtCommands = null;
if (!CurrentUser.IsSuperAdmin)
{
dtCommands = CommandController.GetCommandsForUserByPortalID(CurrentUser.UserID, portalid);
}
else
{
dtCommands = CommandController.GetCommands();
}
if (cmd != "")
{
DataRow[] _lstCommands = dtCommands.Select("CommandKey = '" + cmd + "' AND CommandVisible = 1");
foreach (DataRow row in _lstCommands)
{
listCmd.Add(row["CommandID"].ToString());
if (row["CommandParentID"].ToString() != "0")
{
LoadParentCommand(ConvertUtility.ToInt32(row["CommandParentID"].ToString()), dtCommands, ref listCmd);
}
break;
}
}
DataRow[] drRoots = dtCommands.Select("CommandParentID = 0");
int _count = 0;
if (ConvertUtility.ToString(Request.QueryString["cmd"]) == "")
{
sb.Append("<li class=\"start active\"><a href=\"/\"><i class=\"icon-home\"></i><span class=\"title\">Home</span><span class=\"selected\"></span></a></li>");
}
else
{
sb.Append("<li><a href=\"/\"><i class=\"icon-home\"></i><span class=\"title\">Home</span><span class=\"selected\"></span></a></li>");
}
foreach (DataRow row in drRoots)
{
string name = "";
string url = "";
name = row["CommandName"].ToString();
//_item.Value = row["CommandID"].ToString();
int curItem = ConvertUtility.ToInt32(row["CommandID"].ToString());
DataRow[] _lstCommands = dtCommands.Select("CommandParentID = " + curItem + " AND CommandVisible = 1");
if (!string.IsNullOrEmpty(row["CommandUrl"].ToString().Trim()))
{
url = row["CommandUrl"].ToString();
}
else if (!string.IsNullOrEmpty(row["CommandKey"].ToString().Trim()))
{
url = AppEnv.AdminUrlParams(row["CommandKey"].ToString()) + row["CommandParams"].ToString();
}
if (ConvertUtility.ToBoolean(row["CommandVisible"]) == false || ConvertUtility.ToBoolean(row["CommandEnable"]) == false)
{
continue;
}
if (listCmd.Contains(row["CommandID"].ToString()))
{
if (_count == 0)
{
sb.Append("<li class=\"start active\">");
}
else
{
sb.Append("<li class=\"active\">");
}
}
else
{
if (_count == 0)
{
sb.Append("<li class=\"\">");
}
else
{
sb.Append("<li>");
}
}
if (_lstCommands.Length > 0)
{
if (_count == 0)
{
sb.Append(string.Format(fmAu, url, name, "icon-gift"));
}
else
{
sb.Append(string.Format(fmAu, url, name, "icon-gift"));
}
sb.Append("<ul class=\"sub-menu\">");
LoadSidebarItems(ConvertUtility.ToInt32(row["CommandID"].ToString()), dtCommands);
sb.Append("</ul>");
}
else
{
if (_count == 0)
{
sb.Append(string.Format(fmAd, url, name, "icon-home"));
}
else
{
sb.Append(string.Format(fmAd, url, name, "icon-gift"));
}
}
sb.Append("</li>");
_count++;
}
radmMenu.Text = sb.ToString();
}
protected void dtgPix_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "delete")
{
int id = ConvertUtility.ToInt32(e.Item.Cells[0].Text);
ImageInfo info = ImageDB.GetInfo(id);
try
{
string avatarsource = info.Image_File;
if (avatarsource.Length > 0)
{
int lengUploadString3 = AppEnv.UploadImagesThumbDir.Length;
string filename3 = avatarsource.Substring(lengUploadString3);
FileInfo file3 = new FileInfo(Server.MapPath(AppEnv.UploadImagesThumbDir) + filename3);
if (file3.Exists)
{
file3.Delete();
}
FileInfo file4 = new FileInfo(Server.MapPath(AppEnv.UploadImagesNormalDir) + filename3);
if (file4.Exists)
{
file4.Delete();
}
FileInfo file5 = new FileInfo(Server.MapPath(AppEnv.UploadImagesOriginalDir) + filename3);
if (file5.Exists)
{
file5.Delete();
}
}
ContentImageDB.Delete(_contentId, id);
ImageDB.Delete(id);
lblStatusUpdate.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblStatusUpdate.Text = MiscUtility.UPDATE_ERROR;
}
}
if (e.CommandName == "updaterow")
{
try
{
int id = ConvertUtility.ToInt32(e.Item.Cells[0].Text);
ImageInfo info = ImageDB.GetInfo(id);
TextBox txtPriority = (TextBox)e.Item.FindControl("txtPriority");
CheckBox chkVisible = (CheckBox)e.Item.FindControl("chkVisible");
CheckBox chkCover = (CheckBox)e.Item.FindControl("chkCover");
info.Image_Visible = ConvertUtility.ToBoolean(chkVisible.Checked);
ImageDB.Update(info);
ContentImageInfo ctinfo = ContentImageDB.GetInfo(_contentId, id);
ctinfo.Priority = ConvertUtility.ToInt32(txtPriority.Text);
ctinfo.IsCover = ConvertUtility.ToBoolean(chkCover.Checked);
ContentImageDB.Update(ctinfo);
lblStatusUpdate.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblStatusUpdate.Text = MiscUtility.UPDATE_ERROR; //ex.ToString();
}
}
if (e.CommandName == "editrow")
{
lblStatusUpdate.Text = lblStatusUpdate2.Text = string.Empty;
var id = ConvertUtility.ToInt32(e.Item.Cells[0].Text);
var info = ImageDB.GetInfo(id);
chkVisible.Checked = info.Image_Visible;
txtName.Text = info.Image_Name;
txtTeaser.Text = info.Image_Description;
txtID.Text = id.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
lang = Request.QueryString["lang"];
width = ConvertUtility.ToInt32(Request.QueryString["w"]);
price = ConfigurationSettings.AppSettings.Get("goldprice");
telCo = Session["telco"].ToString();
linkStr = "<a href=\"../" + UrlProcess.GetSportHomeUrlNew(lang, "home", width.ToString()).Replace("~/", "") + "\" >BÓNG ĐÁ<a>";
linkStr_KD = "<a href=\"../" + UrlProcess.GetSportHomeUrlNew(lang, "home", width.ToString()).Replace("~/", "") + "\" >BONG DA<a>";
if (!IsPostBack)
{
if (width == 0)
{
width = (int)Constant.DefaultScreen.Standard;
}
ltrWidth.Text = "<meta content=\"width=" + width.ToString() + "; initial-scale=1.0; maximum-scale=1.0; user-scalable=0;\" name=\"viewport\" />";
gameid = ThethaoController.GetAll_Sport87DetailByGame87ID(ConvertUtility.ToInt32(Request.QueryString["id"])).Rows[0]["PK_Game87_ID"].ToString();
DataSet ds87detail = ThethaoController.GetAll_Sport87_DetailBy_PK_Game87ID(gameid);
if (!ConvertUtility.ToBoolean(ds87detail.Tables[0].Rows[0]["IsFull"]))
{
pnlThongBao.Visible = true;
if (lang == "1")
{
ltrTitle.Text = linkStr + " » " + Resources.Resource.wThongBao;
//ltrThongBao.Text = Resources.Resource.wXacNhanDichVu.Replace("xxx", price);
ltrThongBao.Text = ds87detail.Tables[1].Rows[0]["ContentValue"].ToString();
btnCo.Visible = false;
btnKhong.Visible = false;
}
else
{
ltrTitle.Text = linkStr_KD + " » " + Resources.Resource.wThongBao_KD;
//ltrThongBao.Text = Resources.Resource.wXacNhanDichVu_KD.Replace("xxx", price);
ltrThongBao.Text = UnicodeUtility.UnicodeToKoDau(ds87detail.Tables[1].Rows[0]["ContentValue"].ToString());
btnCo.Visible = false;
btnKhong.Visible = false;
}
}
else
{
if (WapController.W4A_Subscriber_IsActive(ConvertUtility.ToString(Session["msisdn"]), 2))
{
HienThiNoiDung(true, false);
return;
}
// Nếu có transactionid_old >> thuê bao mobifone đã thực hiện thanh toán
if (Session["transactionid_old"] != null)
{
messageReturn = ConvertUtility.ToString(Session["debit_status"]);
if (ConvertUtility.ToString(Session["debit_status"]) == "0")
{// Thanh toán thành công >> trả nội dung
HienThiNoiDung(true, true);
}
else
{// Thanh toán không thành công >> thông báo lỗi
HienThiNoiDung(false, true);
}
Session["transactionid_old"] = null;
}
else
{
//gameid = ThethaoController.GetAll_Sport87DetailByGame87ID(ConvertUtility.ToInt32(Request.QueryString["id"])).Rows[0]["PK_Game87_ID"].ToString();
if (telCo == Constant.T_Mobifone)
{
string content = Session["cpid"].ToString() + "&" + Constant.thethao + "9" + Request.QueryString["id"] + "&" + price + "&" + Session["transactionid"].ToString();
Response.Redirect(ConfigurationSettings.AppSettings.Get("vms3g") + "?link=" + Server.UrlEncode(EAS.EncryptData(content, ConfigurationSettings.AppSettings.Get("vmskey"))));
}
//
if (telCo == "Undefined")
{
pnlSMS.Visible = true;
if (lang == "1")
{
ltrHuongdan.Text = linkStr + " » " + Resources.Resource.wHuongDan;
//Xiên
if (Request.QueryString["id"] == "2")
{
ltrSMS.Text = "Soạn tin <b>" + ConfigurationSettings.AppSettings.Get("xiencode") + "</b> gửi <b>" + ConfigurationSettings.AppSettings.Get("xiencommandcode") + "</b> để nhận chuỗi kèo xiên sáng nhất" + Resources.Resource.wChon3G;
}
//Trận cầu vàng
if (Request.QueryString["id"] == "4")
{
ltrSMS.Text = "Soạn tin <b>" + ConfigurationSettings.AppSettings.Get("goldcode") + "</b> gửi <b>" + ConfigurationSettings.AppSettings.Get("goldcommandcode") + "</b> để nhận thông tin về trận cầu ngon ăn nhất" + Resources.Resource.wChon3G;
}
//Tài Xỉu sáng nhất
if (Request.QueryString["id"] == "5")
{
ltrSMS.Text = "Soạn tin <b>" + ConfigurationSettings.AppSettings.Get("tvtxcode") + "</b> gửi <b>" + ConfigurationSettings.AppSettings.Get("tvtxcommandcode") + "</b> để nhận thông tin Tài Xỉu sáng nhất" + Resources.Resource.wChon3G;
}
//Trên dưới sáng nhất
if (Request.QueryString["id"] == "6")
{
ltrSMS.Text = "Soạn tin <b>" + ConfigurationSettings.AppSettings.Get("tvtdcode") + "</b> gửi <b>" + ConfigurationSettings.AppSettings.Get("tvtdcommandcode") + "</b> để nhận thông tin Trên Dưới sáng nhất" + Resources.Resource.wChon3G;
}
//Sáng nhất giải
if (",1,3,7,8,9,10,11,12,".LastIndexOf("," + Request.QueryString["id"] + ",") >= 0)
{
ltrSMS.Text = "Soạn tin <b>" + ConfigurationSettings.AppSettings.Get("sangcode") + " <ma tran></b> gửi <b>" + ConfigurationSettings.AppSettings.Get("sangcommandcode") + "</b> để nhận thông tin Kèo sáng nhất giải" + Resources.Resource.wChon3G;
}
}
else
{
ltrHuongdan.Text = linkStr_KD + " » " + Resources.Resource.wHuongDan_KD;
if (Request.QueryString["id"] == "2")
{
ltrSMS.Text = "Soan tin <b>" + ConfigurationSettings.AppSettings.Get("xiencode") + "</b> gui <b>" + ConfigurationSettings.AppSettings.Get("xiencommandcode") + "</b> de nhan chuoi keo xien sang nhat" + Resources.Resource.wChon3G;
}
if (Request.QueryString["id"] == "4")
{
ltrSMS.Text = "Soan tin <b>" + ConfigurationSettings.AppSettings.Get("goldcode") + "</b> gui <b>" + ConfigurationSettings.AppSettings.Get("goldcommandcode") + "</b> de nhan thong tin ve tran cau ngon an nhat" + Resources.Resource.wChon3G_KD;
}
if (Request.QueryString["id"] == "5")
{
ltrSMS.Text = "Soan tin <b>" + ConfigurationSettings.AppSettings.Get("tvtxcode") + "</b> gui <b>" + ConfigurationSettings.AppSettings.Get("tvtxcommandcode") + "</b> de nhan thong tin Tai Xiu sang nhat" + Resources.Resource.wChon3G_KD;
}
if (Request.QueryString["id"] == "6")
{
ltrSMS.Text = "Soan tin <b>" + ConfigurationSettings.AppSettings.Get("tvtdcode") + "</b> gui <b>" + ConfigurationSettings.AppSettings.Get("tvtdcommandcode") + "</b> de nhan thong tin Tren Duoi sang nhat" + Resources.Resource.wChon3G_KD;
}
if (",1,3,7,8,9,10,11,12,".LastIndexOf("," + Request.QueryString["id"] + ",") >= 0)
{
ltrSMS.Text = "Soan tin <b>" + ConfigurationSettings.AppSettings.Get("sangcode") + " <ma tran></b> gui <b>" + ConfigurationSettings.AppSettings.Get("sangcommandcode") + "</b> de nhan thong tin Keo sang nhat giai" + Resources.Resource.wChon3G_KD;
}
}
}
else
{
//pnlThongBao.Visible = true;
//if (lang == "1")
//{
// ltrTitle.Text = linkStr + " » " + Resources.Resource.wThongBao;
// //ltrThongBao.Text = Resources.Resource.wXacNhanDichVu.Replace("xxx", price);
// ltrThongBao.Text = Resources.Resource.wXacNhanDichVu + "dịch vụ tư vấn đặc biệt " + ds87detail.Tables[0].Rows[0]["Name"].ToString();
// btnCo.Text = Resources.Resource.btnCo;
// btnKhong.Text = Resources.Resource.btnKhong;
//}
//else
//{
// ltrTitle.Text = linkStr_KD + " » " + Resources.Resource.wThongBao_KD;
// //ltrThongBao.Text = Resources.Resource.wXacNhanDichVu_KD.Replace("xxx", price);
// ltrThongBao.Text = Resources.Resource.wXacNhanDichVu + "dich vu tu van dac biet " + ds87detail.Tables[0].Rows[0]["Name"].ToString();
// btnCo.Text = Resources.Resource.btnCo_KD;
// btnKhong.Text = Resources.Resource.btnKhong_KD;
//}
pnlThongBao.Visible = false;
switch (Session["telco"].ToString())
{
case "Vietnamobile":
WapXzone_VNM.Library.VNMCharging.VNMChargingGW charging = new WapXzone_VNM.Library.VNMCharging.VNMChargingGW();
//messageReturn = charging.PaymentVNM(Session["msisdn"].ToString(), price, "D", "GAME87", Request.QueryString["id"].ToString());
//messageReturn = charging.PaymentVNM(Session["msisdn"].ToString(), "GAMEDOWN", "GAME_DOWN");
messageReturn = charging.NavigatePaymentVnm(Session["msisdn"].ToString(), "GAMEDOWN", "GAME_DOWN", price, "D", "GAME87", Request.QueryString["id"]);
if (!string.IsNullOrEmpty(messageReturn) && messageReturn == "1")
{ // Thanh toán thành công >> trả nội dung
HienThiNoiDung(true, true);
}
else
{ // Thanh toán không thành công >> thông báo lỗi
HienThiNoiDung(false, true);
}
break;
}
}
}
}
}
}
private static ImageInfo CreateEntityFromReader(IDataReader reader)
{
var item = new ImageInfo();
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_ID")))
{
item.Image_ID = ConvertUtility.ToInt32(reader["Image_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Name")))
{
item.Image_Name = ConvertUtility.ToString(reader["Image_Name"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Description")))
{
item.Image_Description = ConvertUtility.ToString(reader["Image_Description"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_File")))
{
item.Image_File = ConvertUtility.ToString(reader["Image_File"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_CreateDate")))
{
item.Image_CreateDate = ConvertUtility.ToDateTime(reader["Image_CreateDate"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_FileSize")))
{
item.Image_FileSize = ConvertUtility.ToDouble(reader["Image_FileSize"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Width")))
{
item.Image_Width = ConvertUtility.ToInt32(reader["Image_Width"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Height")))
{
item.Image_Height = ConvertUtility.ToInt32(reader["Image_Height"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_View")))
{
item.Image_View = ConvertUtility.ToInt32(reader["Image_View"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("User_ID")))
{
item.User_ID = ConvertUtility.ToInt32(reader["User_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Image_Visible")))
{
item.Image_Visible = ConvertUtility.ToBoolean(reader["Image_Visible"]);
}
}
catch { }
return(item);
}
