private void SetCaLamViec(CaLamViec caLamViec)
{
textEdit1.Text = caLamViec.TenCaLamViec;
timeSpanEdit1.TimeSpan = caLamViec.GioBatDauCa;
timeSpanEdit2.TimeSpan = caLamViec.GioKetThucCa;
timeSpanEdit3.TimeSpan = caLamViec.GioBatDauGiaiLao == null ? TimeSpan.Zero : (TimeSpan)caLamViec.GioBatDauGiaiLao;
timeSpanEdit4.TimeSpan = caLamViec.GioKetThucGiaiLao == null ? TimeSpan.Zero : (TimeSpan)caLamViec.GioKetThucGiaiLao;
numericUpDown26.Value = caLamViec.TongGio;
numericUpDown26.Value = caLamViec.DiemCong;
timeSpanEdit5.TimeSpan = caLamViec.GioVaoSomNhatDuocTinhCa;
timeSpanEdit6.TimeSpan = caLamViec.GioVaoMuonNhatDuocTinhCa;
timeSpanEdit7.TimeSpan = caLamViec.GioRaMuonNhatDuocTinhCa;
timeSpanEdit8.TimeSpan = caLamViec.GioRaSomNhatDuocTinhCa;
numericUpDown2.Value = caLamViec.KhongCoGioRa;
numericUpDown3.Value = caLamViec.KhongCoGioVao;
checkBox1.Checked = caLamViec.TruGioDiTre == null ? false : (bool)caLamViec.TruGioDiTre;
checkBox4.Checked = caLamViec.TruGioVeSom == null ? false : (bool)caLamViec.TruGioVeSom;
numericUpDown5.Value = caLamViec.ThoiGianDiTreChoPhep == null? 0:(int)caLamViec.ThoiGianDiTreChoPhep;
numericUpDown8.Value = caLamViec.ThoiGianVeSomChoPhep == null ? 0 : (int)caLamViec.ThoiGianVeSomChoPhep;
checkBox6.Checked = caLamViec.SDMucTangCaHienTai == null ? false : (bool)caLamViec.SDMucTangCaHienTai;
checkBox5.Checked = caLamViec.SDMucTangCaCuoiTuan == null ? false : (bool)caLamViec.SDMucTangCaCuoiTuan;
checkBox8.Checked = caLamViec.SDMucTangCaNgayLe == null ? false : (bool)caLamViec.SDMucTangCaNgayLe;
checkBox7.Checked = (caLamViec.TangCaTruocGLV == null || caLamViec.TangCaTruocGLV == 0) ? false : true;
checkBox10.Checked = checkBox7.Checked = (caLamViec.TangCaSauGLV == null || caLamViec.TangCaSauGLV == 0) ? false : true;
}
public List <CaLamViec> ViewCaLamViec(string sql)
{
try
{
List <CaLamViec> list = new List <CaLamViec>();
SqlDataReader dr = p.View(sql);
if (dr != null)
{
string MaCaLV;
string TenCa;
DateTime GioBatDau;
DateTime GioKetThuc;
while (dr.Read())
{
MaCaLV = dr.GetString(0);
TenCa = dr.GetString(1);
GioBatDau = dr.GetDateTime(2);
GioKetThuc = dr.GetDateTime(3);
CaLamViec clv = new CaLamViec(MaCaLV, TenCa, GioBatDau, GioKetThuc);
list.Add(clv);
}
}
return(list);
}
catch (SqlException p)
{
throw p;
}
}
private void barButtonRefresh_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
allowInsert = false;
barButtonItemAddNew.Enabled = true;
CaLamViec caLamViec = new CaLamViec();
SetCaLamViec(caLamViec);
RefreshGrid();
}
// POST: odata/CaLamViecs
public IHttpActionResult Post(CaLamViec caLamViec)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CaLamViecs.Add(caLamViec);
db.SaveChanges();
return(Created(caLamViec));
}
public bool CapNhat(CaLamViec item)
{
CaLamViecDAL dal = new CaLamViecDAL(db);
if (item != null)
{
return(dal.CapNhat(item));
}
else
{
return(false);
}
}
public int DeleteCaLamViec(CaLamViec calamviec)
{
List <SqlParameter> paras = new List <SqlParameter>();
paras.Add(new SqlParameter("@maclv", calamviec.MaCaLV));
try
{
return(p.ExecNonQuery("deletecalamviec", CommandType.StoredProcedure, paras));
}
catch (SqlException p)
{
throw p;
}
}
// DELETE: odata/CaLamViecs(5)
public IHttpActionResult Delete([FromODataUri] int key)
{
CaLamViec caLamViec = db.CaLamViecs.Find(key);
if (caLamViec == null)
{
return(NotFound());
}
db.CaLamViecs.Remove(caLamViec);
db.SaveChanges();
return(StatusCode(HttpStatusCode.NoContent));
}
//Save
private void button1_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
button1.Enabled = false;
ATINChamCongEntities context = new ATINChamCongEntities();
//date
switch (WorkCalendarShowType)
{
case "week":
foreach (ListViewItem Dateitem in listView2.CheckedItems)
{
int?x = Dateitem.Tag as int?;
foreach (ListViewItem caItem in listView1.CheckedItems)
{
CaLamViec ca = caItem.Tag as CaLamViec;
context.spInsertLichTrinhTuan(lichTrinh.MaLichTrinh, ca.MaCaLamViec, x);
}
}
break;
case "month":
foreach (ListViewItem Dateitem in listView2.CheckedItems)
{
int?x = Dateitem.Tag as int?;
foreach (ListViewItem caItem in listView1.CheckedItems)
{
CaLamViec ca = caItem.Tag as CaLamViec;
context.spInsertLichTrinhThang(lichTrinh.MaLichTrinh, ca.MaCaLamViec, x);
}
}
break;
case "year":
foreach (ListViewItem Dateitem in listView2.CheckedItems)
{
int?x = Dateitem.Tag as int?;
foreach (ListViewItem caItem in listView1.CheckedItems)
{
CaLamViec ca = caItem.Tag as CaLamViec;
context.spInsertLichTrinhNam(lichTrinh.MaLichTrinh, ca.MaCaLamViec, x, comboBox1.SelectedIndex + 1);
}
}
break;
}
TreeView1Config(listView2);
Cursor.Current = Cursors.Default;
button1.Enabled = true;
}
private CaLamViec GetCaLamViec()
{
CaLamViec caLamViec = new CaLamViec();
caLamViec.MaCaLamViec = textEdit1.Text;
caLamViec.TenCaLamViec = textEdit2.Text;
caLamViec.GioBatDauCa = timeSpanEdit1.TimeSpan;
caLamViec.GioKetThucCa = timeSpanEdit2.TimeSpan;
caLamViec.GioBatDauGiaiLao = timeSpanEdit3.TimeSpan;
caLamViec.GioKetThucGiaiLao = timeSpanEdit4.TimeSpan;
caLamViec.TongGio = (int)numericUpDown26.Value;
caLamViec.DiemCong = (int)numericUpDown26.Value;
caLamViec.GioVaoSomNhatDuocTinhCa = timeSpanEdit5.TimeSpan;
caLamViec.GioVaoMuonNhatDuocTinhCa = timeSpanEdit6.TimeSpan;
caLamViec.GioRaMuonNhatDuocTinhCa = timeSpanEdit7.TimeSpan;
caLamViec.GioRaSomNhatDuocTinhCa = timeSpanEdit8.TimeSpan;
caLamViec.KhongCoGioRa = (int)numericUpDown2.Value;
caLamViec.KhongCoGioVao = (int)numericUpDown3.Value;
caLamViec.TruGioDiTre = checkBox1.Checked;
caLamViec.TruGioVeSom = checkBox4.Checked;
caLamViec.ThoiGianDiTreChoPhep = (int)numericUpDown5.Value;
caLamViec.ThoiGianVeSomChoPhep = (int)numericUpDown8.Value;
caLamViec.SDMucTangCaHienTai = checkBox6.Checked;
caLamViec.SDMucTangCaCuoiTuan = checkBox5.Checked;
caLamViec.SDMucTangCaNgayLe = checkBox8.Checked;
caLamViec.SDTangCaTruocGLV = checkBox7.Checked;
caLamViec.SDTangCaSauGLV = checkBox10.Checked;
caLamViec.SDTongGLVTinhTangCa = checkBox9.Checked;
caLamViec.MucTangCaHienTai = (int)numericUpDown9.Value;
caLamViec.MucTangCaCuoiTuan = (int)numericUpDown10.Value;
caLamViec.MucTangCaNgayLe = (int)numericUpDown11.Value;
caLamViec.TangCaTruocGLV = (int)numericUpDown12.Value;
caLamViec.TangCaSauGLV = (int)numericUpDown13.Value;
caLamViec.TongGLVTinhTangCa = (int)numericUpDown14.Value;
caLamViec.GioiHanTCMucMot = (int)numericUpDown20.Value;
caLamViec.GioiHanTCMucHai = (int)numericUpDown19.Value;
caLamViec.SDMucTangCaCuaTangCaCuoiTuan = checkBox12.Checked;
caLamViec.SDMucTangCaCuaTangCaNgayLe = checkBox11.Checked;
caLamViec.MucTangCaCuaTangCaCuoiTuan = (int)numericUpDown24.Value;
caLamViec.MucTangCaCuaTangCaNgayLe = (int)numericUpDown23.Value;
caLamViec.GioiHanTCTruocGLV = (int)numericUpDown22.Value;
caLamViec.GioiHanTCSauGLV = (int)numericUpDown21.Value;
caLamViec.CaQuaDem = checkBox13.Checked;
caLamViec.TachGioCaDemTu = timeSpanEdit10.TimeSpan;
caLamViec.TachGioCaDemDen = timeSpanEdit9.TimeSpan;
return(caLamViec);
}
public int UpdateCaLamViec(CaLamViec calamviec)
{
List <SqlParameter> paras = new List <SqlParameter>();
paras.Add(new SqlParameter("@maclv", calamviec.MaCaLV));
paras.Add(new SqlParameter("@tencalamviec", calamviec.TenCa));
paras.Add(new SqlParameter("@giobatdau", calamviec.GioBatDau));
paras.Add(new SqlParameter("@gioketthuc", calamviec.GioKetThuc));
try
{
return(p.ExecNonQuery("updatecalamviec", CommandType.StoredProcedure, paras));
}
catch (SqlException p)
{
throw p;
}
}
private void SetCaLamViec(CaLamViec caLamViec)
{
textEdit1.Text = caLamViec.MaCaLamViec;
textEdit2.Text = caLamViec.TenCaLamViec;
timeSpanEdit1.TimeSpan = caLamViec.GioBatDauCa;
timeSpanEdit2.TimeSpan = caLamViec.GioKetThucCa;
timeSpanEdit3.TimeSpan = caLamViec.GioBatDauGiaiLao == null ? TimeSpan.Zero : (TimeSpan)caLamViec.GioBatDauGiaiLao;
timeSpanEdit4.TimeSpan = caLamViec.GioKetThucGiaiLao == null ? TimeSpan.Zero : (TimeSpan)caLamViec.GioKetThucGiaiLao;
numericUpDown26.Value = caLamViec.TongGio;
numericUpDown26.Value = caLamViec.DiemCong;
timeSpanEdit5.TimeSpan = caLamViec.GioVaoSomNhatDuocTinhCa;
timeSpanEdit6.TimeSpan = caLamViec.GioVaoMuonNhatDuocTinhCa;
timeSpanEdit7.TimeSpan = caLamViec.GioRaMuonNhatDuocTinhCa;
timeSpanEdit8.TimeSpan = caLamViec.GioRaSomNhatDuocTinhCa;
numericUpDown2.Value = caLamViec.KhongCoGioRa;
numericUpDown3.Value = caLamViec.KhongCoGioVao;
checkBox1.Checked = caLamViec.TruGioDiTre == null ? false : (bool)caLamViec.TruGioDiTre;
checkBox4.Checked = caLamViec.TruGioVeSom == null ? false : (bool)caLamViec.TruGioVeSom;
numericUpDown5.Value = caLamViec.ThoiGianDiTreChoPhep == null ? 0 : (int)caLamViec.ThoiGianDiTreChoPhep;
numericUpDown8.Value = caLamViec.ThoiGianVeSomChoPhep == null ? 0 : (int)caLamViec.ThoiGianVeSomChoPhep;
checkBox6.Checked = caLamViec.SDMucTangCaHienTai == null ? false : (bool)caLamViec.SDMucTangCaHienTai;
checkBox5.Checked = caLamViec.SDMucTangCaCuoiTuan == null ? false : (bool)caLamViec.SDMucTangCaCuoiTuan;
checkBox8.Checked = caLamViec.SDMucTangCaNgayLe == null ? false : (bool)caLamViec.SDMucTangCaNgayLe;
checkBox7.Checked = caLamViec.SDTangCaTruocGLV == null ? false : (bool)caLamViec.SDTangCaTruocGLV;
checkBox10.Checked = caLamViec.SDTangCaSauGLV == null ? false : (bool)caLamViec.SDTangCaSauGLV;
checkBox9.Checked = caLamViec.SDTongGLVTinhTangCa == null ? false : (bool)caLamViec.SDTongGLVTinhTangCa;
numericUpDown9.Value = caLamViec.MucTangCaHienTai == null ? 0 : (int)caLamViec.MucTangCaHienTai;
numericUpDown10.Value = caLamViec.MucTangCaCuoiTuan == null ? 0 : (int)caLamViec.MucTangCaCuoiTuan;
numericUpDown11.Value = caLamViec.MucTangCaNgayLe == null ? 0 : (int)caLamViec.MucTangCaNgayLe;
numericUpDown12.Value = caLamViec.TangCaTruocGLV == null ? 0 : (int)caLamViec.TangCaTruocGLV;
numericUpDown13.Value = caLamViec.TangCaSauGLV == null ? 0 : (int)caLamViec.TangCaSauGLV;
numericUpDown14.Value = caLamViec.TongGLVTinhTangCa == null ? 0 : (int)caLamViec.TongGLVTinhTangCa;
numericUpDown20.Value = caLamViec.GioiHanTCMucMot == null ? 0 : (int)caLamViec.GioiHanTCMucMot;
numericUpDown19.Value = caLamViec.GioiHanTCMucHai == null ? 0 : (int)caLamViec.GioiHanTCMucHai;
checkBox12.Checked = caLamViec.SDMucTangCaCuaTangCaCuoiTuan == null ? false : (bool)caLamViec.SDMucTangCaCuaTangCaCuoiTuan;
checkBox11.Checked = caLamViec.SDMucTangCaCuaTangCaNgayLe == null ? false : (bool)caLamViec.SDMucTangCaCuaTangCaNgayLe;
numericUpDown24.Value = caLamViec.MucTangCaCuaTangCaCuoiTuan == null ? 0 : (int)caLamViec.MucTangCaCuaTangCaCuoiTuan;
numericUpDown23.Value = caLamViec.MucTangCaCuaTangCaNgayLe == null ? 0 : (int)caLamViec.MucTangCaCuaTangCaNgayLe;
numericUpDown22.Value = caLamViec.GioiHanTCTruocGLV == null ? 0 : (int)caLamViec.GioiHanTCTruocGLV;
numericUpDown21.Value = caLamViec.GioiHanTCSauGLV == null ? 0 : (int)caLamViec.GioiHanTCSauGLV;
checkBox13.Checked = caLamViec.CaQuaDem == null ? false : (bool)caLamViec.CaQuaDem;
timeSpanEdit10.TimeSpan = caLamViec.TachGioCaDemTu == null ? TimeSpan.Zero : (TimeSpan)caLamViec.TachGioCaDemTu;
timeSpanEdit9.TimeSpan = caLamViec.TachGioCaDemDen == null ? TimeSpan.Zero : (TimeSpan)caLamViec.TachGioCaDemDen;
}
public bool Xoa(CaLamViec item)
{
CaLamViecDAL dal = new CaLamViecDAL(db);
try
{
if (item != null)
{
return(dal.Xoa(item));
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult Patch([FromODataUri] int key, Delta <CaLamViec> patch)
{
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
CaLamViec caLamViec = db.CaLamViecs.Find(key);
if (caLamViec == null)
{
return(NotFound());
}
patch.Patch(caLamViec);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CaLamViecExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(caLamViec));
}
private void Save(string MaCaLamViecChon, CaLamViec caLamViec, ref bool allowInsert)
{
try
{
if (allowInsert)
{
ATINChamCongEntities context = new ATINChamCongEntities();
context.spInsertCaLamViec(
caLamViec.MaCaLamViec,
caLamViec.TenCaLamViec,
caLamViec.GioBatDauCa,
caLamViec.GioKetThucCa,
caLamViec.GioBatDauGiaiLao,
caLamViec.GioKetThucGiaiLao,
caLamViec.TongGio,
caLamViec.DiemCong,
caLamViec.GioVaoSomNhatDuocTinhCa,
caLamViec.GioVaoMuonNhatDuocTinhCa,
caLamViec.GioRaMuonNhatDuocTinhCa,
caLamViec.GioRaSomNhatDuocTinhCa,
caLamViec.KhongCoGioRa,
caLamViec.KhongCoGioVao,
caLamViec.TruGioDiTre,
caLamViec.ThoiGianDiTreChoPhep,
caLamViec.TruGioVeSom,
caLamViec.ThoiGianVeSomChoPhep,
caLamViec.SDMucTangCaHienTai,
caLamViec.MucTangCaHienTai,
caLamViec.SDMucTangCaCuoiTuan,
caLamViec.MucTangCaCuoiTuan,
caLamViec.SDMucTangCaNgayLe,
caLamViec.MucTangCaNgayLe,
caLamViec.SDTangCaTruocGLV,
caLamViec.TangCaTruocGLV,
caLamViec.SDTangCaSauGLV,
caLamViec.TangCaSauGLV,
caLamViec.SDTongGLVTinhTangCa,
caLamViec.TongGLVTinhTangCa,
caLamViec.GioiHanTCMucMot,
caLamViec.GioiHanTCMucHai,
caLamViec.SDMucTangCaCuaTangCaCuoiTuan,
caLamViec.MucTangCaCuaTangCaCuoiTuan,
caLamViec.SDMucTangCaCuaTangCaNgayLe,
caLamViec.MucTangCaCuaTangCaNgayLe,
caLamViec.GioiHanTCTruocGLV,
caLamViec.GioiHanTCSauGLV,
caLamViec.CaQuaDem,
caLamViec.TachGioCaDemTu,
caLamViec.TachGioCaDemDen
);
}
else
{
ATINChamCongEntities context = new ATINChamCongEntities();
context.spUpdateCaLamViec(
MaCaLamViecChon,
caLamViec.MaCaLamViec,
caLamViec.TenCaLamViec,
caLamViec.GioBatDauCa,
caLamViec.GioKetThucCa,
caLamViec.GioBatDauGiaiLao,
caLamViec.GioKetThucGiaiLao,
caLamViec.TongGio,
caLamViec.DiemCong,
caLamViec.GioVaoSomNhatDuocTinhCa,
caLamViec.GioVaoMuonNhatDuocTinhCa,
caLamViec.GioRaMuonNhatDuocTinhCa,
caLamViec.GioRaSomNhatDuocTinhCa,
caLamViec.KhongCoGioRa,
caLamViec.KhongCoGioVao,
caLamViec.TruGioDiTre,
caLamViec.ThoiGianDiTreChoPhep,
caLamViec.TruGioVeSom,
caLamViec.ThoiGianVeSomChoPhep,
caLamViec.SDMucTangCaHienTai,
caLamViec.MucTangCaHienTai,
caLamViec.SDMucTangCaCuoiTuan,
caLamViec.MucTangCaCuoiTuan,
caLamViec.SDMucTangCaNgayLe,
caLamViec.MucTangCaNgayLe,
caLamViec.SDTangCaTruocGLV,
caLamViec.TangCaTruocGLV,
caLamViec.SDTangCaSauGLV,
caLamViec.TangCaSauGLV,
caLamViec.SDTongGLVTinhTangCa,
caLamViec.TongGLVTinhTangCa,
caLamViec.GioiHanTCMucMot,
caLamViec.GioiHanTCMucHai,
caLamViec.SDMucTangCaCuaTangCaCuoiTuan,
caLamViec.MucTangCaCuaTangCaCuoiTuan,
caLamViec.SDMucTangCaCuaTangCaNgayLe,
caLamViec.MucTangCaCuaTangCaNgayLe,
caLamViec.GioiHanTCTruocGLV,
caLamViec.GioiHanTCSauGLV,
caLamViec.CaQuaDem,
caLamViec.TachGioCaDemTu,
caLamViec.TachGioCaDemDen
);
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
public static bool XoaCaLamViec(CaLamViec ca)
{
return(DAO.QuanLyCaTruc.CaLamViecDAO.XoaCaLamViec(ca));
}
public static bool CapNhatCaLamViec(CaLamViec ca)
{
return(DAO.QuanLyCaTruc.CaLamViecDAO.CapNhatCaLamViec(ca));
}
