public ActionResult Delete(string key, string json)
{
var msg = new JsonMessage(false, "Xóa dữ liệu thành công.");
var pictureId = Request["Value_DefaultImages"];
try
{
if (key != Keyapi)
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
var model = _da.GetById(ItemId);
model.IsDeleted = true;
_da.Save();
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
msg.Erros = true;
msg.Message = "Dữ liệu chưa được xóa";
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
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)
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
var model = _da.GetById(ItemId);
UpdateModel(model);
model.Name = HttpUtility.UrlDecode(model.Name);
_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 ActionResult Update(string key, Guid userId)
{
var msg = new JsonMessage(false, "Cập nhật dữ liệu thành công.");
try
{
if (key != Keyapi)
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
var model = _da.GetById(ItemId);
UpdateModel(model);
model.UserUpdate = userId;
_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 ActionResult Update(string key, string code, string json, int id)
{
var msg = new JsonMessage(false, "Cập nhật dữ liệu thành công.");
try
{
if (key == Keyapi)
{
var departmentItem = JsonConvert.DeserializeObject <DepartmentItem>(json);
var obj = _da.GetById(id);
departmentItem.AgencyID = Agencyid();
UpdateBase(obj, departmentItem);
_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 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);
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);
}
}
private void SuaDiem()
{
try
{
var frm = new FrmSuaDiemThi(_idKyThi)
{
update = false,
txtmasv = { Text = dgv_DanhSach.ActiveRow.Cells["MaSV"].Text },
txtmade = { Text = dgv_DanhSach.ActiveRow.Cells["MaDe"].Text },
txtchuoi = { Text = dgv_DanhSach.ActiveRow.Cells["KetQua"].Text }
};
frm.ShowDialog();
if (frm.update)
{
dgv_DanhSach.ActiveRow.Cells["MaDe"].Value = frm.txtmade.Text;
dgv_DanhSach.ActiveRow.Cells["KetQua"].Value = frm.txtchuoi.Text;
}
}
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 TemplateDocument();
try
{
if (key != Keyapi)
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
UpdateModel(model);
_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));
}
public void Napdulieu()
{
try
{
var frmNapDuLieu = new FrmNapDuLieu(GetTable(), _idKyThi)
{
ViTriHeader = 1
};
frmNapDuLieu.ShowDialog();
var resultValue = frmNapDuLieu.ResultValue;
if (resultValue == null || resultValue.Rows.Count == 0)
{
return;
}
var frm = new FrmImportDapAn(resultValue);
frm.ShowDialog();
Huy();
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
private void InPhong()
{
try
{
if (string.IsNullOrEmpty(txttuphong.Text))
{
txttuphong.Focus();
}
else if (string.IsNullOrEmpty(txtdenphong.Text))
{
txtdenphong.Focus();
}
else
{
update = true;
Close();
}
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
protected override void LoadFormDetail()
{
try
{
var tb = SearchData.KtraChamThi(_idkythi);
if (tb.Rows.Count > 0)
{
if (DialogResult.No ==
MessageBox.Show(@"Bài thi của sv đã được chấm bạn có muốn chấm lại không.",
FormResource.MsgCaption,
MessageBoxButtons.YesNo,
MessageBoxIcon.Question))
{
dgv_DanhSach.DataSource = tb;
pnl_from.Visible = true;
return;
}
}
var thread = new Thread(LoadGrid)
{
IsBackground = true
};
thread.Start();
OnShowDialog("Loading...");
if (_tbError.Rows.Count > 0)
{
var text = @"Còn " + _tbError.Rows.Count + @" bài thi chưa được chấm";
var frm = new FrmMsgImportSv(text, _tbError, 2);
frm.ShowDialog();
}
pnl_from.Visible = true;
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
private void Rptbangdiem()
{
try
{
var frm = new FrmRptBangDiem {
bUpdate = false
};
frm.ShowDialog();
if (!frm.bUpdate)
{
return;
}
_masv = frm.Masv;
var tb = LoadData.LoadBangdiem(int.Parse(frm.Masv));
if (tb.Rows.Count > 0)
{
reportManager1.DataSources.Clear();
reportManager1.DataSources.Add("danhsach", tb);
rptbangdiem.FilePath = Application.StartupPath + @"\Reports\bangdiem.rst";
rptbangdiem.Prepare();
rptbangdiem.GetReportParameter += GetParameter;
var previewForm = new PreviewForm(rptbangdiem)
{
WindowState = FormWindowState.Maximized
};
previewForm.Show();
}
else
{
MessageBox.Show(@"Sai mã sinh viên", @"Thông báo");
}
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
public ActionResult Update(string key, 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);
var lsttmp = Request["lstDetail"];
var lst = Request["lstCate"];
model.Category_Recipe.Clear();
if (!string.IsNullOrEmpty(lst))
{
model.Category_Recipe = _da.GetListArrIdCateRecipe(lst);
}
model.ProductDetail_Recipe.Clear();
if (!string.IsNullOrEmpty(lsttmp))
{
model.ProductDetail_Recipe = _da.GetListArrIdDetailRecipe(lsttmp);
}
_da.Save();
}
else
{
msg = new JsonMessage(true, "Có lỗi xảy ra!.");
}
}
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));
}
protected override void DeleteRow()
{
try
{
DeleteRowGrid(dgv_DanhSach, "ID", "TenPhong");
if (IdDelete.Count <= 0)
{
return;
}
foreach (var i in IdDelete)
{
var xp = new XepPhong
{
IdKyThi = _idkythi,
IdPhong = i
};
var ktp = new KTPhong
{
IdKyThi = _idkythi,
IdPhong = i
};
_listXepPhong.Add(xp);
_listKtPhong.Add(ktp);
}
DeleteData.XoaKtPhong(_listKtPhong);
UpdateData.UpdateXepPhongNull(_listXepPhong);
MessageBox.Show(FormResource.MsgThongbaothanhcong, FormResource.MsgCaption, MessageBoxButtons.OK,
MessageBoxIcon.Information);
LoadGrid();
IdDelete.Clear();
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
/// <summary>
/// Thống kê sinh viên theo điểm
/// </summary>
/// <returns></returns>
private static string GetstrThongke(IList <int> list)
{
var tb = new DataTable();
try
{
var str = new string[list.Count];
var strselect = "select ";
for (var i = 0; i < list.Count; i++)
{
str[i] = "(select MaSV, DiemThi from BAILAM where DiemThi is not null and IdKyThi = " + list[i] +
" ) a" + i;
}
var strtong = "(a0.DiemThi";
for (var i = 1; i < list.Count; i++)
{
strtong = strtong + "+ a" + i + ".DiemThi";
}
strselect = strselect + strtong + ") as [TongDiem] ";
var strjointable = str[0];
for (var i = 1; i < list.Count; i++)
{
strjointable = strjointable + " join " + str[i] + " on a" + (i - 1) + ".MaSV = a" + i + ".MaSV ";
}
var strend = strselect + " FROM " + strjointable;
return(strend);
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
return(null);
}
}
// á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 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);
}
}
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);
}
}
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 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));
}
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 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);
}
}
/// <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);
}
}
/// <summary>
/// Hàm lấy dữ liệu từ file excel
/// </summary>
public void Napdulieu()
{
try
{
var frmNapDuLieu = new FrmNDLSinhVien(GetTable(), 1);
frmNapDuLieu.ShowDialog();
var resultValue = frmNapDuLieu.ResultValue;
var tbsvError = _save.sp_checkData("sp_CheckSV", "@tbl", resultValue);
if (resultValue == null || resultValue.Rows.Count == 0)
{
return;
}
if (tbsvError.Rows.Count > 0)
{
var text = @"Thao tác không hoành thành vì có " + tbsvError.Rows.Count + @" sv đăng ký dự thi chưa có trong từ điển";
MessageBox.Show(text, FormResource.MsgCaption);
RptView("danhsachsinhvien", tbsvError);
}
else
{
var tbxp = _save.tbXepPhong();
foreach (DataRow row in resultValue.Rows)
{
tbxp.Rows.Add(row["MaSV"], _idkythi);
}
_save.sp_InsertUpdate("sp_InsertXepPhong", "@tbl", tbxp);
LoadGrid();
MessageBox.Show(tbxp.Rows.Count + @" Sinh viên đã được inport thành công.");
}
}
catch (Exception ex)
{
MessageBox.Show(@"Thao tác thất bại", FormResource.MsgCaption);
Log2File.LogExceptionToFile(ex);
}
}
public ActionResult Delete(string key, string listint)
{
var msg = new JsonMessage(false, "Xóa dữ liệu thành công.");
try
{
if (key == Keyapi)
{
var list = _da.GetListByArrId(listint);
foreach (var item in list)
{
item.IsDelete = 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));
}
public ActionResult UnLockAgency(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 = false;
}
_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 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));
}
/// <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));
}
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);
}
}
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 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));
}
