public void LoadDataApprovied()
{
string where = " 1=1 ";
if (!String.IsNullOrEmpty(this.txt_tenanh.Text.Trim()))
{
where += " AND " + string.Format(" Ten_Logo like N'%{0}%'", UltilFunc.SqlFormatText(this.txt_tenanh.Text.Trim()));
}
where += " ORDER BY Ma_Logo DESC ";
HPCBusinessLogic.DAL.T_LogoDAL _DAL = new HPCBusinessLogic.DAL.T_LogoDAL();
DataSet _ds;
pageappro.PageSize = 5;
_ds = _DAL.BindGridT_Logo(pageappro.PageIndex, pageappro.PageSize, where);
int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString());
int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count);
if (TotalRecord == 0)
{
_ds = _DAL.BindGridT_Logo(pageappro.PageIndex - 1, pageappro.PageSize, where);
}
dgrListAppro.DataSource = _ds;
dgrListAppro.DataBind();
pageappro.TotalRecords = CurrentPage1.TotalRecords = TotalRecords;
CurrentPage1.TotalPages = pageappro.CalculateTotalPages();
CurrentPage1.PageIndex = pageappro.PageIndex;
Session["CurrentPage"] = pageappro.PageIndex;
}
protected void btnDelete_Click(object sender, EventArgs e)
{
ArrayList ar = new ArrayList();
foreach (DataGridItem m_Item in dgrListAppro.Items)
{
CheckBox chk_Select = (CheckBox)m_Item.FindControl("optSelect");
if (chk_Select != null && chk_Select.Checked)
{
ar.Add(double.Parse(dgrListAppro.DataKeys[int.Parse(m_Item.ItemIndex.ToString())].ToString()));
}
}
if (ar.Count > 0)
{
for (int i = 0; i < ar.Count; i++)
{
int _ID = int.Parse(ar[i].ToString());
HPCBusinessLogic.DAL.T_LogoDAL _DAL = new HPCBusinessLogic.DAL.T_LogoDAL();
_DAL.DeleteFromT_Logo(_ID);
}
}
else
{
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('Chưa chọn ảnh muốn xóa.!!')", true);
return;
}
LoadDataApprovied();
}
public void dgrListAppro_EditCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandArgument.ToString().ToLower() == "edit")
{
dgrListAppro.EditItemIndex = e.Item.ItemIndex;
LoadDataApprovied();
}
if (e.CommandArgument.ToString().ToLower() == "delete")
{
HPCBusinessLogic.DAL.T_LogoDAL _DAL = new HPCBusinessLogic.DAL.T_LogoDAL();
int _ID = Convert.ToInt32(dgrListAppro.DataKeys[e.Item.ItemIndex].ToString());
_DAL.DeleteFromT_Logo(_ID);
LoadDataApprovied();
}
}
public void dgrListAppro_UpdateCommand(object source, DataGridCommandEventArgs e)
{
HPCBusinessLogic.DAL.T_LogoDAL _DAL = new HPCBusinessLogic.DAL.T_LogoDAL();
int _ID = Convert.ToInt32(dgrListAppro.DataKeys[e.Item.ItemIndex].ToString());
TextBox txtTieude = e.Item.FindControl("txtTieude") as TextBox;
string _tieude = "";
if (txtTieude != null)
{
if (!String.IsNullOrEmpty(txtTieude.Text.Trim()))
{
_tieude = txtTieude.Text;
}
}
_DAL.UpdateT_Logo(_ID, _tieude);
dgrListAppro_CancelCommand(source, e);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Write("Hello World");
HttpPostedFile postedFile = context.Request.Files["Filedata"];
string tempPath = System.Configuration.ConfigurationManager.AppSettings["FolderLogo"].ToString() + "/" + DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() + "/";
//Create forder
CreateFolderByUserName(tempPath);
string savepath = context.Server.MapPath("~" + tempPath);
string filename = postedFile.FileName;
string[] sArrTenfile = null;
char[] cat = { '.' };
sArrTenfile = filename.ToString().Trim().Split(cat);
string _extenfile = sArrTenfile[1].ToString();
string _tenfile = GetDateTimeStringUnique() + "." + _extenfile.ToString();
string _tenfilegoc = UltilFunc.RemoveSign4VietnameseString(Path.GetFileNameWithoutExtension(filename)) + "." + _extenfile.ToString();
string fiName = _tenfile.Replace(" ", "");
postedFile.SaveAs(savepath + @"\" + fiName);
//Luu vao CSDL
string _savePath = tempPath + "" + fiName;
HPCBusinessLogic.DAL.T_LogoDAL _DAL = new HPCBusinessLogic.DAL.T_LogoDAL();
T_Logo _obj = new T_Logo();
_obj = SetItem(_savePath, _tenfilegoc);
int _IDreturn = _DAL.InsertUpdateT_Logo(_obj);
//end
context.Response.Write(tempPath + "/" + filename);
context.Response.StatusCode = 200;
}
