protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (Request.QueryString["action"] != null)
{
clsHinhAnh hinhanh = new clsHinhAnh();
hinhanh.TieuDe = this.txtTieuDe.Text;
hinhanh.Url = hfHinhAnh.Value;
hinhanh.LoaiHinhAnh= new clsLoaiHinhAnh();
if (Request.QueryString["loaiid"] != null && !String.IsNullOrEmpty(Request.QueryString["loaiid"]))
hinhanh.LoaiHinhAnh.Id = Convert.ToInt32(Request.QueryString["loaiid"].ToString());
hinhanh.Tour= new clsTour();
if (Request.QueryString["tourid"] != null && !String.IsNullOrEmpty(Request.QueryString["tourid"]))
hinhanh.Tour.Id = Convert.ToInt32(Request.QueryString["tourid"].ToString());
string filename = "";
if (Request.QueryString["action"].ToString().Equals("new"))
{
if (this.fuFile.HasFile)
{
filename = clsBSFileUpload.SaveFile(this.fuFile, Server.MapPath("~/Images/HinhAnh/"));
hinhanh.Url = filename;
}
obj.Insert(hinhanh);
this.Page.ClientScript.RegisterStartupScript(Page.GetType(), "show", "<script type='text/javascript'>alert('Thêm mới thành công')</script>");
}
else
{
if (Request.QueryString["action"].ToString().Equals("edit"))
{
if (Request.QueryString["ID"] != null)
{
int id = Convert.ToInt32(Request.QueryString["ID"]);
hinhanh.Id = id;
if (this.fuFile.HasFile)
{
clsBSFileUpload.DeleteFile(Server.MapPath("~/Images/HinhAnh/") + this.hfHinhAnh.Value);
filename = clsBSFileUpload.SaveFile(this.fuFile, Server.MapPath("~/Images/HinhAnh/"));
hinhanh.Url = filename;
}
obj.Update(hinhanh);
this.Page.ClientScript.RegisterStartupScript(Page.GetType(), "show", "<script type='text/javascript'>alert('Cập nhật thành công')</script>");
}
}
}
}
this.odsHinhAnh.DataBind();
this.GridView1.DataBind();
}
catch (Exception)
{
throw;
}
}
public clsHinhAnh GetById(int id)
{
try
{
clsHinhAnh obj = new clsHinhAnh();
obj.Tour = new clsTour();
obj.LoaiHinhAnh = new clsLoaiHinhAnh();
string str = "select * from tblHinhAnh where id=@id";
SqlCommand com = new SqlCommand(str, con.getCon());
com.Parameters.AddWithValue("@id", id);
con.openCon();
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
obj.Id = id;
if (dr["tieude"] != DBNull.Value)
{
obj.TieuDe = dr["tieude"].ToString();
}
if (dr["url"] != DBNull.Value)
{
obj.Url = dr["url"].ToString();
}
if (dr["Loai"] != DBNull.Value)
{
obj.LoaiHinhAnh.Id = Convert.ToInt32(dr["Loai"].ToString());
}
if (dr["tourid"] != DBNull.Value)
{
obj.Tour.Id = Convert.ToInt32(dr["tourid"].ToString());
}
}
return obj;
}
catch (Exception)
{
throw;
}
finally
{
con.closeCon();
}
}
public int Insert(clsHinhAnh obj)
{
try
{
return this.obj.Insert(obj);
}
catch (Exception)
{
throw;
}
}
public void Update(clsHinhAnh obj)
{
try
{
this.obj.Update(obj);
}
catch (Exception)
{
throw;
}
}
public List<clsHinhAnh> GetByLoai(int loai)
{
try
{
List<clsHinhAnh> list = new List<clsHinhAnh>();
string str = "select * from tblHinhAnh where loai=@loai";
SqlCommand com = new SqlCommand(str, con.getCon());
com.Parameters.AddWithValue("@loai", loai);
con.openCon();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
clsHinhAnh obj = new clsHinhAnh();
obj.Tour = new clsTour();
obj.LoaiHinhAnh = new clsLoaiHinhAnh();
if (dr["tieude"] != DBNull.Value)
{
obj.TieuDe = dr["tieude"].ToString();
}
if (dr["url"] != DBNull.Value)
{
obj.Url = dr["url"].ToString();
}
if (dr["Loai"] != DBNull.Value)
{
obj.LoaiHinhAnh.Id = Convert.ToInt32(dr["Loai"].ToString());
}
if (dr["tourid"] != DBNull.Value)
{
obj.Tour.Id = Convert.ToInt32(dr["tourid"].ToString());
}
if (dr["id"] != DBNull.Value)
{
obj.Id = Convert.ToInt32(dr["id"].ToString());
}
list.Add(obj);
}
return list;
}
catch (Exception)
{
throw;
}
finally
{
con.closeCon();
}
}
public void Update(clsHinhAnh obj)
{
try
{
string str = "Update tblHinhAnh set tieude=@tieude,url=@url,loai=@loai,tourid=@tourid where id=@id";
SqlCommand com = new SqlCommand(str, con.getCon());
com.Parameters.AddWithValue("@tieude", obj.TieuDe);
com.Parameters.AddWithValue("@url", obj.Url);
com.Parameters.AddWithValue("@loai", obj.LoaiHinhAnh.Id);
if (obj.Tour.Id > 0)
com.Parameters.AddWithValue("@tourid", obj.Tour.Id);
else
{
com.Parameters.AddWithValue("@tourid", DBNull.Value);
}
com.Parameters.AddWithValue("@id", obj.Id);
con.openCon();
com.ExecuteNonQuery();
con.closeCon();
}
catch (Exception)
{
throw;
}
finally
{
con.closeCon();
}
}
public int Insert(clsHinhAnh obj)
{
try
{
string str = "insert into tblHinhAnh(tieude,url,loai,tourid) values(@tieude,@url,@loai,@tourid)";
SqlCommand com = new SqlCommand(str, con.getCon());
com.Parameters.AddWithValue("@tieude", obj.TieuDe);
com.Parameters.AddWithValue("@url", obj.Url);
com.Parameters.AddWithValue("@loai", obj.LoaiHinhAnh.Id);
if (obj.Tour.Id > 0)
com.Parameters.AddWithValue("@tourid", obj.Tour.Id);
else
{
com.Parameters.AddWithValue("@tourid", DBNull.Value);
}
con.openCon();
com.ExecuteNonQuery();
con.closeCon();
return clsDAStaticMethod.getIDIdentity("tblHinhAnh");
}
catch (Exception)
{
throw;
}
finally
{
con.closeCon();
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("Xoa"))
{
clsHinhAnh hinhanh = new clsHinhAnh();
hinhanh = obj.GetById(Convert.ToInt32(e.CommandArgument));
clsBSFileUpload.DeleteFile(Server.MapPath("~/Images/HinhAnh/") + hinhanh.Url);
obj.Delete(Convert.ToInt32(e.CommandArgument));
this.GridView1.DataBind();
}
else
{
if (e.CommandName.Equals("sua"))
{
Response.Redirect("HinhAnh.aspx?action=edit&id=" + e.CommandArgument + "&loaiid=" + Request.QueryString["loaiid"] + "&tourid=" + Request.QueryString["tourid"]);
}
}
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Request.QueryString["action"] != null)
{
if (this.pnInfo.Visible == false)
{
if (Request.QueryString["action"].ToString().Equals("new"))
{
this.pnInfo.Visible = true;
this.txtTieuDe.Text = "";
this.imgHinhAnh.ImageUrl = "";
}
else
{
if (Request.QueryString["action"].ToString().Equals("edit"))
{
if (Request.QueryString["ID"] != null)
{
this.pnInfo.Visible = true;
int id = Convert.ToInt32(Request.QueryString["ID"]);
clsHinhAnh hinhanh = new clsHinhAnh();
hinhanh = obj.GetById(id);
this.txtTieuDe.Text = hinhanh.TieuDe;
this.imgHinhAnh.ImageUrl = "~/Images/HinhAnh/" + hinhanh.Url;
this.hfHinhAnh.Value = hinhanh.Url;
}
}
}
}
}
else
{
this.pnInfo.Visible = false;
}
}
catch (Exception)
{
throw;
}
}