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 IHttpActionResult Post(DTO_CUS_HRM_LIST_ChucDanh tbl_CUS_HRM_LIST_ChucDanh)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DTO_CUS_HRM_LIST_ChucDanh result = BS_CUS_HRM_LIST_ChucDanh.post_CUS_HRM_LIST_ChucDanh(db, PartnerID, tbl_CUS_HRM_LIST_ChucDanh, Username);
if (result != null)
{
return(CreatedAtRoute("get_CUS_HRM_LIST_ChucDanh", new { id = result.ID }, result));
}
return(Conflict());
}
public IHttpActionResult Delete(int id)
{
bool check = BS_CUS_HRM_LIST_ChucDanh.check_CUS_HRM_LIST_ChucDanh_Exists(db, id);
if (!check)
{
return(NotFound());
}
bool result = BS_CUS_HRM_LIST_ChucDanh.delete_CUS_HRM_LIST_ChucDanh(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 IHttpActionResult Put(int id, DTO_CUS_HRM_LIST_ChucDanh tbl_CUS_HRM_LIST_ChucDanh)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_CUS_HRM_LIST_ChucDanh.ID || PartnerID != tbl_CUS_HRM_LIST_ChucDanh.IDPartner)
{
return(BadRequest());
}
bool resul = BS_CUS_HRM_LIST_ChucDanh.put_CUS_HRM_LIST_ChucDanh(db, PartnerID, id, tbl_CUS_HRM_LIST_ChucDanh, Username);
if (resul)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(NotFound());
}
}
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));
}
