public void bind_data(int status)
{
string cmdText = string.Format("select subject, createdbyemail, [message], datecreated, feedbackid, createdbyname from feedback"
+ " where status={0} order by datecreated desc", status);
zClass ob = new zClass();
DataSet ds = ob.zSelect(cmdText);
try
{
DataColumn dc = new DataColumn("content");
ds.Tables[0].Columns.Add(dc);
ds.Tables[0].AcceptChanges();
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr.BeginEdit();
dr["content"] = string.Format("<b>{0} : {1}</b><br />{2}<br /><img src='/DesktopModules/zFeedback/zTime.jpg' /> {3}"
+ " <img src='/DesktopModules/zFeedback/zEmail.png' /> {4}", dr[5].ToString(), dr[0].ToString(),
dr[2].ToString(), dr[3].ToString(), dr[1].ToString());
dr.EndEdit();
}
GridView1.DataSource = ob.zSelect(cmdText);
GridView1.DataBind();
GridView1.Columns[1].Visible = UserInfo.IsInRole(PortalSettings.AdministratorRoleName);
GridView1.Columns[2].Visible = UserInfo.IsInRole(PortalSettings.AdministratorRoleName);
}
catch (Exception ex)
{
Response.Write("<script language='javascript'>alert('" + ex.Message + "')</script>");
}
}
private DataTable zGetData()
{
string st = "SELECT ListID, Name FROM FeedbackList";
zClass ob = new zClass();
DataSet ds = ob.zSelect(st);
if (ds.Tables[0].Rows.Count == 0)
{
string ins = "INSERT INTO FeedbackList (PortalID, Name) VALUES (1, 'Default')";
ob.zExecute(ins);
}
ds = ob.zSelect(st);
return ds.Tables[0];
}
private void bind_data()
{
try
{
bool isAdmin = UserInfo.IsInRole("admin") || UserInfo.IsInRole("LCD_Admin") || UserInfo.IsInRole("GiaoDichVien");
//bool isAdmin = UserInfo.IsInRole("admin");
string status = "2";
if (isAdmin) status = ddTrangThai.SelectedValue;
ddTrangThai.Visible = isAdmin;
string cmd = string.Format("EXEC ChungNT.Feedback_Home {0}, {1}, {2}", status, UserId, ModuleId);
zClass ob = new zClass();
DataSet ds = ob.zSelect(cmd);
DataColumn dc = new DataColumn("Link");
ds.Tables[0].Columns.Add(dc);
dc = new DataColumn("Reply");
ds.Tables[0].Columns.Add(dc);
ds.Tables[0].AcceptChanges();
foreach (DataRow row in ds.Tables[0].Rows)
{
row.BeginEdit();
row[5] = row[5].ToString().Replace(Environment.NewLine, "<br />");
row[8] = row[8].ToString().Replace(Environment.NewLine, "<br />");
row["Link"] = DotNetNuke.Common.Globals.NavigateURL(TabId, "REPLY", "mid/" + ModuleId, "ID/" + row[0].ToString());
if (isAdmin)
row["Reply"] = "Trả lời";
else
row["Reply"] = "";
row.EndEdit();
}
dlFeedback.DataSource = ds.Tables[0];
dlFeedback.DataBind();
lbSoLuong.Text = ds.Tables[1].Rows[0][0].ToString() + " / " + ds.Tables[1].Rows[0][1].ToString();
}
catch (Exception ex) { lbCategory.Text = ex.Message; }
}
protected void gvQuanLy_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "SUA")
try
{
int i = Convert.ToInt32(e.CommandArgument);
string cmd = string.Format("EXEC dbo.GetFeedbackList 1, 0, {0}, 0, 0", gvQuanLy.Rows[i].Cells[1].Text);
zClass ob = new zClass();
DataSet ds = ob.zSelect(cmd);
lbID.Text = ds.Tables[0].Rows[0]["ListID"].ToString();
tbTenNhom.Text = ds.Tables[0].Rows[0]["Name"].ToString();
lbError_SuaNhom.Text = "";
pnBack.CssClass = "pnBack";
pnSuaNhom.CssClass = "pnShow";
}
catch { }
if (e.CommandName == "XOA")
try
{
int i = Convert.ToInt32(e.CommandArgument);
string cmd = string.Format("EXEC ChungNT.Feedback_Category_Update {0}, {1}", gvQuanLy.Rows[i].Cells[1].Text, gvQuanLy.Rows[i].Cells[2].Text);
zClass ob = new zClass();
ob.zExecute(cmd);
Load_Data();
lbError.Text = "Xóa quyền quản lý nhóm thành công";
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình xử lý. " + ex.Message; }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string catID = "0";
if (Settings["feedCategory"] != null) catID = Settings["feedCategory"].ToString();
zBindData(catID, "0");
catID = "SELECT Name FROM FeedbackList WHERE ListID=" + catID;
zClass ob = new zClass();
lbCategory.Text = ob.zSelect(catID).Tables[0].Rows[0][0].ToString();
if (UserInfo.IsInRole("admin") || UserInfo.IsInRole("Administrators")) GridView1.Columns[2].Visible = true;
else GridView1.Columns[2].Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
bool isAdmin = (UserInfo.IsInRole("admin") || UserInfo.IsInRole("LCD_Admin") || UserInfo.IsInRole("GiaoDichVien"));
if (!isAdmin) Response.Redirect(DotNetNuke.Common.Globals.NavigateURL(TabId));
zClass ob = new zClass();
try
{
ddDienLuc.DataSource = ob.zSelect("EXEC ChungNT.Feedback_Roles").Tables[0];
ddDienLuc.DataBind();
}
catch { }
Panel1.Visible = isAdmin;
lbID.Text = Request["ID"] == null ? "0" : Request["ID"];
if (lbID.Text != "0") load_data();
}
private void zBindData(string catID, string feedID)
{
string st = "SELECT CreatedByEmail, Message, FeedbackID, CreatedByName, DateCreated FROM Feedback";
if (catID != "0") st = st + " WHERE Status=0 AND CategoryID=" + catID + " ORDER BY DateCreated DESC";
else if (feedID != "0") st = st + " WHERE Status=" + feedID + " OR FeedbackID=" + feedID + " ORDER BY DateCreated";
zClass ob = new zClass();
DataTable dt = ob.zSelect(st).Tables[0];
DataTable data = new DataTable();
DataColumn dc = new DataColumn("FeedbackID");
data.Columns.Add(dc);
dc = new DataColumn("Message");
data.Columns.Add(dc);
DataRow dr;
foreach (DataRow row in dt.Rows)
{
dr = data.NewRow();
dr["FeedbackID"] = row["FeedbackID"].ToString();
dr["Message"] = string.Format("<b>{0}</b><br />{2}<br /><div style='font-size:11px;'><img src='/DesktopModules/zFeedback/zTime.jpg' /> {3} <img src='/DesktopModules/zFeedback/zEmail.png' /> {1}</div>", row[3].ToString(), row[0].ToString(), row[1].ToString(), row[4].ToString());
data.Rows.Add(dr);
}
GridView1.DataSource = data;
GridView1.DataBind();
}
private void Load_Data()
{
try
{
zClass ob = new zClass();
DataSet ds = ob.zSelect("EXEC ChungNT.Feedback_Category");
dlNhom.DataSource = ds.Tables[0];
dlNhom.DataBind();
gvQuanLy.DataSource = ds.Tables[1];
gvQuanLy.DataBind();
string id = "";
foreach (GridViewRow dr in gvQuanLy.Rows)
if (dr.Cells[1].Text != id)
{
id = dr.Cells[1].Text;
dr.Cells[3].CssClass = "row1";
}
else dr.Cells[3].CssClass = "row2";
dlUsers.DataSource = ds.Tables[2];
dlUsers.DataBind();
lbError.Text = "";
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; }
}
protected void btChuyen_Click(object sender, EventArgs e)
{
try
{
string cmd = string.Format("EXEC ChungNT.Feedback_Status {0}, 1", lbID.Text);
zClass ob = new zClass();
DataSet ds = ob.zSelect(cmd);
if (ds.Tables[0].Rows[0][0].ToString() == "1")
lbError.Text = "Chuyển trạng thái thành công";
else
lbError.Text = "Không thể chuyển trạng thái";
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình cập nhật. " + ex.Message; }
}
protected void btXoaCH_Click(object sender, EventArgs e)
{
try
{
string cmd = string.Format("EXEC ChungNT.Feedback_Delete {0}, 0", lbID.Text);
zClass ob = new zClass();
DataSet ds = ob.zSelect(cmd);
if (ds.Tables[0].Rows[0][0].ToString() != "0")
Response.Redirect(DotNetNuke.Common.Globals.NavigateURL(TabId));
else
lbError.Text = "Không thể xóa.";
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình cập nhật. " + ex.Message; }
}
protected void btXoa_Click(object sender, EventArgs e)
{
try
{
string cmd = string.Format("EXEC ChungNT.Feedback_Delete {0}, 1", lbR_ID.Text);
zClass ob = new zClass();
DataSet ds = ob.zSelect(cmd);
if (ds.Tables[0].Rows[0][0].ToString() == "1")
load_data();
else
lbError.Text = "Không thể xóa.";
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình cập nhật. " + ex.Message; }
}
protected void btTraLoi_Click(object sender, EventArgs e)
{
try
{
zClass ob = new zClass();
string hoTen_reply = ob.reWrite(tbR_HoTen.Text);
string tieuDe_reply = ob.reWrite(tbR_TieuDe.Text);
string noiDung_reply = ob.reWrite(tbR_NoiDung.Text);
string cmd = string.Format("EXEC ChungNT.Feedback_Update {0}, 1, '{1}', N'{2}', '', N'{3}', N'{4}', {5}, '', ''",
lbR_ID.Text, ModuleId, hoTen_reply, tieuDe_reply, noiDung_reply, lbID.Text);
DataSet ds = ob.zSelect(cmd);
if (ds.Tables[0].Rows[0][0].ToString() == "1")
{
load_data();
lbError.Text = "Trả lời thành công. Câu hỏi đã được hiển thị.";
}
else lbError.Text = "Không thể trả lời.";
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình cập nhật. " + ex.Message; }
}
