private void LoadGrid()
{
DB.DB_Object.ClassAdvisors objClassTrainers = new DB.DB_Object.ClassAdvisors();
DataTable dt = objClassTrainers.getDataAdvisorsAdmin(1, 0, "", "");
lblTotalRows.Text = dt.Rows.Count.ToString();
_grid.DataSource = dt;
_grid.DataBind();
}
private void Update()
{
int intID = Convert.ToInt32(txtTrainerID.Text.Trim());
string strNameEL = CommonClass.StringValidator.GetSafeString(txtNameEL.Text.Trim());
string strNameVN = CommonClass.StringValidator.GetSafeString(txtNameVN.Text.Trim());
string strShortDescriptionEL = CommonClass.StringValidator.GetSafeString(txtShortDescriptionEL.Text.Trim());
string strShortDescriptionVN = CommonClass.StringValidator.GetSafeString(txtShortDescriptionVN.Text.Trim());
string strContentEL = objClassCommon.FilterSQLParamater(txtContentEL.Value);
string strContentVN = objClassCommon.FilterSQLParamater(txtContentVN.Value);
string strPathImages = txtPathImages.Text.Trim();
int intIndexof = int.Parse(txtIndexOf.Text.Trim());
//Khi Admin tiến hành đổi hình ảnh
if (FileUpload1.Visible == true)
{
strPathImages = "~/Images/ImgNews/defaultimage.GIF";
if (!string.IsNullOrEmpty(FileUpload1.FileName) && CheckExtention(FileUpload1) == true)
{
Sycomore.UploadFile Upload = new Sycomore.UploadFile();
Upload.StrFileName = FileUpload1.FileName;
Upload.StrFolder = Server.MapPath("~/Images/ImgNews/");
Upload.Upload(FileUpload1);
strPathImages = "~/Images/ImgNews/" + Upload.StrFileName;
}
}
DB.DB_Object.ClassAdvisors objClassData = new DB.DB_Object.ClassAdvisors();
try
{
if (objClassData.UpdateTrainer(intID, strNameEL, strNameVN, strShortDescriptionEL, strShortDescriptionVN, strContentEL, strContentVN, strPathImages, intIndexof) == true)
{
Response.Redirect("~/Amincp/ManagerAdvisors.aspx");
}
else
{
CommonClass.MessageBox.Show("Lỗi kết nối đến Server. Vui lòng kiểm tra hệ thống mạng!");
}
}
catch (Exception ex)
{
SetErrorMessage(ex.Message);
}
}
private void LoadGridSearch()
{
int IsSelectAll = 0;
int KeyID = 0;
if (txtID.Text.Trim().Length > 0)
{
KeyID = int.Parse(txtID.Text.Trim());
}
string NameEL = CommonClass.StringValidator.GetSafeString(txtNameEL.Text.Trim());
string NameVN = CommonClass.StringValidator.GetSafeString(txtNameVN.Text.Trim());
DB.DB_Object.ClassAdvisors objClassData = new DB.DB_Object.ClassAdvisors();
DataTable dt = objClassData.getDataSearchAdvisors(IsSelectAll, KeyID, NameEL, NameVN);
lblTotalRows.Text = dt.Rows.Count.ToString();
_grid.DataSource = dt;
_grid.DataBind();
}
