protected void btnCreate_Click(object sender, EventArgs e)
{
mtvTheLoai.ActiveViewIndex = 1;
clsTheLoai tl = new clsTheLoai();
tl.TenTheLoai = txtName.Text;
tl.MoTa = txtMota.Text;
tl.Hot = ckbHot.Checked;
tl.Stt = Convert.ToInt32(txtViTri.Text);
tl.Images = DateTime.Now.Second + fileUp.FileName;
clsBSTheLoai bsTL = new clsBSTheLoai();
//if (fileUp.HasFile)
//{
if (bsTL.InsertTL(tl))
{
lblMes.Text = "<script>alert('Danh mục phụ đã được tạo');</script>";
mtvTheLoai.ActiveViewIndex = 0;
grvTheLoai.DataBind();
//fileUp.SaveAs(Server.MapPath("~/Images/HinhAnh/") + DateTime.Now.Second + fileUp.FileName);
}
else
{
lblMes.Text = "<script>alert('Lỗi, vui lòng kiểm tra dữ liệu !');</script>";
}
// }
//else {
// lblMes.Text = "<script>alert('Bạn chưa chọn hình ảnh !');</script>";
// }
}
// Sua danh muc
public bool EditTheLoai(clsTheLoai dm,int type)
{
string sql="";
if (type==1)
{
sql = "Update tblTheloai set TenTheLoai=@TenTheLoai,MaDanhMuc=@MaDanhMuc,MaQuocGia=@MaQuocGia,Mota=@Mota,STT=@STT,Hot=@Hot,ImageTL=@ImageTL Where ID=@ID";
}
else if (type==2)
{
sql= "Update tblTheloai set TenTheLoai=@TenTheLoai,MaDanhMuc=@MaDanhMuc,MaQuocGia=@MaQuocGia,Mota=@Mota,STT=@STT,Hot=@Hot Where ID=@ID";
}
bool st = false;
clsDAConnection conn = new clsDAConnection();
conn.openCon();
using (SqlCommand com = conn.getCon().CreateCommand())
{
com.CommandType = CommandType.Text;
com.CommandText = sql;
// Create a SqlParameter object for the title parameter.
SqlParameter p1 = com.CreateParameter();
p1.ParameterName = "@TenTheLoai";
p1.SqlDbType = SqlDbType.NVarChar;
p1.Size = 50;
p1.Value = dm.TenTheLoai;
com.Parameters.Add(p1);
// Use a shorthand syntax to add the id parameter.
com.Parameters.Add("@MaDanhMuc", SqlDbType.Int).Value = dm.MyDanhMuc;
com.Parameters.Add("@MaQuocGia", SqlDbType.Int).Value = dm.MyQuocGia;
com.Parameters.Add("@Mota", SqlDbType.NVarChar, 1000).Value = dm.MoTa;
com.Parameters.Add("@STT", SqlDbType.Int).Value = dm.Stt;
com.Parameters.Add("@Hot", SqlDbType.Int).Value = dm.Hot;
com.Parameters.Add("@ID", SqlDbType.Int).Value = dm.Id;
if (type==1)
{
com.Parameters.Add("@ImageTL", SqlDbType.NVarChar).Value = dm.Images;
}
// Execute the command and process the result.
if (com.ExecuteNonQuery() == 1)
{
st = true;
}
conn.closeCon();
return st;
}
}
public bool DeleteTheLoai(clsTheLoai dm)
{
string sql = "Delete from tblTheLoai Where ID=@ID";
bool st = false;
clsDAConnection conn = new clsDAConnection();
conn.openCon();
using (SqlCommand com = conn.getCon().CreateCommand())
{
com.CommandType = CommandType.Text;
com.CommandText = sql;
com.Parameters.Add("@ID", SqlDbType.Int).Value = dm.Id;
// Execute the command and process the result.
if (com.ExecuteNonQuery() == 1)
{
st = true;
}
conn.closeCon();
return st;
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
clsTheLoai tl = new clsTheLoai();
tl.TenTheLoai = txtNameEdit.Text;
tl.MoTa = txtMotaEdit.Text;
tl.Hot = ckbHotEdit.Checked;
tl.Stt = Convert.ToInt32(txtViTriEdit.Text);
tl.Id = Convert.ToInt32(hfID.Value);
tl.Images = DateTime.Now.Second + fileEdit.FileName;
clsBSTheLoai bsTL = new clsBSTheLoai();
int type = 2;
//if (CheckBox1.Checked)
//{
// type = 1;
//}
//else {
// type = 2;
//}
if (bsTL.EditTL(tl,2))
{
if (type==1)
{
//if (fileEdit.HasFile)
//{
// //fileEdit.SaveAs(Server.MapPath("~/Images/HinhAnh/") + DateTime.Now.Second + fileUp.FileName);
//}
//else {
// lblMes.Text = "<script>alert('Bạn chưa chọn file');</script>";
//}
}
lblMes.Text = "<script>alert('Danh mục phụ đã được sửa');</script>";
mtvTheLoai.ActiveViewIndex = 0;
grvTheLoai.DataBind();
}
else
{
lblMes.Text = "<script>alert('Lỗi, vui lòng kiểm tra dữ liệu !');</script>";
}
}
public clsTheLoai GetById(int id)
{
clsDAConnection con = new clsDAConnection();
try
{
clsTheLoai obj = new clsTheLoai();
string str = "select * from tblTheLoai where id=@id";
SqlCommand com = new SqlCommand(str, con.getCon());
com.Parameters.AddWithValue("@id", id);
con.openCon();
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
if (dr["tentheloai"] != DBNull.Value)
{
obj.TenTheLoai = dr["tentheloai"].ToString();
}
if (dr["stt"] != DBNull.Value)
{
obj.Stt = Convert.ToInt32(dr["stt"].ToString());
}
if (dr["MaQuocGia"] != DBNull.Value)
{
obj.QuocGia.Id = Convert.ToInt32(dr["MaQuocGia"].ToString());
}
if (dr["MaDanhMuc"] != DBNull.Value)
{
obj.DanhMuc.Id = Convert.ToInt32(dr["MaDanhMuc"].ToString());
}
if (dr["id"] != DBNull.Value)
{
obj.Id = Convert.ToInt32(dr["id"].ToString());
}
}
con.closeCon();
return obj;
}
catch (Exception)
{
throw;
}
finally
{
con.closeCon();
}
}
public bool InsertTL(clsTheLoai dm)
{
string sql = "Insert into tblTheLoai(TenTheLoai,MaDanhMuc,MaQuocGia,MoTa,STT,Hot) values(@TenTheLoai,@MaDanhMuc,@MaQuocGia,@MoTa,@STT,@Hot)";
bool st = false;
clsDAConnection conn = new clsDAConnection();
conn.openCon();
using (SqlCommand com = conn.getCon().CreateCommand())
{
com.CommandType = CommandType.Text;
com.CommandText = sql;
// Create a SqlParameter object for the title parameter.
SqlParameter p1 = com.CreateParameter();
p1.ParameterName = "@TenTheLoai";
p1.SqlDbType = SqlDbType.NVarChar;
p1.Size = 50;
p1.Value = dm.TenTheLoai;
com.Parameters.Add(p1);
// Use a shorthand syntax to add the id parameter.
com.Parameters.Add("@MaDanhMuc", SqlDbType.Int).Value = dm.MyDanhMuc;
com.Parameters.Add("@MaQuocGia", SqlDbType.Int).Value = dm.MyQuocGia;
com.Parameters.Add("@Mota", SqlDbType.NVarChar, 1000).Value = dm.MoTa;
com.Parameters.Add("@STT", SqlDbType.Int).Value = dm.Stt;
com.Parameters.Add("@Hot", SqlDbType.Int).Value = dm.Hot;
//com.Parameters.Add("@ImageTL", SqlDbType.NVarChar).Value = dm.Images;
// Execute the command and process the result.
if (com.ExecuteNonQuery() == 1)
{
st = true;
}
conn.closeCon();
return st;
}
}
public List<clsTheLoai> GetByQuocGia2(int id)
{
clsDAConnection con = new clsDAConnection();
try
{
List<clsTheLoai> list = new List<clsTheLoai>();
string str = "select * from tblTheLoai where maquocgia=@maquocgia and madanhmuc<>1 and hot=1";
SqlCommand com = new SqlCommand(str, con.getCon());
com.Parameters.AddWithValue("@maquocgia", id);
con.openCon();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
clsTheLoai obj = new clsTheLoai();
if (dr["tentheloai"] != DBNull.Value)
{
obj.TenTheLoai = dr["tentheloai"].ToString();
}
if (dr["stt"] != DBNull.Value)
{
obj.Stt = Convert.ToInt32(dr["stt"].ToString());
}
if (dr["MaQuocGia"] != DBNull.Value)
{
obj.QuocGia.Id = Convert.ToInt32(dr["MaQuocGia"].ToString());
}
if (dr["MaDanhMuc"] != DBNull.Value)
{
obj.DanhMuc.Id = Convert.ToInt32(dr["MaDanhMuc"].ToString());
}
if (dr["id"] != DBNull.Value)
{
obj.Id = Convert.ToInt32(dr["id"].ToString());
}
list.Add(obj);
}
con.closeCon();
return list;
}
catch (Exception)
{
throw;
}
finally
{
con.closeCon();
}
}
protected void btnXoa_Click(object sender, EventArgs e)
{
LinkButton lbt = (LinkButton)sender;
HiddenField h = (HiddenField)lbt.FindControl("hfID");
clsTheLoai tl = new clsTheLoai();
tl.Id = Convert.ToInt32(h.Value);
clsBSTheLoai t = new clsBSTheLoai();
if (t.DelTL(tl))
{
lblMes.Text = "<script>alert('Danh mục phụ đã được xóa');</script>";
mtvTheLoai.ActiveViewIndex = 0;
grvTheLoai.DataBind();
}
else
{
lblMes.Text = "<script>alert('Lỗi, không thể xóa !');</script>";
}
}
public bool InsertTL(clsTheLoai dm)
{
clsDATheLoai d = new clsDATheLoai();
return d.InsertTL(dm);
}
public bool EditTL(clsTheLoai dm,int type)
{
clsDATheLoai d = new clsDATheLoai();
return d.EditTheLoai(dm,type);
}
public bool DelTL(clsTheLoai dm)
{
clsDATheLoai d = new clsDATheLoai();
return d.DeleteTheLoai(dm);
}
