public void UpdateTotalViews(int ArticleID, string Lang)
{
MyConnection ca = new MyConnection();
//try
{
string Sql = "UPDATE Article SET TotalViews = TotalViews + 1 ";
Sql += "WHERE ModuleID='2' AND ArticleID='" + ArticleID + "' AND Lang='" + Lang + "'";
ca.ExeSql(Sql);
}
//catch { }
}
/// <summary>
/// Cập nhật Actived cho đơn hàng
/// </summary>
/// <param name="OrderCode"></param>
/// <returns></returns>
public bool ConfirmOrder(string OrderCode, string ActiveCode)
{
bool f = false;
MyConnection ca = new MyConnection();
try
{
string Sql = "UPDATE [Order] SET Actived = 'True' WHERE OrderCode = '" + OrderCode + "' AND ConfirmString = '" + ActiveCode + "'";
ca.ExeSql(Sql);
f = true;
}
catch { }
return(f);
}
public bool DeleteAboutUsCategory(int CategoryID)
{
bool result = false;
MyConnection ca = new MyConnection();
try
{
string Sql = "DELETE FROM ArticleCategory WHERE CategoryID='" + CategoryID + "'";
ca.ExeSql(Sql);
result = true;
}
catch { result = false; }
return(result);
}
public bool InsertVoteDetail(int VoteTypeID, int CommentID, int VoteMark)
{
bool result = false;
MyConnection ca = new MyConnection();
try
{
string Sql = "INSERT INTO VoteDetail (VoteTypeID, CommentID, VoteMark) ";
Sql += "VALUES (N'" + VoteTypeID + "', N'" + CommentID + "',N'" + VoteMark + "')";
ca.ExeSql(Sql);
result = true;
}
catch { result = false; }
return(result);
}
public bool InsertProductComment(int ProductID, int CustomerID, string Title, string Comment)
{
bool result = false;
MyConnection ca = new MyConnection();
try
{
string Sql = "INSERT INTO Comment (ProductID, CustomerID, Title, Comment) ";
Sql += "VALUES (N'" + ProductID + "', N'" + CustomerID + "',N'" + Title + "',N'" + Comment + "')";
ca.ExeSql(Sql);
result = true;
}
catch { result = false; }
return(result);
}
protected void btnAction_Click(object sender, EventArgs e)
{
string c = ddlChoice.SelectedValue;
string tblname = txtTableName.Text.Trim();
DataSet ds = new DataSet();
Article art = new Article();
Product pro = new Product();
int AgentCatID = Convert.ToInt32(ddlAgentCat.SelectedValue);
lblAgentCatID.Text = ddlAgentCat.SelectedValue;
if (c == "SELECT")
{
if (tblname == "Article")
{
ds = art.GetAllArticle("Article", AgentCatID);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Response.Write(DataObject.GetString(ds, i, "ArticleID") + "======" + DataObject.GetString(ds, i, "Title") + "<br />");
}
}
else if (tblname == "ProductCat")
{
ds = pro.GetAllProduct("ProductCat", AgentCatID, "VI");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Response.Write(DataObject.GetString(ds, i, "ID") + "======" + DataObject.GetString(ds, i, "TenGoi") + "<br />");
}
}
}
else if (c == "DELETE")
{
string sql = txtSql.Text;
MyConnection ca = new MyConnection();
ca.ExeSql(sql);
}
}