private void OnLoginCommand(object parameter)
{
var pwContainer = parameter as IHavePassword;
var window = parameter as Window;
if (pwContainer != null)
{
var secureString = pwContainer.Password;
PassWord = ConvertToUnsecureString(secureString);
var userN = UserName;
using (var context = new QLChiTieuEntities())
{
System.Data.Entity.Core.Objects.ObjectParameter responseMessage = new System.Data.Entity.Core.Objects.ObjectParameter("responseMessage", typeof(String));
context.uspLogin(userN, PassWord, responseMessage);
MessageBox.Show(responseMessage.Value.ToString(), "Notification", MessageBoxButton.OK);
if (responseMessage.Value.ToString() == successLogin)
{
int id = GetCustomerIdByUserName(userN);
writeToSession(id);
window.Hide();
ABC.ViewModel.MainWindowViewModel.userID = id;
Window main = new MainWindow();
main.Show();
}
}
}
}
void OnSave(object parameter)
{
var passWordContainer = parameter as IHavePassword;
if (passWordContainer != null)
{
var newPassword = passWordContainer.Password;
var reEnterPassword = passWordContainer.RePassword;
var oldSecureString = passWordContainer.OldPassword;
var oldPass = ConvertToUnsecureString(oldSecureString);
string nPass = ConvertToUnsecureString(newPassword);
string rePass = ConvertToUnsecureString(reEnterPassword);
if (nPass == rePass)
{
using (var db = new QLChiTieuEntities()){
System.Data.Entity.Core.Objects.ObjectParameter responseMessage = new System.Data.Entity.Core.Objects.ObjectParameter("responseMessage", typeof(String));
db.uspModifyPassWord(id, oldPass, nPass, responseMessage);
if (responseMessage != null)
{
DialogHost.CloseDialogCommand.Execute(null, null);
MessageBox.Show(responseMessage.Value.ToString(), "Notification", MessageBoxButton.OK);
}
}
}
}
}
private int GetCustomerIdByUserName(string usName)
{
using (var db = new QLChiTieuEntities())
{
var query = db.Users.Where(s => s.UserName == usName).First <User>();
return(query.ID);
}
}
public TietKiemViewModel()
{
themTietKiem = new MyICommand(OnClick);
using (var context = new QLChiTieuEntities())
{
System.Data.Entity.Core.Objects.ObjectParameter responseMessage = new System.Data.Entity.Core.Objects.ObjectParameter("responseMessage", typeof(String));
context.uspThemKhoanTietKiem(IDUser, IDTK, IDVI, SoTien, responseMessage);
}
}
void LoadData()
{
using (var context = new QLChiTieuEntities())
{
Nhom = context.Nhoms.ToList();
viHienTai = ABC.ViewModel.TrangChuViewModel.viHienTai;
Ngay = DateTime.Now;
}
}
public TaiKhoanViewModel()
{
int id = ABC.ViewModel.MainWindowViewModel.userID;
using (var db = new QLChiTieuEntities())
{
SelectedUser = db.Users.Find(id);
}
OpenChangePassDialogCommand = new MyICommand <object>(OpenChangePassDialog);
OpenChangeUserNameDialogCommand = new MyICommand <object>(OpenChangeUserNameDialog);
}
public void TestIndex()
{
var db = new QLChiTieuEntities();
var controller = new ChiTieuController();
var result = controller.Index() as ViewResult;
Assert.IsNotNull(result);
var model = result.Model as List <Expenditure>;
Assert.AreEqual(db.Expenditures.Count(),
(model.Count));
}
public void ChonVi(int idVi)
{
db = new QLChiTieuEntities();
var dsVi = db.Users.Find(idUser).Vis;
foreach (var vi in dsVi)
{
if (vi.ID == idVi)
{
viHienTai = vi;
return;
}
}
Load();
}
void LoadVi()
{
userVi.Clear();
db = new QLChiTieuEntities();
var userVis = db.Users.Find(idUser).Vis;
if (userVis.Count != 0)
{
viHienTai = db.Users.Find(idUser).Vis.First();
}
foreach (var vi in userVis)
{
userVi.Add(vi);
}
}
public void TestEditG()
{
var controller = new ChiTieuController();
var result0 = controller.Edit(0);
Assert.IsInstanceOfType(result0, typeof(HttpNotFoundResult));
var db = new QLChiTieuEntities();
var item = db.Expenditures.First();
var result1 = controller.Edit(item.id) as ViewResult;
Assert.IsNotNull(result1);
var model = result1.Model as Expenditure;
Assert.AreEqual(item.id, model.id);
}
void onOk()
{
DialogHost.CloseDialogCommand.Execute(null, null);
try
{
using (var context = new QLChiTieuEntities())
{
System.Data.Entity.Core.Objects.ObjectParameter responseMessage = new System.Data.Entity.Core.Objects.ObjectParameter("responseMessage", typeof(String));
context.uspThemTietKiem(IDUser, TenKhoanTK, MucDich, MucTieu, Ngay, responseMessage);
MessageBox.Show(responseMessage.Value.ToString(), "Notification", MessageBoxButton.OK);
}
} catch (Exception error)
{
MessageBox.Show(error.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
}
public ThemNoViewModel()
{
onCancelCommand = new MyICommand(onCancel);
onOKCommand = new MyICommand(onOk);
using (var context = new QLChiTieuEntities())
{
try
{
ViList = context.Vis.ToList();
}
catch (Exception e)
{
Console.Write(e.Message);
}
}
}
void Load()
{
currentDate = DateTime.Now;
db = new QLChiTieuEntities();
var userGD = db.Users.Find(idUser).SO_GIAO_DICH;
foreach (var gd in userGD)
{
if (gd.NGAY.Value.Date == currentDate.Date && gd.ID_VI == viHienTai.ID)
{
giaoDichs.Add(gd);
}
}
thuNhapTrongThang = TinhThuNhapTrongThang(userGD, currentDate, viHienTai);
chiTieuTrongThang = TinhChiTieuTrongThang(userGD, currentDate, viHienTai);
conLai = thuNhapTrongThang - chiTieuTrongThang;
}
void onOk()
{
try
{
using (var context = new QLChiTieuEntities())
{
System.Data.Entity.Core.Objects.ObjectParameter responseMessage = new System.Data.Entity.Core.Objects.ObjectParameter("responseMessage", typeof(String));
context.uspThemGiaoDich(userId, viHienTai.ID, _selectedNhom, SoTien, GhiChu, nguoiLienQuan, Ngay, responseMessage);
DialogHost.CloseDialogCommand.Execute((bool)true, null);
MessageBox.Show(responseMessage.Value.ToString(), "Notification", MessageBoxButton.OK);
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Notification", MessageBoxButton.OK);
}
DialogHost.CloseDialogCommand.Execute((bool)true, null);
}
void OnSave(object parameter)
{
var container = parameter as IHavePassword;
if (container != null)
{
var secureString = container.Password;
passWord = ConvertToUnsecureString(secureString);
using (var db = new QLChiTieuEntities())
{
System.Data.Entity.Core.Objects.ObjectParameter responseMessage = new System.Data.Entity.Core.Objects.ObjectParameter("responseMessage", typeof(String));
db.uspModifyUserName(userID, passWord, newUserName, responseMessage);
DialogHost.CloseDialogCommand.Execute(null, null);
MessageBox.Show(responseMessage.Value.ToString(), "Notification", MessageBoxButton.OK);
}
}
DialogHost.CloseDialogCommand.Execute(null, null);
}
void onOk()
{
try
{
using (var db = new QLChiTieuEntities())
{
System.Data.Entity.Core.Objects.ObjectParameter responseMessage = new System.Data.Entity.Core.Objects.ObjectParameter("responseMessage", typeof(String));
db.uspThemVi(usId, tenVi, soTienVi, responseMessage);
DialogHost.CloseDialogCommand.Execute((bool)true, null);
MessageBox.Show(responseMessage.Value.ToString(), "Notification", MessageBoxButton.OK);
}
}
catch (Exception e)
{
DialogHost.CloseDialogCommand.Execute((bool)true, null);
MessageBox.Show(e.Message, "Notification", MessageBoxButton.OK);
}
}
private void OnSignUpCommand(object parameter)
{
var pwContainer = parameter as IHavePassword;
if (pwContainer != null)
{
try
{
var secureString = pwContainer.Password;
var reEnterSecureString = pwContainer.RePassword;
_passWord = ConvertToUnsecureString(secureString);
_reEnterPassWord = ConvertToUnsecureString(reEnterSecureString);
var dob = Convert.ToDateTime(DayOfBirth);
if (_passWord != _reEnterPassWord)
{
throw new Exception("password and password confirm are different");
}
using (var context = new QLChiTieuEntities())
{
System.Data.Entity.Core.Objects.ObjectParameter responseMessage = new System.Data.Entity.Core.Objects.ObjectParameter("responseMessage", typeof(String));
context.uspAddUser(UserName, _passWord, CustomerName, dob, responseMessage);
MessageBox.Show(responseMessage.Value.ToString(), "Notification", MessageBoxButton.OK);
}
}
catch (Exception error)
{
MessageBox.Show(error.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
var container = parameter as Window;
container.Visibility = Visibility.Hidden;
Window signin = new Login();
signin.Show();
}
}
private void Load()
{
var db = new QLChiTieuEntities();
curentUser = db.Users.Find(userID);
}
