Пример #1
0
        // GET: api/Api_BangLuong
        public List <Bangluong> GetCCTC_BANG_LUONG(string id)
        {
            List <Bangluong> listbangluong = new List <Bangluong>();
            var vData = db.CCTC_BANG_LUONG.Where(x => x.USERNAME == id);

            foreach (var item in vData)
            {
                Bangluong bl = new Bangluong();
                bl.THANG_LUONG                          = item.THANG_LUONG;
                bl.USERNAME                             = item.USERNAME;
                bl.LUONG_CO_BAN                         = string.Format("{0:#,##0.##}", item.LUONG_CO_BAN);
                bl.LUONG_BAO_HIEM                       = String.Format("{0:#,##0.##}", item.LUONG_BAO_HIEM);
                bl.PHU_CAP_AN_TRUA                      = String.Format("{0:#,##0.##}", item.PHU_CAP_AN_TRUA);
                bl.PHU_CAP_DI_LAI_DIEN_THOAI            = String.Format("{0:#,##0.##}", item.PHU_CAP_DI_LAI_DIEN_THOAI);
                bl.PHU_CAP_THUONG_DOANH_SO              = String.Format("{0:#,##0.##}", item.PHU_CAP_THUONG_DOANH_SO);
                bl.PHU_CAP_TRACH_NHIEM                  = String.Format("{0:#,##0.##}", item.PHU_CAP_TRACH_NHIEM);
                bl.CONG_CO_BAN                          = String.Format("{0:#,##0.##}", item.CONG_CO_BAN);
                bl.LUONG_CO_BAN_NGAY                    = String.Format("{0:#,##0.##}", item.CONG_CO_BAN);
                bl.LUONG_CO_BAN_GIO                     = String.Format("{0:#,##0.##}", item.LUONG_CO_BAN_GIO);
                bl.BAO_HIEM_CONG_TY_DONG                = String.Format("{0:#,##0.##}", item.BAO_HIEM_CONG_TY_DONG);
                bl.BAO_HIEM_NHAN_VIEN_DONG              = String.Format("{0:#,##0.##}", item.BAO_HIEM_NHAN_VIEN_DONG);
                bl.LUONG_THUC_TE_CONG_LAM_THUC          = String.Format("{0:#,##0.##}", item.LUONG_THUC_TE_CONG_LAM_THUC);
                bl.LUONG_THUC_TE_SO_TIEN                = String.Format("{0:#,##0.##}", item.LUONG_THUC_TE_SO_TIEN);
                bl.LUONG_LAM_THEM_CONG_NGAY_THUONG      = String.Format("{0:#,##0.##}", item.LUONG_LAM_THEM_CONG_NGAY_THUONG);
                bl.LUONG_LAM_THEM_TIEN_CONG_NGAY_THUONG = String.Format("{0:#,##0.##}", item.LUONG_LAM_THEM_TIEN_CONG_NGAY_THUONG);
                bl.LUONG_LAM_THEM_CONG_NGAY_NGHI        = String.Format("{0:#,##0.##}", item.LUONG_LAM_THEM_CONG_NGAY_NGHI);
                bl.LUONG_LAM_THEM_TIEN_CONG_NGAY_NGHI   = String.Format("{0:#,##0.##}", item.LUONG_LAM_THEM_TIEN_CONG_NGAY_NGHI);
                bl.LUONG_LAM_THEM_CONG_NGAY_LE          = String.Format("{0:#,##0.##}", item.LUONG_LAM_THEM_CONG_NGAY_LE);
                bl.LUONG_LAM_THEM_TIEN_CONG_NGAY_LE     = String.Format("{0:#,##0.##}", item.LUONG_LAM_THEM_TIEN_CONG_NGAY_LE);
                bl.TONG_THU_NHAP                        = String.Format("{0:#,##0.##}", item.TONG_THU_NHAP);
                bl.TAM_UNG             = String.Format("{0:#,##0.##}", item.TAM_UNG);
                bl.VAY_TIN_DUNG        = String.Format("{0:#,##0.##}", item.VAY_TIN_DUNG);
                bl.GIO_DI_TRE          = String.Format("{0:N2}", item.GIO_DI_TRE);
                bl.PHAT_DI_TRE         = String.Format("{0:#,##0.##}", item.PHAT_DI_TRE);
                bl.PHAT_QUEN_DONG_PHUC = String.Format("{0:#,##0.##}", item.PHAT_QUEN_DONG_PHUC);
                bl.PHU_CAP_THEM        = String.Format("{0:#,##0.##}", item.PHU_CAP_THEM);
                bl.CONG_DOAN           = String.Format("{0:#,##0.##}", item.CONG_DOAN);
                bl.LUONG_LAO_CONG      = String.Format("{0:#,##0.##}", item.LUONG_LAO_CONG);

                bl.THUC_LINH = String.Format("{0:#,##0.##}", item.THUC_LINH);
                listbangluong.Add(bl);
            }
            var result = listbangluong.ToList();

            return(result);
        }
Пример #2
0
        public async Task <ActionResult <Bangluong> > addBangluong(Bangluong bl)
        {
            var bangluong = await context.Bangluong.FindAsync(bl.bacluong);

            if (bangluong != null)
            {
                return(Ok(new { Status = false, Message = "Ma bac luong da ton tai" }));
            }
            if (ModelState.IsValid)
            {
                try
                {
                    context.Add(bl);
                    await context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    return(Ok(new { Status = false, Message = "Erro" }));
                }
            }
            return(CreatedAtAction("", new { Status = true, Message = "Success", Bangluong = bl }));
        }