public async Task <ActionResult <BangLuong> > PostBangLuong(BangLuong bangLuong)
{
_context.BangLuong.Add(bangLuong);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetBangLuong", new { id = bangLuong.IdbangLuong }, bangLuong));
}
public async Task <IActionResult> PutBangLuong(int id, BangLuong bangLuong)
{
if (id != bangLuong.IdbangLuong)
{
return(BadRequest());
}
_context.Entry(bangLuong).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BangLuongExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IActionResult ThemNhanVienData(NhanVienView nhanvienView)//thêm đối tượng xuống database
{
ViewBag.Error = "1";
if (ModelState.IsValid)
{
using (var db = new CoffeeShopDbContext())
{
var luong = new BangLuong
{
MaNV = nhanvienView.nhanvienDTO.MaNV.ToString(),
TienThuong = 0,
TamUng = 0,
Luong = 0
};
db.bangluong.Add(luong);
db.SaveChanges();
}
_nhanvienServices.themNhanVien(nhanvienView.nhanvienDTO);
ViewBag.Success = "Đã thêm thành công";
//return Redirect(nameof(ThemNhanVien));
return(RedirectToAction("Index", "NhanVien"));
}
ViewBag.Error = "0";
return(View(nameof(ThemNhanVien)));
}
public ActionResult TaoMoi()
{
int a = 0;
foreach (var item in db.BangLuongs.ToList())
{
var _thang = item.Thang.Date.ToString("MM/yyyy");
if (_thang == DateTime.Today.ToString("MM/yyyy"))
{
a = 1;
//ViewData["Thongbao_cc"] = "Danh sách chấm công hôm nay đã được tạo";
break;
}
}
if (a == 0)
{
foreach (var item in db.NhanViens.ToList())
{
BangLuong b = new BangLuong();
b.MaNhanVien = item.MaNhanVien;
b.Thang = DateTime.Today;
db.BangLuongs.Add(b);
}
db.SaveChanges();
return(RedirectToAction("BangLuong"));
}
return(RedirectToAction("BangLuong"));
}
public async Task <BangLuong> Update(BangLuong entity)
{
return(await WithConnection(async c =>
{
BangLuong obj = await c.GetAsync(entity);
if (obj == null)
{
throw new Exception(string.Format("Update id {0} not exist", entity.BangLuongId.ToString()));
}
if (obj.CtrVersion != entity.CtrVersion)
{
throw new Exception(string.Format("Update id {0} have version confict"
, entity.BangLuongId.ToString()));
}
entity.CtrVersion += 1;
var result = await c.UpdateAsync(entity);
if (result != true)
{
throw new Exception("Update Fail");
}
return entity;
}));
}
public bool ThemBangLuong(BangLuong bl)
{
string[] param = { "@Thang", "@MaNV", "@TenNV", "@TongGioLam", "@MucLuong", "@TienLuong" };
object[] values = { bl.Thang, bl.MaNV, bl.TenNV, bl.TongGioLam, bl.MucLuong, bl.TienLuong };
string query = "Insert into tblBangLuong(Thang,MaNV,TenNV,TongGioLam,MucLuong,TienLuong) values(@Thang,@MaNV,@TenNV,@TongGioLam,@MucLuong,@TienLuong)";
return(db.ExecuteNonQueryPara(query, param, values));
}
public bool SuaBangLuong(BangLuong bl)
{
string[] param = { "@Thang", "@MaNV", "@TongGioLam", "@TienLuong" };
object[] values = { bl.Thang, bl.MaNV, bl.TongGioLam, bl.TienLuong };
string query = "Update tblBangLuong set TongGioLam=@TongGioLam,TienLuong=@TienLuong where Thang=@Thang and MaNV=@MaNV";
return(db.ExecuteNonQueryPara(query, param, values));
}
public ActionResult DeleteConfirmed(string id)
{
BangLuong bangLuong = db.BangLuongs.Find(id);
db.BangLuongs.Remove(bangLuong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult TinhLuong(BangLuong b, int id, double luongcoban)
{
//var nhanvien = db.BangLuongs.Where(m => m.IDBangLuong == id).FirstOrDefault();
//var _nhanvien = db.NhanViens.Where(m => m.MaNhanVien == nhanvien.MaNhanVien).FirstOrDefault();
b.TongLuong = (luongcoban + b.LuongThuong - b.LuongTru) * b.SoNgayLam / 22;
db.Entry(b).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("BangLuong"));
}
public static BangLuongDTO MappingBangLuongDTO(this BangLuong bangluong)//Tên biết viết đầu là chữ thường để phân biệt với kiểu dữ liệu
{
return(new BangLuongDTO
{
MaNV = bangluong.MaNV,
TienThuong = bangluong.TienThuong,
TamUng = bangluong.TamUng,
Luong = bangluong.Luong
});
}
public ActionResult Edit([Bind(Include = "TenNV,Luong,Phucap")] BangLuong bangLuong)
{
if (ModelState.IsValid)
{
db.Entry(bangLuong).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bangLuong));
}
public ActionResult Create([Bind(Include = "TenNV,Luong,Phucap")] BangLuong bangLuong)
{
if (ModelState.IsValid)
{
db.BangLuongs.Add(bangLuong);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bangLuong));
}
// GET: BangLuong/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BangLuong bangLuong = db.BangLuongs.Find(id);
if (bangLuong == null)
{
return(HttpNotFound());
}
return(View(bangLuong));
}
public async Task <BangLuong> Insert(BangLuong entity)
{
return(await WithConnection(async c =>
{
await c.InsertAsync(entity);
if (entity.BangLuongId == 0)
{
throw new Exception("Insert Fail");
}
return entity;
}));
}
public void them(BANGLUONG f)
{
BangLuong bl = new BangLuong();
bl.MaTinhLuong = f.cbb_matinhluong.Text;
bl.HeSoLuong = f.txt_hesoluong.Text;
bl.LuongCoBan_Ngay = f.txt_luongcoban.Text;
bl.Thuong = f.txt_thuong.Text;
bl.TamUng = f.txt_tamung.Text;
bl.NgayTao = Convert.ToDateTime(f.dt_ngaytao.Text);
bl.IsDelete = 1;
data.database().BangLuongs.InsertOnSubmit(bl);
data.database().SubmitChanges();
DialogResult thongbao = MessageBox.Show("Thêm thành công", "Thông Báo", MessageBoxButtons.OK);
if (thongbao == DialogResult.OK)
{
loaddulieu(f);
}
}
public async Task <BangLuong> UpdatePartial(BangLuong entity, params string[] field)
{
return(await WithConnection(async c =>
{
BangLuong obj = await c.GetAsync(entity);
if (obj == null)
{
throw new Exception(string.Format("Update id {0} not exist", entity.BangLuongId.ToString()));
}
if (obj.CtrVersion != entity.CtrVersion)
{
throw new Exception(string.Format("Update id {0} have version confict"
, entity.BangLuongId.ToString()));
}
entity.CtrVersion += 1;
var list = field.ToList();
list.Add(nameof(BangLuong.CtrVersion));
var partialUpdateMapping = OrmConfiguration
.GetDefaultEntityMapping <BangLuong>()
.Clone() // clone it if you don't want to modify the default
.UpdatePropertiesExcluding(prop => prop.IsExcludedFromUpdates = true,
list.ToArray());
var result = await c.UpdateAsync(entity, statement => statement.WithEntityMappingOverride(partialUpdateMapping));
if (result != true)
{
throw new Exception("Update Fail");
}
return entity;
}));
}
private void btnDangNhap_Click(object sender, EventArgs e)
{
try
{
if (spinSoTien.Value <= 0)
{
XtraMessageBox.Show("Bạn chưa nhập [Số tiền ứng].", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var objTU = new BangLuong();
objTU.GhiChu = txtHangNhap.Text;
objTU.NgayLuong = dateNgayNhap.DateTime;
objTU.NVID = ID;
objTU.SoTien = spinSoTien.Value;
db.BangLuongs.InsertOnSubmit(objTU);
db.SubmitChanges();
XtraMessageBox.Show("Hoàn thành.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception)
{
throw;
}
}
public void SuaBangLuong(BangLuong bangluong)
{
_conText.bangluong.Update(bangluong);
_conText.SaveChanges();
}
public bool SuaBangLuong(BangLuong bl)
{
return(dalbl.SuaBangLuong(bl));
}
public bool ThemBangLuong(BangLuong bl)
{
return(dalbl.ThemBangLuong(bl));
}
public void ThemBangLuong(BangLuong bangluong)
{
_conText.bangluong.Add(bangluong);
_conText.SaveChanges();
}
