public void UpdateStaff(StaffViewModel objVM)
{
DBConnectionString.Profile profile = DBConnectionString.Profile.Fetch("select * from profile where userId=@0", objVM.UserId).SingleOrDefault();
DBConnectionString.Staff staff = DBConnectionString.Staff.Fetch("select * from staff where userId=@0", objVM.UserId).SingleOrDefault();
DBConnectionString.User user = DBConnectionString.User.Fetch("select * from Users where userId=@0", objVM.UserId).SingleOrDefault();
if (profile != null)
{
profile.Title = objVM.Title;
profile.DateOfBirth = objVM.DateOfBirth;
profile.MobileNumber = objVM.MobileNumber;
profile.HomeTelephoneNumber = objVM.HomeTelephoneNumber;
profile.EmailAddress1 = objVM.Email;
profile.Update();
}
if (staff != null)
{
staff.StaffTypeId = objVM.StaffTypeId;
staff.Email = objVM.Email;
staff.Update();
}
if (user != null)
{
user.FirstName = objVM.FirstName;
user.LastName = objVM.LastName;
user.Email = objVM.Email;
user.Update();
}
objVM.StaffPermission.UserId = objVM.UserId;
this.UpdateStaffPermissions(objVM.StaffPermission);
}
public long CreateNewStaff(StaffViewModel objViewModel)
{
DBConnectionString.Staff objStaff = new DBConnectionString.Staff();
objStaff.UserId = objViewModel.UserId;
objStaff.Title = objViewModel.Title;
objStaff.InsertedOn = DateTime.Now;
objStaff.InsertedBy = objViewModel.InsertedBy;
objStaff.Title = objViewModel.Title;
objStaff.Email = objViewModel.Email;
objStaff.StaffTypeId = objViewModel.StaffTypeId;
objStaff.OrganizationId = objViewModel.OrganizationId;
objStaff.FullName = objViewModel.Profile.FirstName + " " + objViewModel.Profile.LastName;
objStaff.Insert();
return(objStaff.StaffId);
}
public long CreateNewStaff(StaffViewModel objViewModel)
{
DBConnectionString.Staff objStaff = new DBConnectionString.Staff();
objStaff.UserId = objViewModel.UserId;
objStaff.Title = objViewModel.Title;
objStaff.InsertedOn = DateTime.Now;
objStaff.InsertedBy = objViewModel.InsertedBy;
objStaff.Title = objViewModel.Title;
objStaff.Email = objViewModel.Email;
objStaff.StaffTypeId = objViewModel.StaffTypeId;
objStaff.OrganizationId = objViewModel.OrganizationId;
objStaff.FullName = objViewModel.Profile.FirstName + " " + objViewModel.Profile.LastName;
objStaff.Insert();
return objStaff.StaffId;
}
