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(); }