// dbCmd.Parameters.Add(new SqlParameter("@CusName", data.CusName));
public static void Insert(tbBrandInfo tbBrand)
{
string q = "insert into [tbBrands]([Name],[Logo],[Ord],[Lang]) values(@Name,@Logo,@Ord,@Lang))";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = q;
cmd.Connection = GetConnection();
cmd.Parameters.Add(new SqlParameter("@Name", tbBrand.Name));
cmd.Parameters.Add(new SqlParameter("@Logo", tbBrand.Logo));
cmd.Parameters.Add(new SqlParameter("@Ord", tbBrand.Ord));
cmd.Parameters.Add(new SqlParameter("@Lang", tbBrand.Lang));
ExecuteNonQuery(cmd);
}
public static void Update(tbBrandInfo tbBrand)
{
string q = "update [tbBrands] set [Name] = @Name,[Logo] = @Logo,[Ord] = @Ord,[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", tbBrand.Name));
cmd.Parameters.Add(new SqlParameter("@Logo", tbBrand.Logo));
cmd.Parameters.Add(new SqlParameter("@Ord", tbBrand.Ord));
cmd.Parameters.Add(new SqlParameter("@Lang", tbBrand.Lang));
cmd.Parameters.Add(new SqlParameter("@Id", tbBrand.Id));
ExecuteNonQuery(cmd);
}
protected void grvUser_ItemCommand(object source, DataGridCommandEventArgs e)
{
Id = int.Parse(e.CommandArgument.ToString());
switch (e.CommandName)
{
case "Edit":
DataTable dt = BrandsController.GetByColumn("Id", Id.ToString());
txtName.Text = dt.Rows[0]["Name"].ToString();
txtLogo.Text = dt.Rows[0]["Logo"].ToString();
txtOrd.Text = dt.Rows[0]["Ord"].ToString();
txtLang.Text = dt.Rows[0]["Lang"].ToString();
break;
case "Delete":
tbBrandInfo obj = new tbBrandInfo();
obj.Id = Id;
BrandsController.Delete(obj);
_LoadBrand();
break;
}
}
public static void Delete(tbBrandInfo obj)
{
string q = "Delete from tbBrands where Id=" + obj.Id;
ExecuteNonQuery(q);
}
public static DataTable GetBy_Id(tbBrandInfo tbBrand)
{
string str = "select * from [tbBrands] where [Id]=" + tbBrand.Id;
return(GetData(str));
}
