public static void Update(Model.NHANVIEN item, string id)
{
Model.NHANVIEN getdt = Model.DataProvider.Ins.DB.NHANVIENs.Where(x => x.ma_nhanvien == id).SingleOrDefault();
getdt.ten_nhanvien = item.ten_nhanvien;
getdt.ngaysinh = item.ngaysinh;
getdt.sodienthoai = item.sodienthoai;
getdt.diachi = item.diachi;
getdt.QUYEN = item.QUYEN;
Model.DataProvider.Ins.DB.SaveChanges();
}
public static void Insert(Model.NHANVIEN item)
{
Model.DataProvider.Ins.DB.NHANVIENs.Add(item);
Model.DataProvider.Ins.DB.SaveChanges();
}
public static void Delete(Model.NHANVIEN item)
{
Model.DataProvider.Ins.DB.NHANVIENs.Remove(item);
}
public Nhanvien_ViewModel()
{
List = new ObservableCollection <Model.NHANVIEN>(Model.DataProvider.Ins.DB.NHANVIENs.Where(x => x.IsDeleted == false));
DeleteList = new ObservableCollection <Model.NHANVIEN>();
List_Quyen = new ObservableCollection <Model.QUYEN>(Model.DataProvider.Ins.DB.QUYENs);
Active = false;
IsOpen = false;
Active_Command = new RelayCommand <object>(p =>
{
if (Active == false)
{
return(false);
}
return(true);
}, p =>
{
Active = false;
});
CloseDialog_Command = new RelayCommand <object>(p =>
{
return(true);
}, p =>
{
IsOpen = false;
});
Load_Command = new RelayCommand <object>(p =>
{
return(true);
}, p =>
{
List = new ObservableCollection <Model.NHANVIEN>(Model.DataProvider.Ins.DB.NHANVIENs.Where(x => x.IsDeleted == false));
DeleteList = new ObservableCollection <Model.NHANVIEN>();
List_Quyen = new ObservableCollection <Model.QUYEN>(Model.DataProvider.Ins.DB.QUYENs);
Active = false;
IsOpen = false;
});
#region Tao moi
Reset_Command = new RelayCommand <object>(p =>
{
return(true);
}, p =>
{
SelectedItem = null;
Tennhanvien = "";
Diachi = "";
Sodienthoai = "";
Ngaysinh = "";
SQuyen = null;
});
#endregion
#region Phan them
Insert_Command = new RelayCommand <object>(p =>
{
if (string.IsNullOrEmpty(Tennhanvien) || string.IsNullOrEmpty(Sodienthoai) || string.IsNullOrEmpty(Diachi) || string.IsNullOrEmpty(Ngaysinh))
{
return(false);
}
long i = 0;
if (!long.TryParse(Sodienthoai, out i))
{
return(false);
}
int count = Model.DataProvider.Ins.DB.NHANVIENs.Where(x => x.sodienthoai == Sodienthoai).Count();
if (count != 0)
{
return(false);
}
if (SQuyen == null)
{
return(false);
}
return(true);
}, p =>
{
SelectedItem = null;
Model.NHANVIEN newItem = new Model.NHANVIEN()
{
ma_nhanvien = MyStaticMethods.RandomInt(10),
ten_nhanvien = Tennhanvien,
ngaysinh = MyStaticMethods.FormatDateString(Ngaysinh),
QUYEN = SQuyen,
diachi = Diachi,
sodienthoai = Sodienthoai,
IsDeleted = false
};
Model.Nhanvien_Service.Insert(newItem);
List.Insert(0, newItem);
SelectedItem = newItem;
Active = true;
Message = "Thêm mới thành công !!!";
});
#endregion
#region Phan sua
Update_Command = new RelayCommand <object>(p =>
{
if (SelectedItem == null)
{
return(false);
}
if (string.IsNullOrEmpty(Tennhanvien) || string.IsNullOrEmpty(Sodienthoai) || string.IsNullOrEmpty(Diachi) || string.IsNullOrEmpty(Ngaysinh))
{
return(false);
}
long i = 0;
if (!long.TryParse(Sodienthoai, out i))
{
return(false);
}
if (SQuyen == null)
{
return(false);
}
return(true);
}, p =>
{
Model.NHANVIEN UpdateItem = new Model.NHANVIEN()
{
ten_nhanvien = Tennhanvien,
ngaysinh = MyStaticMethods.FormatDateString(Ngaysinh),
QUYEN = SQuyen,
diachi = Diachi,
sodienthoai = Sodienthoai
};
Model.Nhanvien_Service.Update(UpdateItem, Manhanvien);
for (int i = 0; i < List.Count(); i++)
{
if (List[i] == SelectedItem)
{
List[i] = new Model.NHANVIEN()
{
ma_nhanvien = Manhanvien,
ten_nhanvien = Tennhanvien,
diachi = Diachi,
sodienthoai = Sodienthoai,
ngaysinh = MyStaticMethods.FormatDateString(Ngaysinh),
QUYEN = _SQuyen
};
break;
}
}
//MessageBox.Show("Chỉnh sửa thành công", "THÔNG BÁO");
SelectedItem = null;
Tennhanvien = "";
Diachi = "";
Sodienthoai = "";
Ngaysinh = "";
SQuyen = null;
Active = true;
Message = "Chỉnh sửa thành công !!!";
});
#endregion
#region Phan xoa
DeleteShow_Command = new RelayCommand <object>(p =>
{
if (DeleteList.Count() == 0)
{
return(false);
}
return(true);
}, p =>
{
IsOpen = true;
Content = " Xóa các bản ghi được chọn ???";
});
AddDeleteList_Command = new RelayCommand <CheckBox>(p =>
{
return(true);
}, p =>
{
DeleteList.Add(List.Where(x => x.ma_nhanvien == p.Uid.ToString()).SingleOrDefault());
});
RemoveDeleteList_Command = new RelayCommand <CheckBox>(p =>
{
return(true);
}, p =>
{
DeleteList.Remove(List.Where(x => x.ma_nhanvien == p.Uid.ToString()).SingleOrDefault());
});
Delete_Command = new RelayCommand <object>(p =>
{
if (DeleteList.Count() == 0)
{
return(false);
}
return(true);
}, p =>
{
RemoveIteminDb();
RemoveIteminList();
Capnhat_dboTaiKhoan();
DeleteList = new ObservableCollection <Model.NHANVIEN>();
IsOpen = false;
SelectedItem = null;
});
#endregion
#region Sap xep
OrderbyTen_Command = new RelayCommand <object>(p =>
{
if (List.Count() == 0)
{
return(false);
}
return(true);
}, p =>
{
ObservableCollection <Model.NHANVIEN> chkList = new ObservableCollection <Model.NHANVIEN>(List.OrderByDescending(x => x.ten_nhanvien));
if (List[0] == chkList[0])
{
List = new ObservableCollection <Model.NHANVIEN>(List.OrderBy(x => x.ten_nhanvien));
}
else
{
List = new ObservableCollection <Model.NHANVIEN>(chkList);
}
});
OrderbyDiachi_Command = new RelayCommand <object>(p =>
{
if (List.Count() == 0)
{
return(false);
}
return(true);
}, p =>
{
ObservableCollection <Model.NHANVIEN> chkList = new ObservableCollection <Model.NHANVIEN>(List.OrderByDescending(x => x.diachi));
if (List[0] == chkList[0])
{
List = new ObservableCollection <Model.NHANVIEN>(List.OrderBy(x => x.diachi));
}
else
{
List = new ObservableCollection <Model.NHANVIEN>(chkList);
}
});
OrderbyVitri_Command = new RelayCommand <object>(p =>
{
if (List.Count() == 0)
{
return(false);
}
return(true);
}, p =>
{
ObservableCollection <Model.NHANVIEN> chkList = new ObservableCollection <Model.NHANVIEN>(List.OrderByDescending(x => x.QUYEN.ma_quyen));
if (List[0] == chkList[0])
{
List = new ObservableCollection <Model.NHANVIEN>(List.OrderBy(x => x.QUYEN.ma_quyen));
}
else
{
List = new ObservableCollection <Model.NHANVIEN>(chkList);
}
});
#endregion
}
