/// <summary>
/// Tìm kiếm sv theo niên khóa mục quản lý sinh viên
/// </summary>
/// <returns>trả về bảng sinh viên</returns>
public static DataTable Timkiemnienkhoa(int i, string id, int idkythi, int idkhoa, int idlop)
{
try
{
string str = null;
switch (i)
{
case 1:
str =
"SELECT ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop,'false' as [Chon] " +
"FROM SINHVIEN s,LOP l WHERE not exists (SELECT x.IdSV FROM XEPPHONG x WHERE x.IdSV = s.MaSV and x.IdKyThi = " + idkythi + ") " +
"and s.IdLop = l.ID and l.ID = " + idlop + " and s.MaSV like '%" + id + "' ORDER BY TenSV";
break;
case 2:
str =
"SELECT ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop,'false' as [Chon] " +
"FROM SINHVIEN s,LOP l, KHOA k WHERE not exists (SELECT x.IdSV FROM XEPPHONG x WHERE x.IdSV = s.MaSV and x.IdKyThi = " + idkythi + ") " +
"and s.IdLop = l.ID and l.IdKhoa = k.ID and k.ID = " + idkhoa + " and s.MaSV like '%" + id + "' ORDER BY TenSV";
break;
case 3:
str =
"SELECT ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop,'false' as [Chon] " +
"FROM SINHVIEN s,LOP l WHERE not exists (SELECT x.IdSV FROM XEPPHONG x WHERE x.IdSV = s.MaSV and x.IdKyThi = " + idkythi + ") " +
"and s.IdLop = l.ID and s.MaSV like '%" + id + "' ORDER BY TenSV";
break;
}
return(Conn.GetTable(str));
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
return(null);
}
}
public ActionResult UpdateCustomerCare(string key, string json, int agencyId)
{
var msg = new JsonMessage(false, "Sở thích cập nhật thành công.");
try
{
if (key != Keyapi)
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
var model = _da.GetById(ItemId);
var NoteCate = Request["NoteCate"];
var customerCare = model.Customer_Care.Where(v => v.AgencyId == agencyId).FirstOrDefault();
if (customerCare != null)
{
customerCare.Note = HttpUtility.UrlDecode(NoteCate);
}
else
{
customerCare = new Customer_Care
{
Note = HttpUtility.UrlDecode(NoteCate),
AgencyId = Agencyid()
};
model.Customer_Care.Add(customerCare);
}
_da.Save();
}
catch (Exception ex)
{
msg.Erros = true;
msg.Message = "Dữ liệu chưa được cập nhật";
Log2File.LogExceptionToFile(ex);
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
public static DataTable Timkiemnienkhoa3(int i, string id, int idkhoa, int idlop)
{
try
{
string str = null;
switch (i)
{
case 1:
str = "SELECT ROW_NUMBER() OVER(ORDER BY l.MaLop, s.TenSV) as [STT],s.MaSV,s.HoSV,s.TenSV,s.NgaySinh," +
"s.IdLop,l.MaLop,l.IdKhoa,k.TenKhoa " +
"FROM SINHVIEN s,LOP l, KHOA k " +
"WHERE s.IdLop = l.ID and l.IdKhoa = k.ID and l.ID = " + idlop + " and s.MaSV like '%" + id + "' ORDER BY l.MaLop, s.TenSV";
break;
case 2:
str = "SELECT ROW_NUMBER() OVER(ORDER BY l.MaLop, s.TenSV) as [STT],s.MaSV,s.HoSV,s.TenSV,s.NgaySinh," +
"s.IdLop,l.MaLop,l.IdKhoa,k.TenKhoa " +
"FROM SINHVIEN s,LOP l, KHOA k " +
"WHERE s.IdLop = l.ID and l.IdKhoa = k.ID and k.ID = " + idkhoa + " and s.MaSV like '%" + id + "' ORDER BY l.MaLop, s.TenSV";
break;
case 3:
str = "SELECT ROW_NUMBER() OVER(ORDER BY l.MaLop, s.TenSV) as [STT],s.MaSV,s.HoSV,s.TenSV,s.NgaySinh," +
"s.IdLop,l.MaLop,l.IdKhoa,k.TenKhoa " +
"FROM SINHVIEN s,LOP l, KHOA k " +
"WHERE s.IdLop = l.ID and l.IdKhoa = k.ID and s.MaSV like '%" + id + "' ORDER BY l.MaLop, s.TenSV";
break;
}
return(Conn.GetTable(str));
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
return(null);
}
}
private void txtPathBackup_EditorButtonClick(object sender,
Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
{
try
{
var openfiledialog = new OpenFileDialog
{
Filter = @"Excel Files|*.bak;*bak",
Multiselect = false,
Title = @"Chọn file bak",
CheckFileExists = true,
CheckPathExists = true
};
if (openfiledialog.ShowDialog() == DialogResult.OK)
{
_str = openfiledialog.FileName;
txtPathBackup.Text = _str;
}
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
public ActionResult LockAgency(string key, string lstInt)
{
var msg = new JsonMessage(false, "Cập nhật dữ liệu thành công.");
try
{
if (key == Keyapi)
{
var obj = _da.GetListByArrId(lstInt);
foreach (var item in obj)
{
item.IsLock = true;
}
_da.Save();
}
}
catch (Exception ex)
{
msg.Erros = true;
msg.Message = "Dữ liệu chưa được cập nhật.";
Log2File.LogExceptionToFile(ex);
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
private void dgv_DanhSach_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
try
{
var band = e.Layout.Bands[0];
band.Columns["IdKyThi"].Hidden = true;
band.Columns["ThangDiem"].Hidden = true;
band.Override.CellAppearance.TextHAlign = HAlign.Center;
band.Override.HeaderAppearance.FontData.SizeInPoints = 10;
band.Override.HeaderAppearance.FontData.Bold = DefaultableBoolean.True;
band.Columns["MaMon"].MinWidth = 140;
band.Columns["MaDe"].MinWidth = 140;
band.Columns["CauHoi"].MinWidth = 140;
band.Columns["Dapan"].MinWidth = 140;
band.Columns["MaMon"].MaxWidth = 150;
band.Columns["MaDe"].MaxWidth = 150;
band.Columns["CauHoi"].MaxWidth = 150;
band.Columns["Dapan"].MaxWidth = 150;
band.Override.HeaderClickAction = HeaderClickAction.SortSingle;
#region Caption
band.Columns["MaMon"].Header.Caption = @"Mã môn thi";
band.Columns["MaDe"].Header.Caption = @"Mã đề thi";
band.Columns["CauHoi"].Header.Caption = @"Câu hỏi";
band.Columns["Dapan"].Header.Caption = @"Đáp án";
#endregion
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
public ActionResult Add(string key, string json)
{
var msg = new JsonMessage(false, "Thêm mới dữ liệu thành công.");
var model = new DN_Vote();
try
{
if (key != Keyapi)
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
UpdateModel(model);
model.Name = HttpUtility.UrlDecode(model.Name);
_da.Add(model);
_da.Save();
}
catch (Exception ex)
{
msg.Erros = true;
msg.Message = "Dữ liệu chưa được thêm mới.";
Log2File.LogExceptionToFile(ex);
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
// áp dụng nhiều kỳ thi
public static DataTable[] KiemTraLogic(IList <int> list)
{
var tb = new DataTable[list.Count];
try
{
var str = new string[list.Count];
for (var i = 0; i < list.Count; i++)
{
str[i] =
"select bl.MaSV,s.HoSV,s.TenSV,s.NgaySinh,l.MaLop, p.TenPhong" +
" from BAILAM bl join XEPPHONG x on bl.MaSV = x.IdSV join SINHVIEN s on bl.MaSV = s.MaSV join LOP l on s.IdLop = l.ID join PHONGTHI p on x.IdPhong = p.ID" +
" where IdKyThi = " + list[i] + " and not exists( select c.MaSV From (" +
Getstr2(list) + " ) c where bl.MaSV = c.MaSV)";
tb[i] = Conn.GetTable(str[i]);
}
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
return(tb);
}
private void ChonSinhVien()
{
try
{
var save = new SqlBulkCopy();
var tbxp = save.tbXepPhong();
foreach (var row in dgv_DanhSach.Rows)
{
if (!bool.Parse(row.Cells["Chon"].Text))
{
continue;
}
tbxp.Rows.Add(row.Cells["MaSV"].Text, _idkythi);
}
//save.Bulk_Insert("XEPPHONG",tbxp);
save.sp_InsertUpdate("sp_InsertXepPhong", "@tbl", tbxp);
Invoke((Action)(() => MessageBox.Show(@"Lưu lại thành công", @"Thông báo")));
Invoke((Action)(Close));
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
protected override void LoadFormDetail()
{
try
{
var frm = new FrmGopKetQua {
Check = false
};
frm.ShowDialog();
_list = frm.LstIdKyThi;
if (_list.Count > 0 && frm.Check)
{
var thread = new Thread(LoadGrid)
{
IsBackground = true
};
thread.Start();
OnShowDialog("Loading...");
}
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
public ActionResult Delete(string key, string lstArrId)
{
var msg = new JsonMessage(false, "Xóa dữ liệu thành công.");
try
{
if (key == Keyapi)
{
var lstProduct = _da.ListByArrId(lstArrId);
foreach (var item in lstProduct)
{
item.IsDeleted = true;
}
_da.Save();
}
}
catch (Exception ex)
{
msg.Erros = true;
msg.Message = "Dữ liệu chưa được xóa.";
Log2File.LogExceptionToFile(ex);
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
private void Rptdsbailam()
{
try
{
if (dgv_DanhSach.Rows.Count == 0)
{
return;
}
reportManager1.DataSources.Clear();
reportManager1.DataSources.Add("danhsach", dgv_DanhSach.DataSource);
rptdsbailam.FilePath = Application.StartupPath + @"\Reports\dsbailam.rst";
rptdsbailam.Prepare();
rptdsbailam.GetReportParameter += GetParameter;
var previewForm = new PreviewForm(rptdsbailam)
{
WindowState = FormWindowState.Maximized
};
previewForm.Show();
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
public ActionResult Actions()
{
var msg = new JsonMessage();
var category = new Category();
var parent = new Category();
List <Category> ltsCategoryItems;
StringBuilder stbMessage;
switch (DoAction)
{
case ActionType.Add:
try
{
UpdateModel(category);
category.LanguageId = Fdisystem.LanguageId;
category.IsDeleted = false;
category.CreatedDate = DateTime.Now;
//category.AgencyId = int.Parse(WebConfig.AgencyId);
parent = _categoryDa.GetById(category.ParentId ?? 0);
if (parent != null)
{
category.IsLevel = parent.IsLevel + 1;
}
_categoryDa.Add(category);
_categoryDa.Save();
msg = new JsonMessage
{
Erros = false,
ID = category.Id.ToString(),
Message = string.Format("Đã thêm mới chuyên mục: <b>{0}</b>", Server.HtmlEncode(category.Name))
};
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
break;
case ActionType.Edit:
try
{
category = _categoryDa.GetById(ArrId.FirstOrDefault());
UpdateModel(category);
//category.AgencyId = int.Parse(WebConfig.AgencyId);
parent = _categoryDa.GetById(category.ParentId ?? 0);
if (parent != null)
{
category.IsLevel = parent.IsLevel + 1;
}
category.Type = !string.IsNullOrEmpty(Request["Type"]) ? Convert.ToInt32(Request["Type"]) : 0;
_categoryDa.Save();
msg = new JsonMessage
{
Erros = false,
ID = category.Id.ToString(),
Message = string.Format("Đã cập nhật chuyên mục: <b>{0}</b>", Server.HtmlEncode(category.Name))
};
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
break;
case ActionType.Delete:
ltsCategoryItems = _categoryDa.GetListByArrId1(ArrId);
stbMessage = new StringBuilder();
foreach (var item in ltsCategoryItems)
{
try
{
item.IsDeleted = true;
stbMessage.AppendFormat("Đã xóa chuyên mục <b>{0}</b>.<br />", Server.HtmlEncode(item.Name));
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
msg.ID = string.Join(",", ArrId);
_categoryDa.Save();
msg.Message = stbMessage.ToString();
break;
case ActionType.Show:
ltsCategoryItems = _categoryDa.GetListByArrId1(ArrId).Where(o => o.IsShow == false).ToList(); //Chỉ lấy những đối tượng ko được hiển thị
stbMessage = new StringBuilder();
foreach (var item in ltsCategoryItems)
{
try
{
item.IsShow = true;
stbMessage.AppendFormat("Đã hiển thị chuyên mục <b>{0}</b>.<br />", Server.HtmlEncode(item.Name));
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
_categoryDa.Save();
msg.ID = string.Join(",", ltsCategoryItems.Select(o => o.Id));
msg.Message = stbMessage.ToString();
break;
case ActionType.Hide:
ltsCategoryItems = _categoryDa.GetListByArrId1(ArrId).Where(o => o.IsShow == true).ToList(); //Chỉ lấy những đối tượng được hiển thị
stbMessage = new StringBuilder();
foreach (var item in ltsCategoryItems)
{
try
{
item.IsShow = false;
stbMessage.AppendFormat("Đã ẩn chuyên mục <b>{0}</b>.<br />", Server.HtmlEncode(item.Name));
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
_categoryDa.Save();
msg.ID = string.Join(",", ltsCategoryItems.Select(o => o.Id));
msg.Message = stbMessage.ToString();
break;
case ActionType.Order:
try
{
if (!string.IsNullOrEmpty(Request["OrderValues"]))
{
var orderValues = Request["OrderValues"];
if (orderValues.Contains("|"))
{
foreach (var keyValue in orderValues.Split('|'))
{
if (keyValue.Contains("_"))
{
var tempCategory = _categoryDa.GetById(Convert.ToInt32(keyValue.Split('_')[0]));
tempCategory.Sort = Convert.ToInt32(keyValue.Split('_')[1]);
_categoryDa.Save();
}
}
}
msg.ID = string.Join(",", orderValues);
msg.Message = "Đã cập nhật lại thứ tự chuyên mục";
}
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
break;
}
if (string.IsNullOrEmpty(msg.Message))
{
msg.Message = "Không có hành động nào được thực hiện.";
msg.Erros = true;
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
private void cboHocky_SelectedValueChanged(object sender, EventArgs e)
{
try
{
_idhocky = cboHocky.SelectedValue.ToString();
if (_idhocky == "0")
{
if (_idnamhoc == 0)
{
if (_idlop != 0)
{
dgv_DanhSach.DataSource = SearchData.Timkiemtheolop1(_idlop);
}
else if (_idkhoa != 0)
{
dgv_DanhSach.DataSource = SearchData.Timkiemtheokhoa1(_idkhoa);
}
else
{
LoadGrid();
}
}
else if (_idlop != 0)
{
dgv_DanhSach.DataSource = SearchData.Quanlydiem(1, _idkhoa, _idlop, _idnamhoc, _idhocky);
}
else if (_idkhoa != 0)
{
dgv_DanhSach.DataSource = SearchData.Quanlydiem(2, _idkhoa, _idlop, _idnamhoc, _idhocky);
}
else
{
dgv_DanhSach.DataSource = SearchData.Quanlydiem(3, _idkhoa, _idlop, _idnamhoc, _idhocky);
}
}
else if (_idnamhoc != 0)
{
if (_idlop != 0)
{
dgv_DanhSach.DataSource = SearchData.Quanlydiem(7, _idkhoa, _idlop, _idnamhoc, _idhocky);
}
else if (_idkhoa != 0)
{
dgv_DanhSach.DataSource = SearchData.Quanlydiem(8, _idkhoa, _idlop, _idnamhoc, _idhocky);
}
else
{
dgv_DanhSach.DataSource = SearchData.Quanlydiem(9, _idkhoa, _idlop, _idnamhoc, _idhocky);
}
}
else if (_idlop != 0)
{
dgv_DanhSach.DataSource = SearchData.Quanlydiem(4, _idkhoa, _idlop, _idnamhoc, _idhocky);
}
else if (_idkhoa != 0)
{
dgv_DanhSach.DataSource = SearchData.Quanlydiem(5, _idkhoa, _idlop, _idnamhoc, _idhocky);
}
else
{
dgv_DanhSach.DataSource = SearchData.Quanlydiem(6, _idkhoa, _idlop, _idnamhoc, _idhocky);
}
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
private void dgv_DanhSach_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
try
{
var band = e.Layout.Bands[0];
band.Groups.Clear();
band.Columns["IdNamHoc"].Hidden = true;
band.Override.HeaderAppearance.FontData.Bold = DefaultableBoolean.True;
band.Override.HeaderAppearance.FontData.SizeInPoints = 10;
band.Columns["STT"].CellActivation = Activation.NoEdit;
band.Columns["STT"].CellAppearance.BackColor = Color.LightCyan;
#region Caption
var columns = band.Columns;
band.ColHeadersVisible = false;
var group6 = band.Groups.Add("STT");
var group0 = band.Groups.Add("Mã SV");
var group1 = band.Groups.Add("Họ và tên");
var group7 = band.Groups.Add("Lớp");
var group2 = band.Groups.Add("Ngày sinh");
var group3 = band.Groups.Add("Năm học");
var group4 = band.Groups.Add("Học kỳ");
var group5 = band.Groups.Add("Điểm");
columns["STT"].Group = group6;
columns["MaSV"].Group = group0;
columns["HoSV"].Group = group1;
columns["TenSV"].Group = group1;
columns["MaLop"].Group = group7;
columns["NgaySinh"].Group = group2;
columns["NamHoc"].Group = group3;
columns["HocKy"].Group = group4;
columns["Diem"].Group = group5;
#endregion
#region Size
band.Columns["STT"].MinWidth = 60;
band.Columns["STT"].MaxWidth = 70;
band.Columns["MaSV"].MinWidth = 100;
band.Columns["MaSV"].MaxWidth = 120;
band.Columns["HoSV"].MinWidth = 130;
band.Columns["HoSV"].MaxWidth = 150;
band.Columns["TenSV"].MinWidth = 90;
band.Columns["TenSV"].MaxWidth = 100;
band.Columns["MaLop"].MinWidth = 90;
band.Columns["MaLop"].MaxWidth = 100;
band.Columns["NgaySinh"].MinWidth = 100;
band.Columns["NgaySinh"].MaxWidth = 100;
band.Columns["NamHoc"].MinWidth = 140;
band.Columns["NamHoc"].MaxWidth = 150;
band.Columns["HocKy"].MinWidth = 100;
band.Columns["HocKy"].MaxWidth = 110;
band.Columns["Diem"].MinWidth = 100;
band.Columns["Diem"].MaxWidth = 120;
#endregion
columns["STT"].CellAppearance.TextHAlign = HAlign.Center;
columns["MaSV"].CellAppearance.TextHAlign = HAlign.Center;
columns["NamHoc"].CellAppearance.TextHAlign = HAlign.Center;
columns["Diem"].CellAppearance.TextHAlign = HAlign.Center;
columns["TenSV"].CellAppearance.TextHAlign = HAlign.Center;
columns["MaLop"].CellAppearance.TextHAlign = HAlign.Center;
columns["HocKy"].CellAppearance.TextHAlign = HAlign.Center;
foreach (var column in band.Columns)
{
column.CellActivation = Activation.NoEdit;
}
dgv_DanhSach.DisplayLayout.UseFixedHeaders = true;
dgv_DanhSach.DisplayLayout.FixedHeaderOffImage = Properties.Resources.trang;
dgv_DanhSach.DisplayLayout.FixedHeaderOnImage = Properties.Resources.trang;
group0.Header.Fixed = true;
group1.Header.Fixed = true;
group2.Header.Fixed = true;
group6.Header.Fixed = true;
group7.Header.Fixed = true;
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
private bool Checkghi()
{
try
{
var b = true;
if (string.IsNullOrEmpty(txtmasinhvien.Text))
{
b = false;
errormasinhvien.SetError(txtmasinhvien, "Không được để trống");
}
else
{
errormasinhvien.Dispose();
}
if (string.IsNullOrEmpty(txthotendem.Text))
{
b = false;
errorhodem.SetError(txthotendem, "Không được để trống");
}
else
{
errorhodem.Dispose();
}
if (string.IsNullOrEmpty(txttensinhvien.Text))
{
b = false;
errortensinhvien.SetError(txttensinhvien, "Không được để trống");
}
else
{
errortensinhvien.Dispose();
}
if (string.IsNullOrEmpty(cbongaysinh.Text))
{
b = false;
errormasinhvien.SetError(cbongaysinh, "Không được để trống");
}
else
{
errorngaysinh.Dispose();
}
if (string.IsNullOrEmpty(cbokhoa.Text))
{
b = false;
errorkhoa.SetError(cbokhoa, "Không được để trống");
}
else
{
errorkhoa.Dispose();
}
if (string.IsNullOrEmpty(cbolop.Text))
{
b = false;
errorlop.SetError(cbolop, "Không được để trống");
}
else
{
errorlop.Dispose();
}
return(b);
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
return(false);
}
}
public ActionResult Update(string key, string json)
{
var msg = new JsonMessage(false, "Cập nhật dữ liệu thành công.");
try
{
if (key == Keyapi)
{
var objitem = JsonConvert.DeserializeObject <AgencyItem>(json);
var obj = _da.GetById(objitem.ID);
var check = obj.GroupID != objitem.GroupID;
if (obj.GroupID > 0 && check)
{
_da.InsertDNModule(objitem.GroupID, obj.ID, true);
}
obj = UpdateBase(obj, objitem);
_da.Save();
if (!string.IsNullOrEmpty(objitem.Pass))
{
var user = _daUserDa.GetUserByUserName(objitem.UserName);
if (user != null)
{
var sha1PasswordHash = FDIUtils.CreatePasswordHash(objitem.Pass, user.PasswordSalt);
user.Password = sha1PasswordHash;
}
else
{
var date = ConvertDate.TotalSeconds(DateTime.Now);
var role = _darRoleDa.GetByName("Admin");
if (role == null)
{
role = new DN_Roles {
RoleId = Guid.NewGuid(), RoleName = "Admin", LoweredRoleName = "admin", AgencyID = obj.ID, Description = "Quản trị"
};
_darRoleDa.Add(role);
_darRoleDa.Save();
}
var saltKey = FDIUtils.CreateSaltKey(5);
var sha1PasswordHash = FDIUtils.CreatePasswordHash(objitem.Pass, saltKey);
user = new DN_Users
{
UserId = Guid.NewGuid(),
PasswordSalt = saltKey,
Password = sha1PasswordHash,
UserName = objitem.UserName,
LoweredUserName = obj.Name,
Email = obj.Email,
Address = obj.Address,
AgencyID = obj.ID,
Mobile = obj.Phone,
IsApproved = true,
IsLockedOut = false,
CreateDate = date,
IsDeleted = false
};
_daUserDa.Add(user);
var dnUsersInRoles = new DN_UsersInRoles
{
UserId = role.RoleId,
AgencyID = obj.ID,
DateCreated = date
};
user.DN_UsersInRoles.Add(dnUsersInRoles);
}
_daUserDa.Save();
}
}
}
catch (Exception ex)
{
msg.Erros = true;
msg.Message = "Dữ liệu chưa được cập nhật.";
Log2File.LogExceptionToFile(ex);
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
/// <summary>
///
/// </summary>
/// <param name="key"></param>
/// <param name="phone">UserName</param>
/// <param name="mobile">SĐT3G</param>
/// <param name="pass">Mật khẩu</param>
/// <param name="address">Địa chỉ</param>
/// <returns></returns>
public ActionResult Addapp(string key, string phone, string mobile, string pass, string address, string name, int gid)
{
var objr = new CustomerAppItem
{
UserName = phone,
Status = 0
};
try
{
if (key == Keyapi && !string.IsNullOrEmpty(phone) && !string.IsNullOrEmpty(pass))
{
if (_da.CheckUserName(phone))
{
return(Json(objr, JsonRequestBehavior.AllowGet));
}
var daten = DateTime.Now;
var date = daten.TotalSeconds();
var saltKey = FDIUtils.CreateSaltKey(5);
var sha1PasswordHash = FDIUtils.CreatePasswordHash(pass, saltKey);
var obj = new Base.Customer
{
Address = address,
FullName = name,
GroupID = gid,
Phone = phone,
PasswordSalt = saltKey,
PassWord = sha1PasswordHash,
UserName = phone,
DateCreated = date,
IsDelete = false,
IsActive = true,
Reward = 0,
};
_da.Add(obj);
_da.Save();
var datee = daten.AddDays(5).TotalSeconds();
//var lg = new Ultils();
var code = Ultils.CodeLogin(daten);
var dNlogin = new DN_Login
{
CustomerID = obj.ID,
DateCreated = date,
DateEnd = datee,
Code = code,
IsOut = false
};
_dl.Add(dNlogin);
_dl.Save();
objr = new CustomerAppItem
{
ID = obj.ID,
UserName = phone,
Address = address,
FullName = name,
Phone = mobile,
Reward = 0,
GroupID = gid,
Status = 1,
};
}
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
return(Json(objr, JsonRequestBehavior.AllowGet));
}
public ActionResult Add(string key, string json)
{
var msg = new JsonMessage(false, "Thêm mới dữ liệu thành công.");
try
{
if (key == Keyapi)
{
var date = DateTime.Now.TotalSeconds();
var objitem = JsonConvert.DeserializeObject <AgencyItem>(json);
var obj = new DN_Agency
{
IsDelete = false,
IsLock = false,
IsOut = false,
CreateDate = date,
WalletValue = 10000000,
CashOut = 0,
};
obj = UpdateBase(obj, objitem);
_da.Add(obj);
_da.Save();
if (objitem.GroupID > 0)
{
_da.InsertDNModule(objitem.GroupID, obj.ID);
}
var saltKey = FDIUtils.CreateSaltKey(5);
var sha1PasswordHash = FDIUtils.CreatePasswordHash(objitem.Pass, saltKey);
var user = new DN_Users
{
UserId = Guid.NewGuid(),
PasswordSalt = saltKey,
Password = sha1PasswordHash,
UserName = objitem.UserName,
LoweredUserName = obj.Name,
Email = obj.Email,
Address = obj.Address,
AgencyID = obj.ID,
Mobile = obj.Phone,
IsApproved = true,
IsLockedOut = false,
CreateDate = date,
IsDeleted = false
};
_daUserDa.Add(user);
_daUserDa.Save();
var role = new DN_Roles {
RoleId = Guid.NewGuid(), RoleName = "Admin", LoweredRoleName = "admin", AgencyID = obj.ID, Description = "Quản trị"
};
_darRoleDa.Add(role);
var dnUsersInRoles = new DN_UsersInRoles
{
UserId = user.UserId,
AgencyID = obj.ID,
DateCreated = date,
IsDelete = false
};
role.DN_UsersInRoles.Add(dnUsersInRoles);
_darRoleDa.Save();
}
}
catch (Exception ex)
{
msg.Erros = true;
msg.Message = "Dữ liệu chưa được thêm mới.";
Log2File.LogExceptionToFile(ex);
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
public ActionResult Update(string key, string codelogin, Guid?userId)
{
var msg = new JsonMessage(false, "Thêm mới dữ liệu thành công.");
try
{
if (key == Keyapi)
{
var model = _da.GetById(ItemId);
UpdateModel(model);
model.DateUpdate = DateTime.Now.TotalSeconds();
model.UserID = userId;
var lst = model.ProductValue_Recipe.Where(c => c.IsDeleted == false || !c.IsDeleted.HasValue).ToList();
var lstNew = GetListRecipeValueItem(codelogin);
//xóa
var result1 = lst.Where(p => lstNew.All(p2 => p2.ProductValueId != p.ProductValueId));
foreach (var i in result1)
{
i.IsDeleted = true;
}
//Sửa
foreach (var i in lst)
{
var j = lstNew.FirstOrDefault(c => c.ProductValueId == i.ProductValueId);
if (j != null)
{
i.Quantity = j.Quantity;
}
}
//thêm mới
var result2 = lstNew.Where(p => lst.All(p2 => p2.ProductValueId != p.ProductValueId)).ToList();
foreach (var item in result2)
{
model.ProductValue_Recipe.Add(item);
}
//var vaulePrice = model.ProductValue_Recipe.Sum(a => a.Quantity * a.Shop_Product_Value.Price);
//
var lstDetail = model.Mapping_ProductDetail_Recipe.Where(c => c.IsDeleted == false || !c.IsDeleted.HasValue).ToList();
var lstNewDetail = GetListRecipeDetailItem(codelogin);
//xóa
var resultDetail = lstDetail.Where(p => lstNewDetail.All(p2 => p2.DetailID != p.DetailID));
foreach (var i in resultDetail)
{
i.IsDeleted = true;
}
//Sửa
foreach (var i in lstDetail)
{
var j = lstNewDetail.FirstOrDefault(c => c.DetailID == i.DetailID);
if (j != null)
{
i.Quantity = j.Quantity;
}
}
//thêm mới
var result2Detail = lstNewDetail.Where(p => lstDetail.All(p2 => p2.DetailID != p.DetailID)).ToList();
foreach (var item in result2Detail)
{
model.Mapping_ProductDetail_Recipe.Add(item);
}
//var productPrice = model.Mapping_ProductDetail_Recipe.Sum(a => a.Quantity * a.Shop_Product_Detail.PriceCost);
_da.Save();
//var detail = _detailDa.GetById(model.ProductDetailId ?? 0);
//var pricecost = vaulePrice + productPrice;
//model.ProductPrice = productPrice;
//model.ValuePrice = vaulePrice;
//detail.PriceCost = pricecost;
//detail.PriceOld = pricecost + detail.Percent * 1000 + (detail.Incurred ?? 0);
_da.Save();
}
}
catch (Exception ex)
{
msg.Erros = true;
msg.Message = "Dữ liệu chưa được thêm mới.";
Log2File.LogExceptionToFile(ex);
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
public ActionResult Addproduct(string key, string json)
{
var msg = new JsonMessage(false, "Thêm mới sản phẩm thành công.");
try
{
if (key == Keyapi)
{
var model = _da.GetProductById(ItemId);
var product = _da.GetById(ItemId);
var list = new List <Shop_Product>();
foreach (var item in model)
{
var size = Request["Size_old" + item.ID];
var Type = Request["Type_old" + item.ID];
var price = Request["Price_old" + item.ID];
if (string.IsNullOrEmpty(size))
{
list.Add(item);
}
else
{
item.SizeID = int.Parse(size);
item.TypeID = int.Parse(Type);
item.PriceNew = decimal.Parse(price);
_da.Save();
}
}
foreach (var item in list)
{
_da.DeleteProduct(item);
}
var stt = ConvertUtil.ToInt32(Request["do_stt"]);
for (int i = 1; i <= stt; i++)
{
var name = Request["Size_add_" + i];
var type = Request["Type_add_" + i];
var price = Request["Price_add_" + i];
if (!string.IsNullOrEmpty(name))
{
var obj = new Shop_Product()
{
ProductDetailID = product.ID,
SizeID = int.Parse(name),
TypeID = int.Parse(type),
IsShow = true,
IsDelete = false,
};
obj.PriceNew = decimal.Parse(price);
_da.AddProduct(obj);
}
}
_da.Save();
}
}
catch (Exception ex)
{
msg.Erros = true;
msg.Message = "Dữ liệu chưa được Cập nhật.";
Log2File.LogExceptionToFile(ex);
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Load dữ liệu theo kỳ thi
/// </summary>
/// <param name="chon"></param>
/// <param name="idKythi"></param>
/// <returns>trả về 1 table</returns>
/// 1. Sinh viên đã được xếp phòng
/// 2.3.4. RptPhongthi - 109_SinhVienDuThi
/// 5. Sĩ số phòng đã được xếp sinh viên
/// 6: Trả về danh sách bài làm của sinh viên
/// 7: Đáp án
/// 8: Kiểm tra lỗi logic
/// 9: Nhập thang điểm
/// 10: In điểm thi
/// 11. Phòng thi đã được chọn
/// 12. Sinh viên đã được chọn để thi
/// 13: Sinh viên chưa được xếp phòng trong bảng XEPPHONG với IdPhong là null
/// 14: Phong thi có SiSo nhỏ hơn SucChua
/// 15: Bảng BAILAM với sinh viên đã được chấm thì DiemThi not null
public static DataTable Load(int chon, int idKythi)
{
var table = new DataTable();
string str = null;
try
{
switch (chon)
{
case 1:
str =
"SELECT ROW_NUMBER() OVER(ORDER BY p.TenPhong,s.TenSV) as [STT], " +
"s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop, p.TenPhong, k.TenKhoa, l.IdKhoa, x.IdPhong " +
"FROM SINHVIEN s " +
"join XEPPHONG x on s.MaSV = x.IdSV " +
"join PHONGTHI p on x.IdPhong = p.ID " +
"join LOP l on s.IdLop = l.ID " +
"join KHOA k on l.IdKhoa = k.ID " +
"WHERE x.IdKyThi = " + idKythi + " order by p.TenPhong, s.TenSV";
break;
case 2:
str = "SELECT p.TenPhong " +
"FROM PHONGTHI p join XEPPHONG x on p.ID = x.IdPhong " +
"where x.IdKyThi = " + idKythi + " ORDER BY p.TenPhong";
break;
case 3:
str = "SELECT * FROM KYTHI WHERE ID = " + idKythi + "";
break;
case 4:
str = "SELECT l.MaLop " +
"FROM LOP l join SINHVIEN s on l.ID = s.IdLop " +
"join XEPPHONG x on s.MaSV = x.IdSV " +
"where x.IdKyThi = " + idKythi + " GROUP BY l.MaLop";
break;
case 5:
str = "SELECT p.TenPhong, p.SucChua, k.SiSo, k.IdPhong " +
"FROM KT_PHONG k join PHONGTHI p on k.IdPhong = p.ID " +
"WHERE k.IdKyThi = " + idKythi + "";
break;
case 6:
str = "SELECT ROW_NUMBER() OVER(ORDER BY b.MaSV) as [STT]," +
" b.* " +
"FROM BAILAM b " +
"WHERE b.IdKyThi = " + idKythi + "";
break;
case 7:
str = "SELECT MaMon, MaDe, CauHoi, Dapan, ThangDiem " +
"FROM DAPAN d, KYTHI k " +
"WHERE d.IdKyThi = k.ID and d.IdKyThi = " + idKythi + "";
break;
case 2051:
str = "select b.MaSV" +
" FROM BAILAM b" +
" where b.IdKyThi = " + idKythi + "" +
" and not exists (select * from XEPPHONG x where b.MaSV = x.IdSV and x.IdKyThi = " + idKythi + ") ORDER BY b.MaSV";
break;
case 2052:
str = "select x.IdSV,s.HoSV,s.TenSV,s.NgaySinh,l.MaLop, p.TenPhong from XEPPHONG x join SINHVIEN s on x.IdSV = s.MaSV join LOP l on s.IdLop = l.ID join PHONGTHI p on x.IdPhong = p.ID " +
" where x.IdKyThi = " + idKythi + " and" +
" not exists (select b.MaSV from BAILAM b where b.MaSV = x.IdSV and b.IdKyThi = " + idKythi + ")";
break;
case 9:
str =
"SELECT MaMon, MaDe, CauHoi, Dapan, ThangDiem " +
"FROM DAPAN d, KYTHI k " +
"WHERE d.IdKyThi = k.ID and d.IdKyThi = " + idKythi + "";
break;
case 10:
str =
"SELECT ROW_NUMBER() OVER(ORDER BY b.MaSV) as [STT], b.MaSV, s.HoSV, s.TenSV,s.NgaySinh,l.MaLop, b.DiemThi " +
"FROM BAILAM b join SINHVIEN s on b.MaSV = s.MaSV " +
"join LOP l on s.IdLop = l.ID " +
"WHERE b.IdKyThi = " + idKythi + " ";
break;
case 11:
str =
"select ROW_NUMBER() OVER(ORDER BY p.ID) as [STT], " +
"p.ID, p.TenPhong,p.SucChua, kt.SiSo " +
"From KT_PHONG kt join PHONGTHI p on kt.IdPhong = p.ID " +
"where kt.IdKyThi = " + idKythi + "";
break;
case 12:
str =
"SELECT ROW_NUMBER() OVER(ORDER BY s.MaSV) as [STT], " +
"s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop, x.IdPhong " +
"FROM SINHVIEN s join XEPPHONG x on s.MaSV = x.IdSV " +
"join LOP l on s.IdLop = l.ID " +
"WHERE x.IdKyThi = " + idKythi + "";
break;
case 13:
str =
"SELECT ROW_NUMBER() OVER(ORDER BY x.IdSV) as [STT],x.IdSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, '' as [PhongThi] " +
"FROM XEPPHONG x join SINHVIEN s on x.IdSV = s.MaSV " +
"join LOP l on s.IdLop = l.ID " +
"where x.IdPhong is null and x.IdKyThi = " + idKythi + "";
break;
case 131:
str =
"SELECT ROW_NUMBER() OVER(ORDER BY x.IdSV) as [STT],x.IdSV, x.IdKyThi, x.IdPhong " +
"FROM XEPPHONG x " +
"where x.IdPhong is null and x.IdKyThi = " + idKythi + "";
break;
case 14:
str =
"SELECT k.IdPhong, p.SucChua, k.SiSo, p.TenPhong " +
"FROM KT_PHONG k join PHONGTHI p on k.IdPhong = p.ID " +
"WHERE k.SiSo < p.SucChua and k.IdKyThi = " + idKythi + "";
break;
case 15:
str = "SELECT ROW_NUMBER() OVER(ORDER BY s.MaSV) as [STT], " +
"s.MaSV,s.HoSV,s.TenSV,s.NgaySinh,l.MaLop,b.DiemThi " +
"FROM BAILAM b join SINHVIEN s on b.MaSV = s.MaSV " +
"join LOP l on s.IdLop = l.ID " +
"WHERE b.IdKyThi = " + idKythi + " and b.DiemThi is not null";
break;
case 207:
str = "SELECT ROW_NUMBER() OVER(ORDER BY b.MaSV) as [STT], b.* " +
"FROM BAILAM b " +
"WHERE b.IdKyThi = " + idKythi + "";
break;
case 209:
str =
"select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], b.MaSV, s.HoSV,s.TenSV, s.NgaySinh, l.MaLop,b.MaDe, b.DiemThi " +
"from BAILAM b join SINHVIEN s on b.MaSV = s.MaSV " +
"join LOP l on s.IdLop = l.ID " +
"where b.DiemThi is not null and IdKyThi = " + idKythi + " order by TenSV";
break;
}
table = Conn.GetTable(str);
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
return(table);
}
/// <summary>
/// Load dữ liệu
/// </summary>
/// <param name="chon"></param>
/// <returns>trả về 1 table</returns>
/// 1:Trả về bảng thông tin sinh viên gồm lớp khoa
/// 2:Trả về bảng bao gồm mã sinh viên
/// 3:Trả về bảng khoa
/// 4:Trả về bảng lớp
/// 5:Trả về bảng sinh viên đã được xếp phòng
/// 6:Trả về bảng sinh viên chưa được xếp phòng
/// 7:Trả về bảng sinh viên đã được xếp phòng
/// 8:Trả về bảng phòng thi còn xếp được sinh viên(số lượng , sức chứa)
/// 9:Trả về bảng phòng thi
/// 10:Trả về bảng kỳ thi
/// 11:Trả về bảng đáp án các mã đề
/// 12:Trả về danh sách bài làm của sinh viên
/// 13:Kiểm tra những sinh viên có trong danh sách bài thi những không có trong danh sách dự thi
/// 14: trả về bảng TAIKHOAN
/// 15: Khoa
/// 16: Lớp
/// 17: Sinh viên
/// 18: kỳ thi
/// 19: phòng thi
/// 20: lấy ra kỳ thi
/// 21: lấy ra điểm thi cao nhất
/// 22: Năm học
public static DataTable Load(int chon)
{
var table = new DataTable();
string str = null;
try
{
switch (chon)
{
case 1:
str =
"SELECT ROW_NUMBER() OVER(ORDER BY l.MaLop,s.TenSV) as [STT],s.MaSV,s.HoSV,s.TenSV,s.NgaySinh," +
"s.IdLop,l.MaLop,l.IdKhoa,k.TenKhoa " +
"FROM SINHVIEN s,LOP l, KHOA k " +
"WHERE s.IdLop = l.ID and l.IdKhoa = k.ID ORDER BY l.MaLop,s.TenSV";
break;
case 2:
str = "SELECT MaSV FROM SINHVIEN ORDER BY TenSV";
break;
case 3:
str = "SELECT * FROM KHOA";
break;
case 4:
str = "SELECT * FROM LOP";
break;
case 8:
str = "select p.TenPhong, p.SucChua, k.SiSo, k.IdPhong from PHONGTHI p left join KT_PHONG k on p.ID = k.IdPhong";
break;
case 9:
str = "SELECT ROW_NUMBER() OVER(ORDER BY p.ID) as [STT], p.* FROM PHONGTHI p";
break;
case 10:
str = "SELECT ROW_NUMBER() OVER(ORDER BY K.ID) as [STT], K.*, [TT] = case K.TrangThai when 1 then N'Hiển thị' when 0 then N'Ẩn' end FROM KYTHI K";
break;
case 14:
str = "SELECT ROW_NUMBER() OVER(ORDER BY T.ID) as [STT], T.* FROM TAIKHOAN T";
break;
case 15:
str = "SELECT ROW_NUMBER() OVER(ORDER BY K.ID) as [STT], K.* FROM KHOA K";
break;
case 16:
str = "SELECT ROW_NUMBER() OVER(ORDER BY L.MaLop) as [STT], L.*, k.TenKhoa FROM LOP L" +
" join KHOA k on L.IdKhoa = k.id order by L.MaLop";
break;
case 17:
str = "SELECT * FROM SINHVIEN";
break;
case 18:
str = "SELECT ID, MaKT, TenKT FROM KYTHI where TrangThai = 1";
break;
case 20:
str = "SELECT ID, TenKT, 'false' as [Chon] FROM KYTHI where TrangThai = 1 order by ID desc";
break;
case 210:
str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" +
" (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" +
" join SINHVIEN s on d.MaSV = s.MaSV" +
" join LOP l on s.IdLop = l.ID" +
" join KHOA k on l.IdKhoa = k.ID order by s.TenSV";
break;
case 111:
str = "select ROW_NUMBER() OVER(ORDER BY N.ID) as [STT], N.* from NAMHOC N order by N.ID";
break;
case 209:
str = "select N.* from NAMHOC N order by N.ID DESC";
break;
case 211:
str = " select ROW_NUMBER() OVER(ORDER BY d.MaSV) as [STT], d.MaSV, s.HoSV, s.TenSV,l.MaLop,s.NgaySinh,d.IdNamHoc, n.NamHoc, d.HocKy,d.Diem from" +
" DIEMTHI d" +
" join NAMHOC n on d.IdNamHoc = n.ID" +
" join SINHVIEN s on d.MaSV = s.MaSV" +
" join LOP l on s.IdLop = l.ID ORDER BY d.MaSV";
break;
}
table = Conn.GetTable(str);
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
return(table);
}
public ActionResult Actions()
{
var msg = new JsonMessage();
switch (DoAction)
{
case ActionType.Show:
try
{
int total = _api.TotalSim();
const int t = 30000;
int du = total % t;
int p = total / t;
p = du > 0 ? p + 1 : p;
for (int i = 1; i <= p; i++)
{
var filesale = ConfigData.SitemapFolder + "sitemap-sim-so-" + i + ".txt";
System.IO.File.Copy(ConfigData.SitemapFileFolder + file, filesale);
var list = _api.PageProductSitemap(t, i, 2010, total);
var listener = new TextWriterTraceListener(filesale);
const string text = url;
listener.WriteLine(text);
foreach (var item in list)
{
listener.WriteLine(url + "dat-sim-sim-so-dep-0" + item);
}
listener.Flush();
listener.Close();
}
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
msg.Message = ex.Message;
//msg.Message = "Dữ liệu chưa được backup.";
msg.Erros = true;
}
break;
case ActionType.Active:
try
{
string filesale = ConfigData.Folder + "SitemapUpdate.txt";
System.IO.File.Copy(ConfigData.SitemapFileFolder + file, filesale);
System.IO.File.Copy(ConfigData.SitemapFileFolder + "SitemapUpdate.xml", ConfigData.Folder + "SitemapUpdate.xml");
var sSiteMapFilePath = Server.MapPath(@"~/SitemapUpdate.xml");
msg = new JsonMessage(false, "SitemapUpdate đã được cập nhật.");
var xmlDoc = new XmlDocument();
xmlDoc.Load(sSiteMapFilePath);
var listener = new TextWriterTraceListener(filesale);
var listsite = Sitemap.Sitemapsimso();
foreach (var item in listsite)
{
listener.WriteLine(url + item);
var nodeSite = xmlDoc.CreateElement("url");
var loc = xmlDoc.CreateElement("loc");
loc.InnerText = url + item;
//var lastmod = xmlDoc.CreateElement("lastmod");
//lastmod.InnerText = date;
var priority = xmlDoc.CreateElement("priority");
priority.InnerText = string.IsNullOrEmpty(item) ? "1.0" : "0.5";
var changefreq = xmlDoc.CreateElement("changefreq");
changefreq.InnerText = "daily";
nodeSite.AppendChild(loc);
//nodeSite.AppendChild(lastmod);
nodeSite.AppendChild(priority);
nodeSite.AppendChild(changefreq);
XmlNode node = nodeSite;
XmlNode childNode = xmlDoc.DocumentElement;
if (childNode != null)
{
childNode.InsertAfter(node, childNode.LastChild);
}
}
//listener.Flush();
var list = _da.GetListHomeWork();
foreach (var item in list)
{
var nodeSite = xmlDoc.CreateElement("url");
var loc = xmlDoc.CreateElement("loc");
loc.InnerText = url + item.Slug;
listener.WriteLine(url + item.Slug);
//var lastmod = xmlDoc.CreateElement("lastmod");
//lastmod.InnerText = date;
var priority = xmlDoc.CreateElement("priority");
priority.InnerText = "0.5";
var changefreq = xmlDoc.CreateElement("changefreq");
changefreq.InnerText = "daily";
nodeSite.AppendChild(loc);
//nodeSite.AppendChild(lastmod);
nodeSite.AppendChild(priority);
nodeSite.AppendChild(changefreq);
XmlNode node = nodeSite;
XmlNode childNode = xmlDoc.DocumentElement;
if (childNode != null)
{
childNode.InsertAfter(node, childNode.LastChild);
}
}
//listener.Flush();
var listcate = _da.GetTagSitemap();
foreach (var item in listcate)
{
var nodeSite = xmlDoc.CreateElement("url");
var loc = xmlDoc.CreateElement("loc");
loc.InnerText = url + item.Slug;
listener.WriteLine(url + item.Slug);
//var lastmod = xmlDoc.CreateElement("lastmod");
//lastmod.InnerText = date;
var priority = xmlDoc.CreateElement("priority");
priority.InnerText = "0.5";
var changefreq = xmlDoc.CreateElement("changefreq");
changefreq.InnerText = "daily";
nodeSite.AppendChild(loc);
//nodeSite.AppendChild(lastmod);
nodeSite.AppendChild(priority);
nodeSite.AppendChild(changefreq);
XmlNode node = nodeSite;
XmlNode childNode = xmlDoc.DocumentElement;
if (childNode != null)
{
childNode.InsertAfter(node, childNode.LastChild);
}
//listener.Flush();
foreach (var itemnews in item.ListNewsItem)
{
var nodeSiten = xmlDoc.CreateElement("url");
var locn = xmlDoc.CreateElement("loc");
locn.InnerText = url + itemnews + ".html";
listener.WriteLine(url + itemnews + ".html");
//var lastmodn = xmlDoc.CreateElement("lastmod");
//lastmodn.InnerText = date;
var priorityn = xmlDoc.CreateElement("priority");
priorityn.InnerText = "0.5";
var changefreqn = xmlDoc.CreateElement("changefreq");
changefreqn.InnerText = "daily";
nodeSiten.AppendChild(locn);
//nodeSiten.AppendChild(lastmodn);
nodeSiten.AppendChild(priorityn);
nodeSiten.AppendChild(changefreqn);
XmlNode noden = nodeSiten;
XmlNode childNoden = xmlDoc.DocumentElement;
if (childNoden != null)
{
childNoden.InsertAfter(noden, childNoden.LastChild);
}
}
}
var listTag = _da.GetListTag();
foreach (var item in listTag)
{
var nodeSite = xmlDoc.CreateElement("url");
var loc = xmlDoc.CreateElement("loc");
loc.InnerText = url + "tag/" + item.Url;
listener.WriteLine(url + item.Url);
//var lastmod = xmlDoc.CreateElement("lastmod");
//lastmod.InnerText = date;
var priority = xmlDoc.CreateElement("priority");
priority.InnerText = "0.5";
var changefreq = xmlDoc.CreateElement("changefreq");
changefreq.InnerText = "daily";
nodeSite.AppendChild(loc);
//nodeSite.AppendChild(lastmod);
nodeSite.AppendChild(priority);
nodeSite.AppendChild(changefreq);
XmlNode node = nodeSite;
XmlNode childNode = xmlDoc.DocumentElement;
if (childNode != null)
{
childNode.InsertAfter(node, childNode.LastChild);
}
}
listener.Flush();
listener.Close();
xmlDoc.Save(sSiteMapFilePath);
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
msg.Message = ex.Message;
//msg.Message = "Dữ liệu chưa được backup.";
msg.Erros = true;
}
break;
default:
msg.Message = "Không có hành động nào được thực hiện.";
msg.Erros = true;
break;
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
private void GetParameter(object sender,
PerpetuumSoft.Reporting.Components.GetReportParameterEventArgs e)
{
try
{
//double bosung = Statistic.Thongkediem(0, _list).Rows.Count;
//double toiec1 = Statistic.Thongkediem(1, _list).Rows.Count;
//double toiec2 = Statistic.Thongkediem(2, _list).Rows.Count;
//double toiec3 = Statistic.Thongkediem(3, _list).Rows.Count;
//double toiec4 = Statistic.Thongkediem(4, _list).Rows.Count;
//double miengiam = Statistic.Thongkediem(5, _list).Rows.Count;
double bosung = 0;
double toiec1 = 0;
double toiec2 = 0;
double toiec3 = 0;
double toiec4 = 0;
double miengiam = 0;
foreach (var row in dgv_DanhSach.Rows)
{
var d = double.Parse(row.Cells["TongDiem"].Text);
if (d < 200)
{
bosung = bosung + 1;
}
else if (d >= 200 && d < 250)
{
toiec1 += 1;
}
else if (d >= 250 && d < 300)
{
toiec2 += 1;
}
else if (d >= 300 && d < 374)
{
toiec3 += 1;
}
else if (d >= 374 && d < 450)
{
toiec4 += 1;
}
else
{
miengiam += 1;
}
}
var tong = bosung + toiec1 + toiec2 + toiec3 + toiec4 + miengiam;
e.Parameters["bosung"].Value = bosung.ToString();
e.Parameters["toiec1"].Value = toiec1.ToString();
e.Parameters["toiec2"].Value = toiec2.ToString();
e.Parameters["toiec3"].Value = toiec3.ToString();
e.Parameters["toiec4"].Value = toiec4.ToString();
e.Parameters["miengiam"].Value = miengiam.ToString();
e.Parameters["TLbosung"].Value = Math.Round(bosung / tong * 100, 1).ToString();
e.Parameters["TLtoiec1"].Value = Math.Round(toiec1 / tong * 100, 1).ToString();
e.Parameters["TLtoiec2"].Value = Math.Round(toiec2 / tong * 100, 1).ToString();
e.Parameters["TLtoiec3"].Value = Math.Round(toiec3 / tong * 100, 1).ToString();
e.Parameters["TLtoiec4"].Value = Math.Round(toiec4 / tong * 100, 1).ToString();
e.Parameters["TLmiengiam"].Value = Math.Round(miengiam / tong * 100, 1).ToString();
e.Parameters["tong"].Value = tong.ToString();
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
public static DataTable Thongkediem(int index, string s)
{
try
{
string str = null;
switch (index)
{
case 1:
str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" +
" (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" +
" join SINHVIEN s on d.MaSV = s.MaSV" +
" join LOP l on s.IdLop = l.ID" +
" join KHOA k on l.IdKhoa = k.ID" +
" where s.MaSV like '%" + s + "' and d.Diem < 200 order by s.TenSV";
break;
case 2:
str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" +
" (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" +
" join SINHVIEN s on d.MaSV = s.MaSV" +
" join LOP l on s.IdLop = l.ID" +
" join KHOA k on l.IdKhoa = k.ID" +
" where s.MaSV like '%" + s + "' and d.Diem >= 200 and d.Diem < 250 order by s.TenSV";
break;
case 3:
str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" +
" (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" +
" join SINHVIEN s on d.MaSV = s.MaSV" +
" join LOP l on s.IdLop = l.ID" +
" join KHOA k on l.IdKhoa = k.ID" +
" where s.MaSV like '%" + s + "' and d.Diem < 250 order by s.TenSV";
break;
case 4:
str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" +
" (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" +
" join SINHVIEN s on d.MaSV = s.MaSV" +
" join LOP l on s.IdLop = l.ID" +
" join KHOA k on l.IdKhoa = k.ID" +
" where s.MaSV like '%" + s + "' and d.Diem >= 250 and d.Diem < 300 order by s.TenSV";
break;
case 5:
str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" +
" (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" +
" join SINHVIEN s on d.MaSV = s.MaSV" +
" join LOP l on s.IdLop = l.ID" +
" join KHOA k on l.IdKhoa = k.ID" +
" where s.MaSV like '%" + s + "' and d.Diem < 300 order by s.TenSV";
break;
case 6:
str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" +
" (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" +
" join SINHVIEN s on d.MaSV = s.MaSV" +
" join LOP l on s.IdLop = l.ID" +
" join KHOA k on l.IdKhoa = k.ID" +
" where s.MaSV like '%" + s + "' and d.Diem >= 300 and d.Diem < 375 order by s.TenSV";
break;
case 7:
str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" +
" (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" +
" join SINHVIEN s on d.MaSV = s.MaSV" +
" join LOP l on s.IdLop = l.ID" +
" join KHOA k on l.IdKhoa = k.ID" +
" where s.MaSV like '%" + s + "' and d.Diem < 375 order by s.TenSV";
break;
case 8:
str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" +
" (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" +
" join SINHVIEN s on d.MaSV = s.MaSV" +
" join LOP l on s.IdLop = l.ID" +
" join KHOA k on l.IdKhoa = k.ID" +
" where s.MaSV like '%" + s + "' and d.Diem >= 375 and d.Diem < 450 order by s.TenSV";
break;
case 9:
str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" +
" (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" +
" join SINHVIEN s on d.MaSV = s.MaSV" +
" join LOP l on s.IdLop = l.ID" +
" join KHOA k on l.IdKhoa = k.ID" +
" where s.MaSV like '%" + s + "' and d.Diem < 450 order by s.TenSV";
break;
case 10:
str = "select ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], d.MaSV, s.HoSV, s.TenSV,s.NgaySinh, l.MaLop, l.IdKhoa,k.TenKhoa ,d.Diem from" +
" (select MaSV, Max(Diem) as [Diem] from DIEMTHI group by MaSV) d" +
" join SINHVIEN s on d.MaSV = s.MaSV" +
" join LOP l on s.IdLop = l.ID" +
" join KHOA k on l.IdKhoa = k.ID" +
" where d.Diem >= 450 order by s.TenSV";
break;
}
return(Conn.GetTable(str));
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
return(null);
}
}
protected override void DeleteRow()
{
try
{
bool xoa = false;
if (dgv_DanhSach.Selected.Rows.Count > 0)
{
if (DialogResult.Yes ==
MessageBox.Show(FormResource.msgHoixoa, FormResource.MsgCaption, MessageBoxButtons.YesNo,
MessageBoxIcon.Question))
{
foreach (var row in dgv_DanhSach.Selected.Rows)
{
var masv = row.Cells["MaSV"].Text;
var idPhong = row.Cells["IdPhong"].Text;
if (!string.IsNullOrEmpty(idPhong))
{
var ktp = new KTPhong
{
IdKyThi = _idkythi,
IdPhong = int.Parse(idPhong)
};
_listKtPhong.Add(ktp);
}
var xp = new XepPhong
{
IdKyThi = _idkythi,
IdSV = int.Parse(masv)
};
_listXepPhong.Add(xp);
}
DeleteAndUpdate = true;
dgv_DanhSach.DeleteSelectedRows(false);
xoa = true;
}
}
else if (dgv_DanhSach.ActiveRow != null)
{
if (DialogResult.Yes ==
MessageBox.Show(FormResource.msgHoixoa, FormResource.MsgCaption, MessageBoxButtons.YesNo,
MessageBoxIcon.Question))
{
var masv = dgv_DanhSach.ActiveRow.Cells["MaSV"].Text;
var idPhong = dgv_DanhSach.ActiveRow.Cells["IdPhong"].Text;
if (!string.IsNullOrEmpty(idPhong))
{
var ktp = new KTPhong
{
IdKyThi = _idkythi,
IdPhong = int.Parse(idPhong)
};
_listKtPhong.Add(ktp);
}
var xp = new XepPhong
{
IdKyThi = _idkythi,
IdSV = int.Parse(masv)
};
_listXepPhong.Add(xp);
DeleteAndUpdate = true;
dgv_DanhSach.ActiveRow.Delete(false);
xoa = true;
}
}
UpdateData.UpdateGiamSiSo(_listKtPhong);
DeleteData.XoaXepPhong(_listXepPhong);
if (xoa)
{
MessageBox.Show(@"Xóa dữ liệu thành công.", @"Thông báo");
}
LoadGrid();
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
private void dgv_DanhSach_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
try
{
var band = e.Layout.Bands[0];
band.Groups.Clear();
band.Override.HeaderAppearance.FontData.SizeInPoints = 10;
band.Override.HeaderAppearance.FontData.Bold = DefaultableBoolean.True;
band.Columns["STT"].CellAppearance.BackColor = Color.LightCyan;
#region Caption
var columns = band.Columns;
band.ColHeadersVisible = false;
var group5 = band.Groups.Add("STT");
columns["STT"].Group = group5;
var group0 = band.Groups.Add("Mã SV");
columns["MaSV"].Group = group0;
var group1 = band.Groups.Add("Họ và tên");
columns["HoSV"].Group = group1;
columns["TenSV"].Group = group1;
var group2 = band.Groups.Add("Ngày sinh");
columns["NgaySinh"].Group = group2;
var group3 = band.Groups.Add("Lớp");
columns["MaLop"].Group = group3;
for (var i = 0; i < _list.Count; i++)
{
var ten = "Diem" + (i + 1);
var ten1 = "Điểm môn " + (i + 1);
var group = band.Groups.Add(ten1);
band.Columns[ten].Group = group;
band.Columns[ten].MinWidth = 100;
band.Columns[ten].MaxWidth = 110;
band.Columns[ten].CellAppearance.TextHAlign = HAlign.Center;
}
var group4 = band.Groups.Add("Tổng điểm");
columns["TongDiem"].Group = group4;
#endregion
#region Size
band.Columns["STT"].MinWidth = 60;
band.Columns["STT"].MaxWidth = 70;
band.Columns["MaSV"].MinWidth = 100;
band.Columns["MaSV"].MaxWidth = 120;
band.Columns["HoSV"].MinWidth = 130;
band.Columns["HoSV"].MaxWidth = 150;
band.Columns["TenSV"].MinWidth = 90;
band.Columns["TenSV"].MaxWidth = 100;
band.Columns["NgaySinh"].MinWidth = 100;
band.Columns["NgaySinh"].MaxWidth = 100;
band.Columns["MaLop"].MinWidth = 100;
band.Columns["MaLop"].MaxWidth = 110;
band.Columns["TongDiem"].MinWidth = 100;
band.Columns["TongDiem"].MaxWidth = 120;
#endregion
band.Columns["STT"].CellAppearance.TextHAlign = HAlign.Center;
band.Columns["MaSV"].CellAppearance.TextHAlign = HAlign.Center;
band.Columns["TenSV"].CellAppearance.TextHAlign = HAlign.Center;
band.Columns["MaLop"].CellAppearance.TextHAlign = HAlign.Center;
band.Columns["TongDiem"].CellAppearance.TextHAlign = HAlign.Center;
foreach (var coloum in band.Columns)
{
coloum.CellActivation = Activation.NoEdit;
}
dgv_DanhSach.DisplayLayout.UseFixedHeaders = true;
dgv_DanhSach.DisplayLayout.FixedHeaderOffImage = Properties.Resources.trang;
dgv_DanhSach.DisplayLayout.FixedHeaderOnImage = Properties.Resources.trang;
group0.Header.Fixed = true;
group1.Header.Fixed = true;
group2.Header.Fixed = true;
group3.Header.Fixed = true;
group5.Header.Fixed = true;
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
public ActionResult Register(CustomerItem customer)
{
var objr = new CustomerAppItem
{
Status = 0
};
try
{
if (!string.IsNullOrEmpty(customer.Phone) && !string.IsNullOrEmpty(customer.Password))
{
if (_da.CheckUserName(customer.Phone))
{
return(Json(new BaseResponse <CustomerItem>()
{
Erros = true,
Message = "Số điện thoại đã tồn tại",
}, JsonRequestBehavior.AllowGet));
}
var daten = DateTime.Now;
var date = daten.TotalSeconds();
var saltKey = FDIUtils.CreateSaltKey(5);
var sha1PasswordHash = FDIUtils.CreatePasswordHash(customer.Password, saltKey);
//get agencyinfo
var agencyDA = new AgencyDA();
var agency = agencyDA.GetItem(customer.PhoneAgency);
var obj = new Base.Customer
{
FullName = customer.FullName,
Phone = customer.Phone,
PasswordSalt = saltKey,
PassWord = sha1PasswordHash,
UserName = customer.UserName,
DateCreated = date,
IsDelete = false,
IsActive = true,
Reward = 0,
AgencyID = agency?.ID
};
_da.Add(obj);
_da.Save();
IAuthContainerModel model = new JWTContainerModel()
{
Claims = new Claim[]
{
new Claim(ClaimTypes.Name, obj.UserName),
new Claim("ID", obj.ID.ToString()),
}
};
IAuthService authService = new JWTService();
var token = authService.GenerateToken(model);
var result = new BaseResponse <CustomerItem>()
{
Erros = false,
Data = new CustomerItem()
{
FullName = obj.FullName,
Phone = obj.Phone,
Token = token
}
};
return(Json(result, JsonRequestBehavior.AllowGet));
var datee = daten.AddDays(5).TotalSeconds();
//var lg = new Ultils();
var code = Ultils.CodeLogin(daten);
var dNlogin = new DN_Login
{
CustomerID = obj.ID,
DateCreated = date,
DateEnd = datee,
Code = code,
IsOut = false
};
_dl.Add(dNlogin);
_dl.Save();
objr = new CustomerAppItem
{
ID = obj.ID,
Status = 1,
};
}
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
return(Json(objr, JsonRequestBehavior.AllowGet));
}
protected virtual void LoadGrid()
{
try
{
var tb1 = Statistic.GopKetQua(_list);
var tb2 = Statistic.GopKetQua1(_list);
if (tb2.Rows.Count > 0 && _list.Count > 1)
{
IList <Sinhvien> listthongke = new List <Sinhvien>();
foreach (DataRow row in tb2.Rows)
{
var a = int.Parse(row["MaSV"].ToString());
foreach (var sv in listthongke.Where(sv => sv.MaSV == a))
{
for (var i = 0; i < _list.Count; i++)
{
var ten = "Diem" + (i + 1);
var diem = row[ten].ToString();
if (!string.IsNullOrEmpty(diem))
{
sv.Diemthi[i] = int.Parse(row[ten].ToString());
}
}
goto b;
}
var sv1 = new Sinhvien(_list.Count)
{
MaSV = a,
HoSV = row["HoSV"].ToString(),
TenSV = row["TenSV"].ToString(),
MaLop = row["MaLop"].ToString(),
NgaySinh = row["NgaySinh"].ToString(),
};
for (var i = 0; i < _list.Count; i++)
{
var ten = "Diem" + (i + 1);
var diem = row[ten].ToString();
if (!string.IsNullOrEmpty(diem))
{
sv1.Diemthi[i] = double.Parse(row[ten].ToString());
}
else
{
sv1.Diemthi[i] = 0;
}
}
listthongke.Add(sv1);
b :;
}
var t = tb1.Rows.Count;
foreach (var item in listthongke)
{
tb1.Rows.Add(++t, item.MaSV, item.HoSV, item.TenSV, item.NgaySinh, item.MaLop);
for (var i = 0; i < _list.Count; i++)
{
var ten = "Diem" + (i + 1);
tb1.Rows[tb1.Rows.Count - 1][ten] = item.Diemthi[i];
}
tb1.Rows[tb1.Rows.Count - 1]["TongDiem"] = item.Tinhtong();
}
Invoke((Action)(() => _listtk = listthongke));
}
Invoke((Action)(() => dgv_DanhSach.DataSource = tb1));
Invoke((Action)(() => pnl_from.Visible = true));
lock (LockTotal)
{
OnCloseDialog();
}
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
