public int BUS_ql_batdongsan(obj_BDS obj, int opt, string anhct)
{
try
{
DataSet ds = new DataSet();
DbCommand dbCommand = db.GetStoredProcCommand("ql_batdongsan");
db.AddInParameter(dbCommand, "@opt", DbType.Int32, opt);
db.AddInParameter(dbCommand, "@mabds", DbType.Int32, obj.maBDS);
db.AddInParameter(dbCommand, "@tenBDS", DbType.String, obj.tenBDS);
db.AddInParameter(dbCommand, "@diachi", DbType.String, obj.diachi);
db.AddInParameter(dbCommand, "@gia", DbType.String, obj.gia);
db.AddInParameter(dbCommand, "@noidung", DbType.String, obj.noidung);
db.AddInParameter(dbCommand, "@ghichu", DbType.String, obj.ghichu);
db.AddInParameter(dbCommand, "@daban", DbType.Boolean, obj.daban);
db.AddInParameter(dbCommand, "@makv", DbType.Int32, obj.maKV);
db.AddInParameter(dbCommand, "@maloaibds", DbType.Int32, obj.maLoaiBDS);
db.AddInParameter(dbCommand, "@noibat", DbType.Boolean, obj.noibat);
db.AddInParameter(dbCommand, "@anhdaidien", DbType.String, obj.hinhanh);
db.AddInParameter(dbCommand, "@anhchitiet", DbType.String, anhct);
db.AddInParameter(dbCommand, "@youtube", DbType.String, obj.youtube);
db.AddOutParameter(dbCommand, "@tt", DbType.Int32, 100);
db.ExecuteNonQuery(dbCommand);
return(Convert.ToInt32(db.GetParameterValue(dbCommand, "@tt")));
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnluu_Click(object sender, EventArgs e)
{
try
{
obj_BDS obj = new obj_BDS();
obj.maBDS = 0;
obj.tenBDS = txtTenBDS.Text.ToString();
obj.diachi = txtDiachi.Text.ToString();
obj.gia = txtGia.Text.ToString();
obj.noidung = fckNoidung.Value;
obj.ghichu = "";
obj.daban = chkDaBan.Checked;
obj.maKV = Convert.ToInt32(drlKhuvuc.SelectedItem.Value.ToString());
obj.maLoaiBDS = Convert.ToInt32(drlLoaiBDS.SelectedItem.Value.ToString());
obj.noibat = chkNoiBat.Checked;
obj.youtube = link.Text.ToString();
string anhdaidien, anhct = "", stranhct = "";
if (txtanhdaidien.FileName != "")
{
//anhdaidien = Server.MapPath("..\\Images\\nhadat\\" + txtanhdaidien.FileName);
anhdaidien = Server.MapPath("~/Images/nhadat/" + txtanhdaidien.FileName);
txtanhdaidien.PostedFile.SaveAs(anhdaidien);
anhdaidien = txtanhdaidien.FileName;
}
else
{
anhdaidien = "Empty.jpg";
}
obj.hinhanh = anhdaidien;
if (txtanhct.HasFiles)
{
foreach (HttpPostedFile uploadedFile in txtanhct.PostedFiles)
{
uploadedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/Images/nhadat/"), uploadedFile.FileName));
stranhct += uploadedFile.FileName + ",";
}
}
int tt = admin.BUS_ql_batdongsan(obj, 1, stranhct);
if (tt != 0)
{
lblthongbao.Text = "Thêm mới thành công!";
Clear();
}
else
{
lblthongbao.Text = "Thêm thất bại.Vui lòng kiểm tra lại!";
}
}
catch { }
}
protected void Viewedit_ItemCommand(object sender, FormViewCommandEventArgs e)
{
try
{
string command = e.CommandArgument.ToString();
if (e.CommandName == "Capnhat")
{
obj_BDS obj = new obj_BDS();
obj.maBDS = int.Parse(command);
TextBox tenbds = (TextBox)Viewedit.FindControl("txtTenBDS");
obj.tenBDS = tenbds.Text.ToString();
TextBox diachi = (TextBox)Viewedit.FindControl("txtDiachi");
obj.diachi = diachi.Text.ToString();
TextBox gia = (TextBox)Viewedit.FindControl("txtGia");
obj.gia = gia.Text.ToString();
FredCK.FCKeditorV2.FCKeditor noidung = (FredCK.FCKeditorV2.FCKeditor)Viewedit.FindControl("fckNoidung");
obj.noidung = noidung.Value;
obj.ghichu = "";
CheckBox daban = (CheckBox)Viewedit.FindControl("chkDaBan");
obj.daban = daban.Checked;
DropDownList khuvuc = (DropDownList)Viewedit.FindControl("drlKhuvuc");
obj.maKV = Convert.ToInt32(khuvuc.SelectedItem.Value.ToString());
DropDownList loaibds = (DropDownList)Viewedit.FindControl("drlLoaiBDS");
obj.maLoaiBDS = Convert.ToInt32(loaibds.SelectedItem.Value.ToString());
CheckBox noibat = (CheckBox)Viewedit.FindControl("chkNoiBat");
obj.noibat = noibat.Checked;
TextBox youtube = (TextBox)Viewedit.FindControl("txtyoutube");
obj.youtube = youtube.Text.ToString();
string anhdaidien, anhct = "", stranhct = "";
FileUpload txtanhdaidien = (FileUpload)Viewedit.FindControl("txtanhdaidien");
Label lblanhdaidien = (Label)Viewedit.FindControl("lblanhdaidien");
if (txtanhdaidien.FileName == "" && lblanhdaidien.Text != "")
{
anhdaidien = lblanhdaidien.Text.ToString().Replace("Images/nhadat/", "");
}
else if (txtanhdaidien.FileName != "")
{
//anhdaidien = Server.MapPath("..\\Images\\nhadat\\" + txtanhdaidien.FileName);
anhdaidien = Server.MapPath("~/Images/nhadat/" + txtanhdaidien.FileName);
txtanhdaidien.PostedFile.SaveAs(anhdaidien);
anhdaidien = txtanhdaidien.FileName;
}
else
{
anhdaidien = "Empty.jpg";
}
obj.hinhanh = anhdaidien;
FileUpload txtanhct = (FileUpload)Viewedit.FindControl("txtanhct");
Label lblanhct = (Label)Viewedit.FindControl("lblanhct");
GridView gv = (GridView)Viewedit.FindControl("gv_tenfile");
if (txtanhct.FileName == "")
{
DataTable dt = new DataTable();
dt = (DataTable)Session["anhct"];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
stranhct += dt.Rows[i]["anhct"].ToString().Replace("Images/nhadat/", "") + ",";
}
}
}
else if (txtanhct.HasFiles)
{
foreach (HttpPostedFile uploadedFile in txtanhct.PostedFiles)
{
uploadedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/Images/nhadat/"), uploadedFile.FileName));
stranhct += uploadedFile.FileName + ",";
}
}
int tt = admin.BUS_ql_batdongsan(obj, 2, stranhct);
Label thongbao = (Label)Viewedit.FindControl("lblthongbao");
if (tt != 0)
{
laydsBDS();
//thongbao.Text = "Cập nhật thành công!";
lblthongbao.Text = "Cập nhật thành công!";
//ScriptManager.RegisterStartupScript(this.Page, GetType(), "Message", "An_hien_tbao()", true);
}
else
{
lblthongbao.Text = "Thêm thất bại.Vui lòng kiểm tra lại!";
//ScriptManager.RegisterStartupScript(this.Page, GetType(), "Message", "An_hien_tbao()", true);
}
}
}
catch { }
}
