protected void Update_Click(object sender, EventArgs e)
{
tbGroupNewInfo obj = new tbGroupNewInfo();
obj.Name = txtName.Text;
obj.Tag = txtTag.Text;
obj.Level = txtLevel.Text;
obj.Title = txtTitle.Text;
obj.Description = txtDesciption.Text;
obj.Keyword = txtKeyword.Text;
obj.Ord = int.Parse(txtOrd.Text);
obj.Priority = int.Parse(txtPriority.Text);
obj.Index = int.Parse(txtIndex.Text);
obj.Active = chkActive.Checked;
obj.Lang = txtLang.Text;
if (insert)
{
GroupNewsController.Insert(obj);
pnView.Visible = true;
pnUpdate.Visible = false;
}
else
{
obj.Id = Id;
GroupNewsController.Update(obj);
pnView.Visible = true;
pnUpdate.Visible = false;
}
_loadGroup();
}
public static void Update(tbGroupNewInfo tbGroupNew)
{
string q = "update [tbGroupNews] set [Name] = @Name,[Tag] = @Tag,[Level] = @Level,[Title] = @Title,";
q = q + "[Description] = @Description,[Keyword] = @Keyword,[Ord] = @Ord,[Priority] = @Priority,";
q = q + "[Index] = @Index,[Active] = @Active,[Lang] = @Lang where [Id] = @Id ";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = q;
cmd.Connection = GetConnection();
cmd.Parameters.Add(new SqlParameter("@Name", tbGroupNew.Name));
cmd.Parameters.Add(new SqlParameter("@Tag", tbGroupNew.Tag));
cmd.Parameters.Add(new SqlParameter("@Level", tbGroupNew.Level));
cmd.Parameters.Add(new SqlParameter("@Title", tbGroupNew.Title));
cmd.Parameters.Add(new SqlParameter("@Description", tbGroupNew.Description));
cmd.Parameters.Add(new SqlParameter("@Keyword", tbGroupNew.Keyword));
cmd.Parameters.Add(new SqlParameter("@Ord", tbGroupNew.Ord));
cmd.Parameters.Add(new SqlParameter("@Priority", tbGroupNew.Priority));
cmd.Parameters.Add(new SqlParameter("@Index", tbGroupNew.Index));
cmd.Parameters.Add(new SqlParameter("@Active", tbGroupNew.Active));
cmd.Parameters.Add(new SqlParameter("@Lang", tbGroupNew.Lang));
cmd.Parameters.Add(new SqlParameter("@Id", tbGroupNew.Id));
ExecuteNonQuery(cmd);
}
// dbCmd.Parameters.Add(new SqlParameter("@CusName", data.CusName));
public static void Insert(tbGroupNewInfo tbGroupNew)
{
string q = "insert into [tbGroupNews]([Name],[Tag],[Level],[Title],[Description],[Keyword],[Ord],";
q = q + "[Priority],[Index],[Active],[Lang]) values ";
q = q + "(@Name,@Tag,@Level,@Title,@Description,@Keyword,@Ord,@Priority,";
q = q + "@Index,@Active,@Lang)";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = q;
cmd.Connection = GetConnection();
cmd.Parameters.Add(new SqlParameter("@Name", tbGroupNew.Name));
cmd.Parameters.Add(new SqlParameter("@Tag", tbGroupNew.Tag));
cmd.Parameters.Add(new SqlParameter("@Level", tbGroupNew.Level));
cmd.Parameters.Add(new SqlParameter("@Title", tbGroupNew.Title));
cmd.Parameters.Add(new SqlParameter("@Description", tbGroupNew.Description));
cmd.Parameters.Add(new SqlParameter("@Keyword", tbGroupNew.Keyword));
cmd.Parameters.Add(new SqlParameter("@Ord", tbGroupNew.Ord));
cmd.Parameters.Add(new SqlParameter("@Priority", tbGroupNew.Priority));
cmd.Parameters.Add(new SqlParameter("@Index", tbGroupNew.Index));
cmd.Parameters.Add(new SqlParameter("@Active", tbGroupNew.Active));
cmd.Parameters.Add(new SqlParameter("@Lang", tbGroupNew.Lang));
ExecuteNonQuery(cmd);
}
protected void grvUser_ItemCommand(object source, DataGridCommandEventArgs e)
{
Id = int.Parse(e.CommandArgument.ToString());
switch (e.CommandName)
{
case "Edit":
insert = false;
pnView.Visible = false;
pnUpdate.Visible = true;
lblAction.Text = "Update";
tbGroupNewInfo groupNewInfo = new tbGroupNewInfo();
groupNewInfo.Id = Id;
DataTable dt = GroupNewsController.GetByColumn("Id", Id.ToString());
txtName.Text = dt.Rows[0]["Name"].ToString();
txtTag.Text = dt.Rows[0]["Tag"].ToString();
txtLevel.Text = dt.Rows[0]["Level"].ToString();
txtTitle.Text = dt.Rows[0]["Title"].ToString();
txtDesciption.Text = dt.Rows[0]["Description"].ToString();
txtKeyword.Text = dt.Rows[0]["Keyword"].ToString();
txtOrd.Text = dt.Rows[0]["Ord"].ToString();
txtPriority.Text = dt.Rows[0]["Priority"].ToString();
txtIndex.Text = dt.Rows[0]["Index"].ToString();
// chkActive.Checked =Convert.ToBoolean(dt.Rows[0]["Active"].ToString());
txtLang.Text = dt.Rows[0]["Lang"].ToString();
break;
case "Delete":
tbGroupNewInfo obj = new tbGroupNewInfo();
obj.Id = Id;
GroupNewsController.Delete(obj);
pnUpdate.Visible = false;
pnView.Visible = true;
_loadGroup();
break;
}
}
public static void Delete(tbGroupNewInfo obj)
{
string q = "Delete from tbGroupNews where Id=" + obj.Id;
ExecuteNonQuery(q);
}
