public IHttpActionResult Get(int id)
{
DTO_CUS_HRM_STAFF_NhanSu tbl_CUS_HRM_STAFF_NhanSu = BS_CUS_HRM_STAFF_NhanSu.get_CUS_HRM_STAFF_NhanSu(db, PartnerID, id, true);
if (tbl_CUS_HRM_STAFF_NhanSu == null)
{
return(NotFound());
}
return(Ok(tbl_CUS_HRM_STAFF_NhanSu));
}
public void AddListData(ExcelWorksheet ws)
{
var phuongTienList = BS_CUS_VANTAI_CONF_PhuongTien.get_CUS_VANTAI_CONF_PhuongTien(db, PartnerID, new Dictionary <string, string>());
var nhanSuList = BS_CUS_HRM_STAFF_NhanSu.get_CUS_HRM_STAFF_NhanSu(db, PartnerID, new Dictionary <string, string>());
Dictionary <string, string> queryStrings = new Dictionary <string, string>();
//queryStrings.Add("CodeTinhTrangLamViec", "\"PT1\", \"PT2\"");
var lenhLamViecList = BS_CUS_VANTAI_WO_LenhLamViec.get_CUS_VANTAI_WO_LenhLamViec(db, PartnerID, queryStrings, true);
//A.Xe
//B.Tài xế
//C.Phụ xe
//D.Nội dung làm việc
int rowid = 1;
foreach (var item in phuongTienList)
{
rowid++;
ws.Cells["A" + rowid].Value = item.Code + " [" + item.ID + "]";
}
rowid = 1;
foreach (var item in nhanSuList)
{
if (item.IDChucDanh == 5 || item.IDChucDanh == 8 || item.IDChucDanh == 10 || item.IDChucDanh == 12)
{
rowid++;
ws.Cells["B" + rowid].Value = item.TenDayDu + " [" + item.ID + "]";
}
}
rowid = 1;
foreach (var item in nhanSuList)
{
if (item.IDChucDanh == 6 || item.IDChucDanh == 9 || item.IDChucDanh == 11 || item.IDChucDanh == 14)
{
rowid++;
ws.Cells["C" + rowid].Value = item.TenDayDu + " [" + item.ID + "]";
}
}
rowid = 1;
foreach (var item in lenhLamViecList)
{
rowid++;
ws.Cells["D" + rowid].Value = item.Name + " [" + item.ID + "]";
}
}
public IHttpActionResult Post(DTO_CUS_HRM_STAFF_NhanSu tbl_CUS_HRM_STAFF_NhanSu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DTO_CUS_HRM_STAFF_NhanSu result = BS_CUS_HRM_STAFF_NhanSu.post_CUS_HRM_STAFF_NhanSu(db, PartnerID, tbl_CUS_HRM_STAFF_NhanSu, Username);
if (result != null)
{
return(CreatedAtRoute("get_CUS_HRM_STAFF_NhanSu", new { id = result.ID }, result));
}
return(Conflict());
}
public IHttpActionResult Put(int id, DTO_CUS_HRM_STAFF_NhanSu tbl_CUS_HRM_STAFF_NhanSu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_CUS_HRM_STAFF_NhanSu.ID || PartnerID != tbl_CUS_HRM_STAFF_NhanSu.IDPartner)
{
return(BadRequest());
}
string checkData = BS_CUS_HRM_STAFF_NhanSu.check_CUS_HRM_STAFF_NhanSu(db, id, tbl_CUS_HRM_STAFF_NhanSu);
if (!string.IsNullOrEmpty(checkData))
{
return(BadRequest(checkData));
}
bool isChangeCode = false;
string oldCode = "";
bool result = BS_CUS_HRM_STAFF_NhanSu.put_CUS_HRM_STAFF_NhanSu_Custom(db, PartnerID, id, tbl_CUS_HRM_STAFF_NhanSu, Username, out isChangeCode, out oldCode);
if (result)
{
BS_HelperReference.STAFF_Info_Update(db, id);
// Đổi code => đổi avt
if (isChangeCode)
{
string mapPath = System.Web.HttpContext.Current.Server.MapPath("~/");
string uploadPath = "Uploads/HRM/Staffs/Avatars/" + oldCode + ".jpg";
string strDirectoryPath = mapPath + uploadPath;
if (System.IO.File.Exists(strDirectoryPath))
{
string strFilePath = mapPath + "Uploads/HRM/Staffs/Avatars/" + tbl_CUS_HRM_STAFF_NhanSu.Code + ".jpg";
System.IO.File.Move(strDirectoryPath, strFilePath);
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(NotFound());
}
}
public IHttpActionResult Delete(int id)
{
bool check = BS_CUS_HRM_STAFF_NhanSu.check_CUS_HRM_STAFF_NhanSu_Exists(db, id);
if (!check)
{
return(NotFound());
}
bool result = BS_CUS_HRM_STAFF_NhanSu.delete_CUS_HRM_STAFF_NhanSu(db, id, Username);
if (result)
{
return(StatusCode(HttpStatusCode.NoContent));
}
return(Conflict());
}
public HttpResponseMessage Get_NhanSu()
{
string fileurl = "";
var package = GetTemplateWorkbook("DS-NhanSu.xlsx", "DS-NhanSu.xlsx", out fileurl);
ExcelWorkbook workBook = package.Workbook;
if (workBook != null)
{
var ws = workBook.Worksheets.FirstOrDefault(); //Worksheets["DS"];
var data = BS_CUS_HRM_STAFF_NhanSu.get_CUS_HRM_STAFF_NhanSu(db, PartnerID, QueryStrings);
int rowid = 3;
foreach (var item in data)
{
ws.Cells["B" + rowid].Value = item.Sort; //STT
ws.Cells["C" + rowid].Value = item.Code;
ws.Cells["D" + rowid].Value = item.TenDayDu;
if (item.IDChucDanh.HasValue)
{
var chucDanh = BS_CUS_HRM_LIST_ChucDanh.get_CUS_HRM_LIST_ChucDanh(db, PartnerID, item.IDChucDanh.Value);
if (chucDanh != null)
{
ws.Cells["E" + rowid].Value = chucDanh.Code;
ws.Cells["F" + rowid].Value = chucDanh.Name;
}
}
ws.Cells["G" + rowid].Value = item.SoXe;
ws.Cells["H" + rowid].Value = item.NgaySinh;
ws.Cells["I" + rowid].Value = item.NguyenQuan;
ws.Cells["J" + rowid].Value = item.ThuongTru;
ws.Cells["K" + rowid].Value = item.CMND;
ws.Cells["L" + rowid].Value = item.NgayCap;
ws.Cells["M" + rowid].Value = item.IsDisabled;
rowid++;
}
package.Save();
}
return(downloadFile(fileurl));
}
public HttpResponseMessage Get_NhanSu()
{
string fileurl = "";
var package = GetTemplateWorkbook("DS-NhanSu.xlsx", "DS-NhanSu.xlsx", out fileurl);
ExcelWorkbook workBook = package.Workbook;
if (workBook != null)
{
var ws = workBook.Worksheets.FirstOrDefault(); //Worksheets["DS"];
var data = BS_CUS_HRM_STAFF_NhanSu.get_CUS_HRM_STAFF_NhanSu(db, PartnerID, QueryStrings);
int rowid = 3;
foreach (var item in data)
{
ws.Cells["B" + rowid].Value = item.Sort; //STT
ws.Cells["C" + rowid].Value = item.Code;
ws.Cells["D" + rowid].Value = item.Name;
ws.Cells["E" + rowid].Value = item.SoDienThoai;
ws.Cells["F" + rowid].Value = item.Email;
ws.Cells["G" + rowid].Value = "";
//ws.Cells["H" + rowid].Value = item.IDRole;
if (item.IDRole.HasValue)
{
var ite = BS_CUS_SYS_Role.get_CUS_SYS_Role(db, PartnerID, item.IDRole.Value);
if (ite != null)
{
ws.Cells["H" + rowid].Value = ite.Code;
}
}
rowid++;
}
package.Save();
}
return(downloadFile(fileurl));
}
public IQueryable <DTO_CUS_HRM_STAFF_NhanSu> Get()
{
var result = BS_CUS_HRM_STAFF_NhanSu.get_CUS_HRM_STAFF_NhanSu(db, PartnerID, QueryStrings, false).ToList();
if (result != null)
{
var context = new ApplicationDbContext();
foreach (var item in result)
{
if (!string.IsNullOrEmpty(item.Email))
{
var ac = context.Users.FirstOrDefault(d => d.Email == item.Email);
if (ac != null)
{
item.IsCreatedAccount = true;
item.IsLockedOut = ac.LockoutEnabled;
item.IsHostAccount = ac.Roles.Any(d => d.RoleId == "HOST");
}
}
}
}
return(result.AsQueryable());
}
public HttpResponseMessage Post_NhanSu()
{
string fileurl = "";
var package = SaveImportedFile(out fileurl);
ExcelWorkbook workBook = package.Workbook;
if (workBook != null)
{
ExcelWorksheet ws = workBook.Worksheets.FirstOrDefault();
bool haveError = false;
int SheetColumnsCount, SheetRowCount = 0;
SheetColumnsCount = ws.Dimension.End.Column; // Find End Column
SheetRowCount = ws.Dimension.End.Row; // Find End Row
for (int rowid = 3; rowid <= SheetRowCount; rowid++)
{
#region item
List <string> row = new List <string>();
for (int i = 2; i <= SheetColumnsCount; i++)
{
row.Add(ws.Cells[rowid, i].Value == null ? "" : ws.Cells[rowid, i].Text);
}
if (row[1] == "") //check code null
{
continue;
}
string code = row[1];
var dbitem = BS_CUS_HRM_STAFF_NhanSu.get_CUS_HRM_STAFF_NhanSu(db, PartnerID, code);
if (dbitem == null)
{
dbitem = new DTO_CUS_HRM_STAFF_NhanSu();
}
if (int.TryParse(row[0], out int sort))
{
dbitem.Sort = sort;
}
dbitem.Code = row[1];
dbitem.TenDayDu = row[2];
if (!string.IsNullOrEmpty(row[3]))
{
var chucDanh = BS_CUS_HRM_LIST_ChucDanh.get_CUS_HRM_LIST_ChucDanh(db, PartnerID, row[3]);
if (chucDanh != null)
{
dbitem.IDChucDanh = chucDanh.ID;
}
else
{
}
}
dbitem.SoXe = row[5];
dbitem.NgaySinh = row[6];
dbitem.NguyenQuan = row[7];
dbitem.ThuongTru = row[8];
dbitem.CMND = row[9];
dbitem.NgayCap = row[10];
if (row[11] == "1")
{
dbitem.IsDisabled = true;
}
//STT Mã nhân viên Họ và tên Mã công việc Công việc 5 Xe Ngày sinh 7Nguyên quán Địa chỉ thường trú CMND Ngày cấp Đã nghỉ việc
try
{
if (dbitem.ID != 0)
{
BS_CUS_HRM_STAFF_NhanSu.put_CUS_HRM_STAFF_NhanSu(db, PartnerID, dbitem.ID, dbitem, Username);
}
else
{
BS_CUS_HRM_STAFF_NhanSu.post_CUS_HRM_STAFF_NhanSu(db, PartnerID, dbitem, Username);
}
}
catch (Exception ex)
{
continue;
}
#endregion
}
if (haveError)
{
package.Save();
return(downloadFile(fileurl, HttpStatusCode.Conflict));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
return(Request.CreateResponse(HttpStatusCode.Created));
}
public void AddRows(ExcelWorksheet ws)
{
var phuongTienList = BS_CUS_VANTAI_CONF_PhuongTien.get_CUS_VANTAI_CONF_PhuongTien(db, PartnerID, new Dictionary <string, string>()).ToList();
var lenhLamViecList = BS_CUS_VANTAI_WO_LenhLamViec.get_CUS_VANTAI_WO_LenhLamViec(db, PartnerID, new Dictionary <string, string>(), true);
var nhanSuList = BS_CUS_HRM_STAFF_NhanSu.get_CUS_HRM_STAFF_NhanSu(db, PartnerID, new Dictionary <string, string>());
int rowid = 1;
foreach (var lenhLamViec in lenhLamViecList)
{
var nhatKyLamViecList = db.tbl_CUS_VANTAI_WO_NhatKyLamViec.Where(d => d.IsDeleted == false && d.IDPartner == PartnerID && d.IDLenhLamViec == lenhLamViec.ID).ToList();
if (nhatKyLamViecList.Count() == 0 && lenhLamViec.NgayThucHien <= DateTime.Today && DateTime.Today <= lenhLamViec.NgayDuKienKetThuc && (lenhLamViec.IDTinhTrangLamViec == 2 || lenhLamViec.IDTinhTrangLamViec == 5))
{
var tempNhatKy = new tbl_CUS_VANTAI_WO_NhatKyLamViec()
{
IDLenhLamViec = lenhLamViec.ID, IDPhuongTien = lenhLamViec.IDPhuongTien
};
tempNhatKy.NgayThucHien = DateTime.Today;
if (lenhLamViec.TaiXe.HasValue)
{
tempNhatKy.TaiXe = lenhLamViec.TaiXe.Value;
}
if (lenhLamViec.PhuXe.HasValue)
{
tempNhatKy.PhuXe = lenhLamViec.PhuXe.Value;
}
nhatKyLamViecList.Add(tempNhatKy);
}
foreach (var item in nhatKyLamViecList)
{
rowid++;
//ws.Cells["A" + rowid].Value = item.ID;
ws.Cells["B" + rowid].Value = item.NgayThucHien.ToOADate();
var phuongtien = phuongTienList.FirstOrDefault(d => d.ID == item.IDPhuongTien);
if (phuongtien != null)
{
ws.Cells["C" + rowid].Value = phuongtien.Code + " [" + phuongtien.ID + "]";
}
ws.Cells["D" + rowid].Value = lenhLamViec.Name + " [" + lenhLamViec.ID + "]";
var taixe = BS_CUS_HRM_STAFF_NhanSu.get_CUS_HRM_STAFF_NhanSu(db, PartnerID, item.TaiXe);
if (taixe != null)
{
ws.Cells["E" + rowid].Value = taixe.TenDayDu + " [" + taixe.ID + "]";
}
var phuxe = BS_CUS_HRM_STAFF_NhanSu.get_CUS_HRM_STAFF_NhanSu(db, PartnerID, item.PhuXe.GetValueOrDefault());
if (phuxe != null)
{
ws.Cells["F" + rowid].Value = phuxe.TenDayDu + " [" + phuxe.ID + "]";
}
if (!string.IsNullOrEmpty(item.SangBatDau))
{
ws.Cells["G" + rowid].Value = TimeSpan.Parse(item.SangBatDau).TotalDays;
}
if (!string.IsNullOrEmpty(item.SangKetThuc))
{
ws.Cells["H" + rowid].Value = TimeSpan.Parse(item.SangKetThuc).TotalDays;
}
if (!string.IsNullOrEmpty(item.TruaBatDau))
{
ws.Cells["I" + rowid].Value = TimeSpan.Parse(item.TruaBatDau).TotalDays;
}
if (!string.IsNullOrEmpty(item.TruaKetThuc))
{
ws.Cells["J" + rowid].Value = TimeSpan.Parse(item.TruaKetThuc).TotalDays;
}
if (!string.IsNullOrEmpty(item.ChieuBatDau))
{
ws.Cells["K" + rowid].Value = TimeSpan.Parse(item.ChieuBatDau).TotalDays;
}
if (!string.IsNullOrEmpty(item.ChieuKetThuc))
{
ws.Cells["L" + rowid].Value = TimeSpan.Parse(item.ChieuKetThuc).TotalDays;
}
if (!string.IsNullOrEmpty(item.ToiBatDau))
{
ws.Cells["M" + rowid].Value = TimeSpan.Parse(item.ToiBatDau).TotalDays;
}
if (!string.IsNullOrEmpty(item.ToiKetThuc))
{
ws.Cells["N" + rowid].Value = TimeSpan.Parse(item.ToiKetThuc).TotalDays;
}
ws.Cells["O" + rowid].Formula = string.Format("N{0}-M{0}+L{0}-K{0}+J{0}-I{0}+H{0}-G{0}", rowid);
ws.Cells["P" + rowid].Value = item.GiamSatThiCong;
ws.Cells["Q" + rowid].Value = item.GiamSatThiCongXacNhan ? "ok" : "";
ws.Cells["R" + rowid].Value = item.GiamSatThiCongNhanXet;
ws.Cells["S" + rowid].Value = item.ChiHuyTruong;
ws.Cells["T" + rowid].Value = item.ChiHuyTruongXacNhan ? "ok" : "";
ws.Cells["U" + rowid].Value = item.ChiHuyTruongNhanXet;
}
}
}
public async Task <HttpResponseMessage> Post_NhanSu()
{
string fileurl = "";
var package = SaveImportedFile(out fileurl);
ExcelWorkbook workBook = package.Workbook;
if (workBook != null)
{
ExcelWorksheet ws = workBook.Worksheets.FirstOrDefault();
bool haveError = false;
int SheetColumnsCount, SheetRowCount = 0;
SheetColumnsCount = ws.Dimension.End.Column; // Find End Column
SheetRowCount = ws.Dimension.End.Row; // Find End Row
for (int rowid = 3; rowid <= SheetRowCount; rowid++)
{
#region item
List <string> row = new List <string>();
for (int i = 2; i <= SheetColumnsCount; i++)
{
row.Add(ws.Cells[rowid, i].Value == null ? "" : ws.Cells[rowid, i].Text);
}
if (string.IsNullOrEmpty(row[1]) || string.IsNullOrEmpty(row[2]) || string.IsNullOrEmpty(row[4]) || string.IsNullOrEmpty(row[6])) //check validate
{
continue;
}
string code = row[1];
var dbitem = BS_CUS_HRM_STAFF_NhanSu.get_CUS_HRM_STAFF_NhanSu(db, PartnerID, code);
if (dbitem == null)
{
dbitem = new DTO_CUS_HRM_STAFF_NhanSu();
}
if (int.TryParse(row[0], out int sort))
{
dbitem.Sort = sort;
}
dbitem.Code = row[1];
dbitem.Name = row[2];
dbitem.SoDienThoai = row[3];
dbitem.Email = row[4].ToLower();
string password = row[5];
//update role
if (!string.IsNullOrEmpty(row[6]))
{
var r = BS_CUS_SYS_Role.get_CUS_SYS_Role(db, PartnerID, row[6]);
if (r != null)
{
dbitem.IDRole = r.ID;
}
else
{
continue;
}
}
try
{
if (dbitem.ID != 0)
{
BS_CUS_HRM_STAFF_NhanSu.put_CUS_HRM_STAFF_NhanSu(db, PartnerID, dbitem.ID, dbitem, Username);
}
else
{
BS_CUS_HRM_STAFF_NhanSu.post_CUS_HRM_STAFF_NhanSu(db, PartnerID, dbitem, Username);
}
//create/update account
var context = new ApplicationDbContext();
var dbUser = context.Users.FirstOrDefault(d => d.Email == dbitem.Email);
bool isCreate = false;
if (dbUser == null && !string.IsNullOrEmpty(password))
{
isCreate = true;
dbUser = new ApplicationUser();
dbUser.UserName = dbUser.Email = dbitem.Email;
dbUser.CreatedDate = DateTime.UtcNow;
dbUser.CreatedBy = Username;
IdentityResult result = await UserManager.CreateAsync(dbUser, password);
}
if (dbUser != null)
{
dbUser.FullName = dbitem.Name;
dbUser.Avatar = string.Format("Uploads/HRM/Staffs/Avatars/{0}.jpg", dbitem.Code);
dbUser.PhoneNumber = dbitem.SoDienThoai;
dbUser.StaffID = dbitem.ID;
dbUser.PartnerID = dbitem.IDPartner;
context.SaveChanges();
}
//mail
if (isCreate)
{
string template =
@"
Xin chào <strong>@Model.FullName</strong>,
<br>
<br>Bạn vừa được tạo tài khoản truy cập vào hệ thống Quản lý Đề tài Nghiên cứu khoa học.
<br>
<br>Tài khoản đăng nhập:
<br>Email: <strong>@Model.Email</strong>
<br>Mật khẩu: <strong>@Model.Password</strong>
<br>
<br>Vui lòng đăng nhập tại
<br><a href='@Model.Domain'>@Model.Domain</a>
<br>";
var html = Engine.Razor.RunCompile(template, "Register_EmailTemplate", null, new { FullName = dbUser.FullName, Email = dbUser.Email, Password = password, Domain = "http://myduc.appcenter.vn:9003/" });
EmailService emailService = new EmailService();
//emailService.SendSync(new IdentityMessage() { Subject = "Quản lý Đề tài Nghiên cứu khoa học - thông tin tài khoản", Destination = dbUser.Email, Body = html });
}
else if (!string.IsNullOrEmpty(password))
{
UserManager.RemovePassword(dbUser.Id);
IdentityResult result = await UserManager.AddPasswordAsync(dbUser.Id, password);
}
}
catch (Exception ex)
{
log.Error("Import/Post_NhanSu", ex);
continue;
}
#endregion
}
if (haveError)
{
package.Save();
return(downloadFile(fileurl, HttpStatusCode.Conflict));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
return(Request.CreateResponse(HttpStatusCode.Created));
}
public IQueryable <DTO_CUS_HRM_STAFF_NhanSu> GetNhanSuChuNhiem()
{
var result = BS_CUS_HRM_STAFF_NhanSu.get_CUS_HRM_STAFF_NhanSu(db, PartnerID, QueryStrings, true).ToList();
return(result.AsQueryable());
}
