protected void Page_Load(object sender, EventArgs e)
{
_dotuoi = ConvertUtility.ToString(Request.QueryString["dt"]);
_monhoc = ConvertUtility.ToString(Request.QueryString["mh"]);
_coso = ConvertUtility.ToString(Request.QueryString["cs"]);
if (!IsPostBack)
{
dropFilterMonHoc.DataSource = MonhocDB.GetAll();
dropFilterMonHoc.DataTextField = "Monhoc_Name";
dropFilterMonHoc.DataValueField = "Monhoc_ID";
dropFilterMonHoc.DataBind();
dropFilterMonHoc.Items.Insert(0, new ListItem("Chọn môn học", ""));
dropFilterCoso.DataSource = CosoDB.GetAll();
dropFilterCoso.DataTextField = "Coso_Name";
dropFilterCoso.DataValueField = "Coso_ID";
dropFilterCoso.DataBind();
dropFilterCoso.Items.Insert(0, new ListItem("Chọn cơ sở", ""));
MiscUtility.SetSelected(dropFilterDoTuoi.Items, _dotuoi);
MiscUtility.SetSelected(dropFilterMonHoc.Items, _monhoc);
MiscUtility.SetSelected(dropFilterCoso.Items, _coso);
}
}
protected void dtgData_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "edit")
{
var info = CosoDB.GetInfo(Convert.ToInt32(e.Item.Cells[0].Text));
if (info == null)
{
cmdEmpty_Click(null, null);
return;
}
txtID.Text = info.Coso_ID.ToString();
txtName.Text = info.Coso_Name;
txtDes.Text = info.Coso_Info;
txtAvatar.Text = info.Coso_Map;
}
if (e.CommandName == "del")
{
try
{
CosoDB.Delete(Convert.ToInt32(e.Item.Cells[0].Text));
lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS;
cmdEmpty_Click(null, null);
}
catch
{
lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
_contentid = ConvertUtility.ToInt32(Request.QueryString["contentid"]);
//mydealInfo = MydealItemDB.GetInfo(_contentid);
if (!IsPostBack)
{
ZoneUtility.LoadZonesByParentID(dropLopHoc.Items, ConvertUtility.ToInt32(SettingDB.GetValue(AppEnv.CMS_ZoneKhoaHoc + AppEnv.GetLanguage())));
dropLopHoc.Items.Insert(0, new ListItem("Lựa chọn lớp học", "0"));
chklMonHoc.DataSource = MonhocDB.GetAll();
chklMonHoc.DataTextField = "Monhoc_Name";
chklMonHoc.DataValueField = "Monhoc_ID";
chklMonHoc.DataBind();
chklCoso.DataSource = CosoDB.GetAll();
chklCoso.DataTextField = "Coso_Name";
chklCoso.DataValueField = "Coso_ID";
chklCoso.DataBind();
chkVisible.Checked = true;
}
lblStatusUpdate.Text = string.Empty;
}
protected void Page_Load(object sender, EventArgs e)
{
_dotuoi = ConvertUtility.ToString(Request.QueryString["dt"]);
_monhoc = ConvertUtility.ToString(Request.QueryString["mh"]);
_coso = ConvertUtility.ToString(Request.QueryString["cs"]);
_lophoc = ConvertUtility.ToString(Request.QueryString["lh"]);
_khoahocid = ConvertUtility.ToInt32(Request.QueryString["khoahocid"]);
if (!IsPostBack)
{
MiscUtility.FillIndex(dropDay, 1, 31, DateTime.Now.Day);
MiscUtility.FillIndex(dropMonth, 1, 12, DateTime.Now.Month);
MiscUtility.FillIndex(dropYear, 1950, DateTime.Now.Year, DateTime.Now.Year);
dropFilterMonHoc.DataSource = MonhocDB.GetAll();
dropFilterMonHoc.DataTextField = "Monhoc_Name";
dropFilterMonHoc.DataValueField = "Monhoc_ID";
dropFilterMonHoc.DataBind();
dropFilterMonHoc.Items.Insert(0, new ListItem("Chọn môn học", ""));
dropFilterCoso.DataSource = CosoDB.GetAll();
dropFilterCoso.DataTextField = "Coso_Name";
dropFilterCoso.DataValueField = "Coso_ID";
dropFilterCoso.DataBind();
dropFilterCoso.Items.Insert(0, new ListItem("Chọn cơ sở", ""));
ZoneUtility.LoadZonesByParentID(dropFilterLopHoc.Items, ConvertUtility.ToInt32(SettingDB.GetValue(AppEnv.CMS_ZoneKhoaHoc + AppEnv.GetLanguage())));
dropFilterLopHoc.Items.Insert(0, new ListItem("Chọn lớp học", ""));
MiscUtility.SetSelected(dropFilterDoTuoi.Items, _dotuoi);
MiscUtility.SetSelected(dropFilterMonHoc.Items, _monhoc);
MiscUtility.SetSelected(dropFilterLopHoc.Items, _lophoc);
MiscUtility.SetSelected(dropFilterCoso.Items, _coso);
}
}
protected void rptCoso_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var curData = (DataRowView)e.Item.DataItem;
var litCoso = (Literal)e.Item.FindControl("litCoso");
litCoso.Text = CosoDB.GetNameByID(ConvertUtility.ToInt32(curData["Coso_ID"]));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var dt = DataHelper.GetDataFromTable("SELECT * FROM KhoaHocSolart");
dtgClass.DataSource = dt;
dtgClass.DataBind();
dropCoso.DataSource = CosoDB.GetAll();
dropCoso.DataTextField = "Coso_Name";
dropCoso.DataValueField = "Coso_ID";
dropCoso.DataBind();
}
}
protected void cmdAddNew_Click(object sender, EventArgs e)
{
var info = new CosoInfo();
info.Coso_Name = txtName.Text.Trim();
info.Coso_Info = txtDes.Text;
info.Coso_Map = txtAvatar.Text;
//try
//{
txtID.Text = CosoDB.Insert(info).ToString();
lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS;
//}
//catch
//{
// lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR;
//}
}
protected void cmdUpdate_Click(object sender, EventArgs e)
{
var info = CosoDB.GetInfo(ConvertUtility.ToInt32(txtID.Text));
if (info == null)
{
return;
}
info.Coso_Name = txtName.Text.Trim();
info.Coso_Info = txtDes.Text;
info.Coso_Map = txtAvatar.Text;
try
{
CosoDB.Update(info);
lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR;
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
dtgData.DataSource = CosoDB.GetAll();
dtgData.DataBind();
}
protected void butSend_Click(object sender, EventArgs e)
{
var contactEmail = AppEnv.ContactEmail;
if (txtHocsinhName.Text.Trim().Length == 0 || txtPhuHuynh.Text.Trim().Length == 0 || txtPhone.Text.Trim().Length == 0 || txtAddress.Text.Trim().Length == 0)
{
MessageBox.Show("Bạn phải điền tất cả các ô có dấu (*)");
return;
}
//if(txtCode.Text.Trim() != FormShield1.GetText())
//{
// MessageBox.Show("Bạn nhập không đúng mã bảo vệ");
// return;
//}
const string matchEmailPattern = @"^(([\w-]+\.)+[\w-]+|([a-zA-Z]{1}|[\w-]{2,}))@"
+ @"((([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\.([0-1]?
[0-9]{1,2}|25[0-5]|2[0-4][0-9])\."
+ @"([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\.([0-1]?
[0-9]{1,2}|25[0-5]|2[0-4][0-9])){1}|"
+ @"([a-zA-Z]+[\w-]+\.)+[a-zA-Z]{2,4})$";
if (Regex.IsMatch(txtEmail.Text.Trim(), matchEmailPattern) == false)
{
MessageBox.Show("Email không đúng !!!");
return;
}
var sb = new StringBuilder();
sb.Append("<b>Ho ten hoc sinh</b>: ");
sb.Append(txtHocsinhName.Text);
sb.Append("<br><b>Ten phu huynh</b>: ");
sb.Append(txtPhuHuynh.Text);
sb.Append("<br><b>Email</b>: ");
sb.Append(txtEmail.Text);
sb.Append("<br><b>Dien thoai</b>:<br>");
sb.Append(txtPhone.Text);
sb.Append("<br><b>Dia chi</b>: ");
sb.Append(txtAddress.Text);
sb.Append("<br><b>Ngay sinh</b>:<br>");
sb.Append(txtBirthday.Text);
sb.Append("<br><b>Co so</b>:<br>");
sb.Append(CosoDB.GetNameByID(ConvertUtility.ToInt32(dropCoso.SelectedValue)));
sb.Append("<br><b>Ghi chu</b>:<br>");
sb.Append(txtContent.Text);
// new email solution start
var email = new MailMessage(txtEmail.Text, contactEmail)
{
Subject = "Dang ky khoa hoc tu website",
IsBodyHtml = true,
Body = sb.ToString()
};
var smtp = new SmtpClient
{
Host = AppEnv.MailServer.Length == 0 ? "localhost" : AppEnv.MailServer,
Port =
AppEnv.MailServerPort.Length == 0 ? 25 : ConvertUtility.ToInt32(AppEnv.MailServerPort)
};
// if authentication
if (AppEnv.MailUsername.Length > 0 && AppEnv.MailPassword.Length > 0)
{
smtp.Credentials = new NetworkCredential(AppEnv.MailUsername, AppEnv.MailPassword);
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
}
// if authentication end
var info = new MailInfo
{
Mail_Kind = "lienhe",
Mail_Name = HTMLUtility.SecureHTML(txtHocsinhName.Text),
Mail_Email = HTMLUtility.SecureHTML(txtEmail.Text),
Mail_Phone = HTMLUtility.SecureHTML(txtPhone.Text),
Mail_Address = HTMLUtility.SecureHTML(txtAddress.Text),
Mail_Content = HTMLUtility.SecureHTML(sb.ToString()),
Pix_ID = 0,
Mail_Answer = ConvertUtility.ToBoolean(false),
Mail_Datetime = DateTime.Now
};
MailDB.Insert(info);
try
{
smtp.Send(email);
notice.InnerHtml = "<br><br><br><font color=red><b>Thông tin đăng ký đã được gửi tới " + contactEmail + "...</b></font>";
}
catch (Exception ex)
{
notice.InnerHtml = "<br><br><br><font color=red><b>Thông tin đăng ký đã được gửi đi... Xin chân thành cảm ơn.</b></font>";
ErrorReportDB.NewReport(Request.RawUrl, ex.ToString());
//notice.InnerHtml = "<br><br><br><font color=red><b>Lỗi trong quá trình gửi mail...</b></font><br>" + ex.Message;
}
finally
{
pnform.Visible = false;
notice.Visible = true;
}
}
