public void SaveImagesAttachAll()
{
T_Tinbai_Anh _obj = new T_Tinbai_Anh();
int _ID = 0;
if (dgrListImages.Items.Count > 0)
{
_daltinanh.DeleteAllTinbai_AnhByMatinbai(_matinbai);
foreach (DataListItem m_Item in dgrListImages.Items)
{
_ID = Convert.ToInt32(dgrListImages.DataKeys[m_Item.ItemIndex].ToString());
TextBox txtTacgia = m_Item.FindControl("txtTacgia") as TextBox;
TextBox hdnValueTacGiaAnh = m_Item.FindControl("hdnValueTacGiaAnh") as TextBox;
TextBox txtChuthich = m_Item.FindControl("txtChuthich") as TextBox;
if (_ID != 0)
{
if (_matinbai != 0)
{
_obj.Ma_TinBai = _matinbai;
_obj.Ma_Anh = _ID;
_obj.ChuThich = "";
_daltinanh.InsertUpdateTin_Anh(_obj);
}
_objimg = _dalanh.GetOneFromT_AnhByID(_ID);
string _chuthich = "";
string _tacgia = "";
int _tacgiaID = 0;
if (txtChuthich.Text != "")
{
_chuthich = UltilFunc.RemoveEnterCode(txtChuthich.Text.Trim().Replace("'", "''"));
}
if (_objimg != null && _objimg.Ma_Nguoichup != 0)
{
_tacgia = txtTacgia.Text.Replace(" -- ", "|").Split('|')[0];
_tacgiaID = _objimg.Ma_Nguoichup;
}
if (!String.IsNullOrEmpty(hdnValueTacGiaAnh.Text))
{
_tacgia = txtTacgia.Text.Replace(" -- ", "|").Split('|')[0];
_tacgiaID = int.Parse(hdnValueTacGiaAnh.Text.ToString());
}
string SqlUpdate = "";
SqlUpdate = "update T_Anh set Chuthich=N'" + _chuthich + "',NguoiChup=N'" + _tacgia + "',Ma_Nguoichup=" + _tacgiaID + " where Ma_Anh=" + _ID;
Ulti.ExecSql(SqlUpdate);
}
}
}
}
public bool SaveImagesAttachAll()
{
T_Anh objimage = new T_Anh();
AnhDAL _dalanh = new AnhDAL();
int _ID = 0;
if (dgrListImages.Items.Count > 0)
{
foreach (DataListItem m_Item in dgrListImages.Items)
{
_ID = Convert.ToInt32(dgrListImages.DataKeys[m_Item.ItemIndex].ToString());
TextBox txtTacgia = m_Item.FindControl("txtTacgia") as TextBox;
TextBox hdnValueTacGiaAnh = m_Item.FindControl("hdnValueTacGiaAnh") as TextBox;
TextBox txtChuthich = m_Item.FindControl("txtChuthich") as TextBox;
if (_ID != 0)
{
objimage = _dalanh.GetOneFromT_AnhByID(_ID);
string _chuthich = "";
string _tacgia = "";
int _tacgiaID = 0;
if (txtChuthich.Text != Global.RM.GetString("Nhapchuthichanh"))
{
_chuthich = UltilFunc.RemoveEnterCode(txtChuthich.Text.Trim().Replace("'", "''"));
}
if (objimage != null && objimage.Ma_Nguoichup != 0)
{
_tacgia = txtTacgia.Text.Replace(" -- ", "|").Split('|')[0];
_tacgiaID = objimage.Ma_Nguoichup;
}
if (!String.IsNullOrEmpty(hdnValueTacGiaAnh.Text))
{
_tacgia = txtTacgia.Text.Replace(" -- ", "|").Split('|')[0];
_tacgiaID = int.Parse(hdnValueTacGiaAnh.Text.ToString());
}
if (txtChuthich.Text == Global.RM.GetString("Nhapchuthichanh"))
{
FuncAlert.AlertJS(this, "bạn chưa nhập chú thích ảnh");
return(false);
}
if (_tacgiaID == 0)
{
FuncAlert.AlertJS(this, "bạn chưa nhập tác giả ảnh");
return(false);
}
string SqlUpdate = "";
SqlUpdate = "update T_Anh set Chuthich=N'" + _chuthich + "',NguoiChup=N'" + _tacgia + "',Ma_Nguoichup=" + _tacgiaID + " where Ma_Anh=" + _ID;
Ulti.ExecSql(SqlUpdate);
}
}
}
return(true);
}
public void dgrListImages_EditCommand(object source, DataListCommandEventArgs e)
{
T_Anh objimage = new T_Anh();
AnhDAL _dalanh = new AnhDAL();
ImageButton btnAdd = e.Item.FindControl("btnAdd") as ImageButton;
ImageButton btnUpdate = e.Item.FindControl("btnUpdate") as ImageButton;
ImageButton btnCancel = e.Item.FindControl("btnCancel") as ImageButton;
ImageButton btndelete = e.Item.FindControl("Imagebuttondelete") as ImageButton;
TextBox hdnValueTacGiaAnh = e.Item.FindControl("hdnValueTacGiaAnh") as TextBox;
TextBox txtTacgia = e.Item.FindControl("txtTacgia") as TextBox;
TextBox txtChuthich = e.Item.FindControl("txtChuthich") as TextBox;
Label lbdesc = e.Item.FindControl("lbdesc") as Label;
Label lbtacgia = e.Item.FindControl("lbtacgia") as Label;
int _ID = Convert.ToInt32(dgrListImages.DataKeys[e.Item.ItemIndex].ToString());
objimage = _dalanh.GetOneFromT_AnhByID(_ID);
if (e.CommandArgument.ToString().ToLower() == "delete")
{
Label lbFileAttach = e.Item.FindControl("lbFileAttach") as Label;
string path = HttpContext.Current.Server.MapPath("~" + lbFileAttach.Text);
System.IO.FileInfo fi = new System.IO.FileInfo(path);
try
{
if (File.Exists(path))
{
fi.Delete();
}
}
catch (Exception ex)
{
throw ex;
}
_dalanh.DeleteFromT_Anh(_ID);
string thaotac = "Thao tác xóa ảnh đính kèm: " + objimage.Duongdan_Anh + " tại " + Request["MaDoiTuong"].ToString() + " thuộc tin bài: " + Txt_tieude.Text.Trim();
UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), thaotac);
LoadDataImage();
}
if (e.CommandArgument.ToString().ToLower() == "editinfo")
{
btndelete.Visible = false;
btnAdd.Visible = false;
btnUpdate.Visible = true;
btnCancel.Visible = true;
lbdesc.Visible = false;
lbtacgia.Visible = false;
txtTacgia.Visible = true;
txtChuthich.Visible = true;
if (objimage != null && objimage.Ma_Nguoichup != 0)
{
hdnValueTacGiaAnh.Text = objimage.Ma_Nguoichup.ToString();
}
else
{
hdnValueTacGiaAnh.Text = "";
}
if (objimage.NguoiChup != "")
{
txtTacgia.Text = objimage.NguoiChup;
}
else
{
txtTacgia.Text = Global.RM.GetString("Nhaptacgiaanh");
}
if (objimage.Chuthich.Length > 0)
{
txtChuthich.Text = objimage.Chuthich;
}
else
{
txtChuthich.Text = Global.RM.GetString("Nhapchuthichanh");
}
}
if (e.CommandArgument.ToString().ToLower() == "update")
{
string _chuthich = "";
string _tacgia = "";
int _tacgiaID = 0;
if (txtChuthich.Text != Global.RM.GetString("Nhapchuthichanh"))
{
_chuthich = UltilFunc.RemoveEnterCode(txtChuthich.Text.Trim().Replace("'", "''"));
}
if (objimage != null && objimage.Ma_Nguoichup != 0)
{
_tacgia = txtTacgia.Text.Replace(" -- ", "|").Split('|')[0];
_tacgiaID = objimage.Ma_Nguoichup;
}
if (!String.IsNullOrEmpty(hdnValueTacGiaAnh.Text))
{
_tacgia = txtTacgia.Text.Replace(" -- ", "|").Split('|')[0];
_tacgiaID = int.Parse(hdnValueTacGiaAnh.Text.ToString());
}
if (txtChuthich.Text == Global.RM.GetString("Nhapchuthichanh"))
{
FuncAlert.AlertJS(this, "bạn chưa nhập chú thích ảnh");
return;
}
if (_tacgiaID == 0)
{
FuncAlert.AlertJS(this, "bạn chưa nhập tác giả ảnh");
return;
}
string SqlUpdate = "";
SqlUpdate = "update T_Anh set Chuthich=N'" + _chuthich + "',NguoiChup=N'" + _tacgia + "',Ma_Nguoichup=" + _tacgiaID + " where Ma_Anh=" + _ID;
Ulti.ExecSql(SqlUpdate);
LoadDataImage();
lbdesc.Text = txtChuthich.Text;
lbtacgia.Text = txtTacgia.Text;
btnAdd.Visible = true;
btnUpdate.Visible = false;
btnCancel.Visible = false;
lbdesc.Visible = true;
lbtacgia.Visible = true;
txtChuthich.Visible = false;
txtTacgia.Visible = false;
}
if (e.CommandArgument.ToString().ToLower() == "cancel")
{
btndelete.Visible = true;
btnAdd.Visible = true;
btnUpdate.Visible = false;
btnCancel.Visible = false;
lbdesc.Visible = true;
lbtacgia.Visible = true;
txtTacgia.Visible = false;
txtChuthich.Visible = false;
}
}