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; }