public IHttpActionResult PutYeuCau(int id, YeuCau yeuCau)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != yeuCau.YeuCauID)
{
return(BadRequest());
}
db.Entry(yeuCau).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!YeuCauExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IActionResult> PutYeuCau([FromRoute] int id, [FromBody] YeuCau yeucau)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != yeucau.YeuCauId)
{
return(BadRequest());
}
_context.Entry(yeucau).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!YeuCauExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult Create([Bind(Include = "MaYC_ID,MaNhaSi,MaKH,NgayYC,TongTien")] YeuCau yeuCau)
{
int num = db.YeuCauTB.Count();
yeuCau.MaYC_ID = "yc" + num.ToString();
yeuCau.NgayYC = DateTime.Now;
if (ModelState.IsValid)
{
db.YeuCauTB.Add(yeuCau);
int co = 0;
while (co == 0)
{
try
{
db.SaveChanges();
co = 1;
}
catch (System.Data.Entity.Infrastructure.DbUpdateException ex)
{
num += 1;
yeuCau.MaYC_ID = "yc" + num.ToString();
}
}
return(Redirect("../ChiTietYeuCau_DichVu/create"));
}
ViewBag.MaKH = new SelectList(db.KhachHangTB, "MaKH_ID", "MaKH_ID", yeuCau.MaKH);
ViewBag.MaNhaSi = new SelectList(db.NhanVienTB, "MaNV_ID", "MaNV_ID", yeuCau.MaNhaSi);
return(View(yeuCau));
}
public IEnumerable <YeuCau> GetItems([FromRoute] int start, int count, string orderBy, [FromBody] string whereClause)
{
List <YeuCau> yc = new List <YeuCau>();
orderBy = orderBy != "x" ? orderBy : "";
var lyc = _context.Set <YeuCau>().FromSql($"tbl_YeuCau_GetItemsByRange {start},{count},{whereClause},{orderBy}").ToList <YeuCau>();
for (int i = 0; i < lyc.Count; i++)
{
YeuCau obj = new YeuCau();
obj = lyc[i];
if (lyc[i].MatBangId != 0)
{
obj.MatBang = _context.MatBangs.SingleOrDefault(m => m.MatBangId == lyc[i].MatBangId);
}
if (lyc[i].CuDanId != 0)
{
obj.CuDan = _context.CuDans.SingleOrDefault(m => m.CuDanId == lyc[i].CuDanId);
}
obj.MucDoUuTien = _context.MucDoUuTiens.SingleOrDefault(m => m.MucDoUuTienId == lyc[i].MucDoUuTienId);
obj.PhongBan = _context.PhongBans.SingleOrDefault(m => m.PhongBanId == lyc[i].PhongBanId);
obj.TrangThaiYeuCau = _context.TrangThaiYeuCaus.SingleOrDefault(m => m.TrangThaiYeuCauId == lyc[i].TrangThaiYeuCauId);
obj.LoaiYeuCau = _context.LoaiYeuCaus.SingleOrDefault(m => m.LoaiYeuCauId == lyc[i].LoaiYeuCauId);
obj.NguonTiepNhan = _context.NguonTiepNhans.SingleOrDefault(m => m.NguonTiepNhanId == lyc[i].NguonTiepNhanId);
yc.Add(obj);
}
return(lyc);
}
public ActionResult DeleteConfirmed(string id)
{
YeuCau yeuCau = db.YeuCauTB.Find(id);
db.YeuCauTB.Remove(yeuCau);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void button1_Click(object sender, EventArgs e)
{
int rowId = gridYeuCau.SelectedCells[0].RowIndex;
int id = int.Parse(gridYeuCau.Rows[rowId].Cells[0].Value.ToString());
YeuCau yeuCau = db.YeuCau.SingleOrDefault(x => x.YeuCauID == id);
FormChonCa chonCa = new FormChonCa(yeuCau);
chonCa.Show();
}
public IHttpActionResult GetYeuCau(int id)
{
YeuCau yeuCau = db.YeuCaus.Find(id);
if (yeuCau == null)
{
return(NotFound());
}
return(Ok(yeuCau));
}
public IHttpActionResult PostYeuCau(YeuCau yeuCau)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.YeuCaus.Add(yeuCau);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = yeuCau.YeuCauID }, yeuCau));
}
public async Task <IActionResult> PostYeuCau([FromBody] YeuCau yeucau)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.YeuCaus.Add(yeucau);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetYeuCau", new { id = yeucau.YeuCauId }, yeucau));
}
public void DeleteYeuCau(YeuCau yeuCau)
{
YeuCau YeuCau = db.YeuCau.SingleOrDefault(x => x.YeuCauID == yeuCau.YeuCauID);
if (yeuCau == null)
{
}
else
{
db.YeuCau.Remove(yeuCau);
}
}
public ActionResult Edit([Bind(Include = "MaYC_ID,MaNhaSi,MaKH,NgayYC,TongTien")] YeuCau yeuCau)
{
if (ModelState.IsValid)
{
db.Entry(yeuCau).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.KhachHangTB, "MaKH_ID", "MaKH_ID", yeuCau.MaKH);
ViewBag.MaNhaSi = new SelectList(db.NhanVienTB, "MaNV_ID", "MaNV_ID", yeuCau.MaNhaSi);
return(View(yeuCau));
}
public static YeuCauDTO FromEntity(YeuCau item)
{
return(new YeuCauDTO()
{
Id = item.Id,
TenYeuCau = item.TenYeuCau,
GiaTriSoTu = item.GiaTriSoTu,
GiaTriSoDen = item.GiaTriSoDen,
GiaTriNoiDung = item.GiaTriNoiDung,
BaiTuyenDung = item.BaiTuyenDung != null?BaiTuyenDungDTO.FromEntity(item.BaiTuyenDung) : null,
LoaiYeuCau = item.LoaiYeuCau != null?LoaiYeuCauDTO.FromEntity(item.LoaiYeuCau) : null,
});
}
public void UpdateYeuCau(YeuCau yeuCau)
{
YeuCau YeuCau = db.YeuCau.SingleOrDefault(x => x.YeuCauID == yeuCau.YeuCauID);
if (yeuCau == null)
{
}
else
{
YeuCau.NgayTruc = yeuCau.NgayTruc;
YeuCau.SoLuongCa = yeuCau.SoLuongCa;
YeuCau.IDAdmin = yeuCau.IDAdmin;
}
}
public IHttpActionResult DeleteYeuCau(int id)
{
YeuCau yeuCau = db.YeuCaus.Find(id);
if (yeuCau == null)
{
return(NotFound());
}
db.YeuCaus.Remove(yeuCau);
db.SaveChanges();
return(Ok(yeuCau));
}
// GET: YeuCau/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
YeuCau yeuCau = db.YeuCauTB.Find(id);
if (yeuCau == null)
{
return(HttpNotFound());
}
return(View(yeuCau));
}
public FormChonCa(YeuCau yeuCau)
{
yeuCauEdit = yeuCau;
InitializeComponent();
List <CaTruc> lstCaTruc = yeuCau.CaTruc.ToList();
if (lstCaTruc.Count != 0)
{
cbxChonCa.DataSource = lstCaTruc;
cbxChonCa.DisplayMember = "TenCa";
cbxChonCa.ValueMember = "CaTrucID";
}
Thread.CurrentThread.CurrentUICulture = new CultureInfo("vi-VN");
}
// GET: YeuCau/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
YeuCau yeuCau = db.YeuCauTB.Find(id);
if (yeuCau == null)
{
return(HttpNotFound());
}
ViewBag.MaKH = new SelectList(db.KhachHangTB, "MaKH_ID", "MaKH_ID", yeuCau.MaKH);
ViewBag.MaNhaSi = new SelectList(db.NhanVienTB, "MaNV_ID", "MaNV_ID", yeuCau.MaNhaSi);
return(View(yeuCau));
}
public void PostYeuCau(YeuCau yeuCau)
{
if (yeuCau == null)
{
}
else
{
List <CaTruc> lstCaTruc = yeuCau.CaTruc.ToList();
yeuCau.CaTruc = null;
db.YeuCau.Add(yeuCau);
foreach (CaTruc caTruc in lstCaTruc)
{
caTruc.YeuCauID = yeuCau.YeuCauID;
db.CaTruc.Add(caTruc);
}
db.SaveChanges();
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Ban Co Chac Muon Xoa Khong?", "Mesage", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int rowId = gridYeuCau.SelectedCells[0].RowIndex;
int id = int.Parse(gridYeuCau.Rows[rowId].Cells[0].Value.ToString());
YeuCau yeuCau = db.YeuCau.SingleOrDefault(x => x.YeuCauID == id);
db.YeuCau.Remove(yeuCau);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
yeuCauBindingSource.DataSource = db.YeuCau.ToList();
}
}
public async Task <int> Create(YeuCauCreateRequest request)
{
var yeuCau = new YeuCau()
{
MaLoai = request.MaLoai,
MaTrangThai = request.MaTrangThai,
MaMucDo = request.MaMucDo,
MaNV = request.MaNV,
MaKH = request.MaKH,
NgayTiepNhan = DateTime.Now,
Noidung = request.Noidung,
DiaDiem = request.DiaDiem,
MoTa = request.MoTa
};
_context.YeuCaus.Add(yeuCau);
await _context.SaveChangesAsync();
return(request.MaYeuCau);
}
private void _Show_Control(YeuCau yc)
{
// Disable all control
dateEditTu.Enabled = false;
dateEditDen.Enabled = false;
simpleButtonLayHSo.Enabled = false;
checkEditChuyenBangDiem.Enabled = false;
textEditLyDoChuyen.Enabled = false;
groupControlLopCu.Enabled = true;
simpleButtonXoaPL.Enabled = true;
simpleButtonChuyenTatCa.Enabled = true;
//hiển thị control bị ẩn khi gặp lỗi
if (gridControlDSHocSinh.Enabled == false)
{
groupControlLopCu.Enabled = true;
groupControlLopMoi.Enabled = true;
gridControlDSHocSinh.Enabled = true;
gridControlDSHocSinhMoi.Enabled = true;
}
// Show control
if (yc == YeuCau.PhanLopHoSoChuaPhanLop)
{
dateEditTu.Enabled = true;
dateEditDen.Enabled = true;
simpleButtonLayHSo.Enabled = true;
groupControlLopCu.Enabled = false;
}
else if (yc == YeuCau.PhanLopHoSoNamCu)
{
}
else if (yc == YeuCau.ChuyenLopCungKhoi)
{
checkEditChuyenBangDiem.Enabled = true;
textEditLyDoChuyen.Enabled = true;
simpleButtonXoaPL.Enabled = false;
simpleButtonChuyenTatCa.Enabled = false;
}
}
private void BtnTaoCa_Click(object sender, EventArgs e)
{
YeuCau addYeuCau = new YeuCau();
addYeuCau.SoLuongCa = int.Parse(txtSoLuongCa.Text.ToString());
addYeuCau.SoLuongNguoi = int.Parse(txtSoNguoiLam.Text.ToString());
addYeuCau.NgayTruc = DateTime.Parse(dtNgayNhap.Text.ToString());
List <CaTruc> lstCaTruc = TaoCaTrucMacDinh();
foreach (CaTruc caTruc in lstCaTruc)
{
addYeuCau.CaTruc.Add(caTruc);
}
yeuCauAPIS.PostYeuCau(addYeuCau);
List <CaTruc> CaTruc = addYeuCau.CaTruc.ToList();
FormChonCa f = new FormChonCa(addYeuCau);
f.Show();
gridYeuCau.DataSource = null;
getDataGrid();
}
private async void btnSua_Click(object sender, EventArgs e)
{
YeuCau yeuCau = yeuCauBindingSource.Current as YeuCau;
if (yeuCau != null)
{
FormSuaYeuCau f = new FormSuaYeuCau(yeuCau);
{
if (f.ShowDialog() == DialogResult.OK)
{
try
{
yeuCauBindingSource.EndEdit();
await db.SaveChangesAsync();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Mesage", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
public FormSuaYeuCau(YeuCau obj)
{
InitializeComponent();
yeuCauBindingSource.DataSource = obj;
}
public async Task CreateYeuCau(YeuCau yeuCau)
{
await _yeuCauRepository.AddAsync(yeuCau);
}
public async Task UpdateYeuCau(YeuCau yeuCau)
{
await _yeuCauRepository.UpdateAsync(yeuCau);
}
