public IHttpActionResult Get(int id) { DTO_CUS_HRM_LIST_ChucDanh tbl_CUS_HRM_LIST_ChucDanh = BS_CUS_HRM_LIST_ChucDanh.get_CUS_HRM_LIST_ChucDanh(db, PartnerID, id); if (tbl_CUS_HRM_LIST_ChucDanh == null) { return(NotFound()); } return(Ok(tbl_CUS_HRM_LIST_ChucDanh)); }
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 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 IQueryable <DTO_CUS_HRM_LIST_ChucDanh> Get() { return(BS_CUS_HRM_LIST_ChucDanh.get_CUS_HRM_LIST_ChucDanh(db, PartnerID, QueryStrings)); }