public IHttpActionResult PostSTAFF(STAFF sTAFF)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.STAFF.Add(sTAFF);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (STAFFExists(sTAFF.Staff_ID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = sTAFF.Staff_ID }, sTAFF));
}
public IActionResult insertNewStaff([FromForm] STAFF staff)
{
StaffManager staffManager = new StaffManager();
staffManager.insertStaff(staff);
return(Ok(new JsonCreate()));
}
public IHttpActionResult PutSTAFF(int id, STAFF sTAFF)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != sTAFF.Staff_ID)
{
return(BadRequest());
}
db.Entry(sTAFF).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!STAFFExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(int id)
{
STAFF sTAFF = db.STAFFs.Find(id);
db.STAFFs.Remove(sTAFF);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public StaffInformaitonDTO convertStaffToDto(STAFF staff)
{
StaffInformaitonDTO staffInformaiton = new StaffInformaitonDTO();
staffInformaiton._id = staff.STAFF_ID;
staffInformaiton._name = staff.NAME;
staffInformaiton._phone = staff.PHONE;
staffInformaiton._position = staff.POSITION;
return(staffInformaiton);
}
public ActionResult Edit([Bind(Include = "EmployeeID,EmployeeType,FirstName,LastName")] STAFF sTAFF)
{
if (ModelState.IsValid)
{
db.Entry(sTAFF).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sTAFF));
}
public StaffInformaitonDTO getStaffInformationById(String id)
{
STAFF staff = Db.Queryable <STAFF>().InSingle(id);
if (staff != null)
{
return(convertStaffToDto(staff));
}
return(null);
}
public ActionResult Edit([Bind(Include = "staf_Id,staf_Fname,staf_Lname,staf_Contact,staf_emial")] STAFF sTAFF)
{
if (ModelState.IsValid)
{
db.Entry(sTAFF).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sTAFF));
}
public ActionResult Edit([Bind(Include = "STAFF_ID,STAFF_NAME,STAFF_DESIGNATION,STAFF_TYPE")] STAFF sTAFF)
{
if (ModelState.IsValid)
{
db.Entry(sTAFF).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sTAFF));
}
public StaffInformaitonDTO getStaffInformationByPhone(String phone)
{
STAFF staff = Db.Queryable <STAFF>().Where(it => it.PHONE == phone).First();
if (staff != null)
{
return(convertStaffToDto(staff));
}
return(null);
}
public IHttpActionResult GetSTAFF(int id)
{
STAFF sTAFF = db.STAFF.Find(id);
if (sTAFF == null)
{
return(NotFound());
}
return(Ok(sTAFF));
}
public ActionResult Create([Bind(Include = "EmployeeID,EmployeeType,FirstName,LastName")] STAFF sTAFF)
{
if (ModelState.IsValid)
{
db.STAFFs.Add(sTAFF);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sTAFF));
}
public ActionResult Create([Bind(Include = "staf_Id,staf_Fname,staf_Lname,staf_Contact,staf_emial")] STAFF sTAFF)
{
if (ModelState.IsValid)
{
db.STAFFs.Add(sTAFF);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sTAFF));
}
public ActionResult Create([Bind(Include = "STAFF_ID,STAFF_NAME,STAFF_DESIGNATION,STAFF_TYPE")] STAFF sTAFF)
{
if (ModelState.IsValid)
{
db.STAFFS.Add(sTAFF);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sTAFF));
}
public JsonResult GetCourses(int progId, int deptId, int levelId)
{
List <COURSE> courses = new List <COURSE>();
List <SelectListItem> courseSelectList = new List <SelectListItem>();
try
{
if (progId > 0 && deptId > 0 && levelId > 0)
{
CourseLogic courseLogic = new CourseLogic();
courses = courseLogic.GetEntitiesBy(c => c.Department_Id == deptId && c.Level_Id == levelId && c.Programme_Id == progId && c.Active);
if (User.IsInRole("Lecturer"))
{
UserLogic userLogic = new UserLogic();
USER user = userLogic.GetEntityBy(u => u.Username == User.Identity.Name);
StaffLogic staffLogic = new StaffLogic();
StaffCourseLogic staffCourseLogic = new StaffCourseLogic();
STAFF staff = staffLogic.GetEntitiesBy(s => s.Person_Id == user.Person_Id).LastOrDefault();
if (staff != null)
{
List <STAFF_COURSE> staffCourses = staffCourseLogic.GetEntitiesBy(s => s.Staff_Id == staff.Person_Id);
if (staffCourses != null)
{
courses = staffCourses.Select(s => s.COURSE).ToList();
}
else
{
courses = new List <COURSE>();
}
}
}
SelectListItem list = new SelectListItem();
list.Value = "";
list.Text = "-- Select Course --";
courseSelectList.Add(list);
courses.ForEach(c =>
{
SelectListItem myList = new SelectListItem();
myList.Value = c.Id.ToString();
myList.Text = c.Code + " - " + c.Name;
courseSelectList.Add(myList);
});
}
}
catch (Exception ex)
{
}
return(Json(courseSelectList, JsonRequestBehavior.AllowGet));
}
public IHttpActionResult DeleteSTAFF(int id)
{
STAFF sTAFF = db.STAFF.Find(id);
if (sTAFF == null)
{
return(NotFound());
}
db.STAFF.Remove(sTAFF);
db.SaveChanges();
return(Ok(sTAFF));
}
// GET: Staffs/Edit/5
public ActionResult Edit(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
STAFF sTAFF = db.STAFFS.Find(id);
if (sTAFF == null)
{
return(HttpNotFound());
}
return(View(sTAFF));
}
// GET: Staff/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
STAFF sTAFF = db.STAFFs.Find(id);
if (sTAFF == null)
{
return(HttpNotFound());
}
return(View(sTAFF));
}
/// <summary>
/// Wyciaga z bazy informacje na temat danej roli w danym klubie
/// przyjmuje parametr 1 ID i 2 daną role np. 'Trener'
/// </summary>
public List <STAFF> StaffInTeamByRole(int id_team, string role)
{
List <STAFF> listOfStaffByRole = new List <STAFF>();
var result = db.staffInTeamByRole(id_team, role).ToList();
foreach (var element in result)
{
var tmp = new STAFF();
tmp.firstName = element.firstName;
tmp.lastName = element.lastName;
listOfStaffByRole.Add(tmp);
}
return(listOfStaffByRole);
}
private String verifyStaff(STAFF staff, String password, int type)
{
if (staff != null)
{
if (Md5.verifyMd5Hash(password, staff.PASSWORD))
{
return(AccountConstMessage.LOGIN_SUCCESS);
}
}
if (type == BY_PHONE)
{
return(AccountConstMessage.INVALID_INFO_PHONE);
}
else
{
return(AccountConstMessage.INVALID_INFO_ID);
}
}
public bool resetStaffPassword(String id, String password)
{
STAFF staff = Db.Queryable <STAFF>().InSingle(id);
if (staff != null)
{
staff.PASSWORD = Md5.getMd5Hash(password);
Db.Updateable(staff).ExecuteCommand();
STAFF _updatedStaff = Db.Queryable <STAFF>().InSingle(id);
if (_updatedStaff.PASSWORD == Md5.getMd5Hash(password))
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public String createStaff(RegisterDTO registerDTO)
{
STAFF staff0 = Db.Queryable <STAFF>().InSingle(registerDTO._id);
STAFF staff1 = Db.Queryable <STAFF>().Where(it => it.PHONE == registerDTO._phone).First();
if (staff0 != null)
{
return(AccountConstMessage.EXISTED_ID);
}
if (staff1 != null)
{
return(AccountConstMessage.EXISTED_PHONE);
}
STAFF staff = new STAFF();
staff.STAFF_ID = registerDTO._id;
staff.NAME = registerDTO._name;
staff.PASSWORD = Md5.getMd5Hash(registerDTO._password);
staff.PHONE = registerDTO._phone;
staff.SIGN_DATE = DateTime.Now;
Db.Insertable(staff).ExecuteCommand();
return(AccountConstMessage.REGISTER_SUCCESS);
}
public bool resetStaffInformation(String id, String name, String phone)
{
STAFF staff = Db.Queryable <STAFF>().InSingle(id);
if (staff != null)
{
staff.NAME = name;
staff.PHONE = phone;
Db.Updateable(staff).ExecuteCommand();
STAFF updatedStaff = Db.Queryable <STAFF>().InSingle(id);
if (updatedStaff.NAME == name && updatedStaff.PHONE == phone)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public JsonResult CreateUser(string userData)
{
JsonResponseModel result = new JsonResponseModel();
try
{
if (userData == null)
{
result.IsError = true;
result.Message = "Invalid data.";
return(Json(result, JsonRequestBehavior.AllowGet));
}
SignupJsonModel signupJsonModel = new JavaScriptSerializer().Deserialize <SignupJsonModel>(userData);
PersonLogic personLogic = new PersonLogic();
UserLogic userLogic = new UserLogic();
using (TransactionScope scope = new TransactionScope())
{
PERSON person = new PERSON();
person.Last_Name = signupJsonModel.surname.Trim();
person.First_Name = signupJsonModel.firstname.Trim();
person.Other_Name = !string.IsNullOrEmpty(signupJsonModel.othernames) ? signupJsonModel.othernames.Trim() : null;
person.Email = !string.IsNullOrEmpty(signupJsonModel.email) ? signupJsonModel.email.Trim() : null;
person.Phone_Number = !string.IsNullOrEmpty(signupJsonModel.phoneNumber) ? signupJsonModel.phoneNumber.Trim() : null;
person.Gender_Id = Convert.ToInt32(signupJsonModel.gender);
PERSON createdPerson = personLogic.Create(person);
STAFF staff = new STAFF();
staff.PERSON = createdPerson;
staff.Registration_Number = !string.IsNullOrEmpty(signupJsonModel.regnumber) ? signupJsonModel.regnumber.Trim() : null;
staff.Active = true;
staff.Is_Hall_Officer = Convert.ToInt32(signupJsonModel.role) == (int)Roles.HallStaff;
staff.Is_Lecturer = Convert.ToInt32(signupJsonModel.role) == (int)Roles.Lecturer;
staff.Is_Medical_Staff = Convert.ToInt32(signupJsonModel.role) == (int)Roles.MedicalSTaff;
staff.Is_Student_Affairs = Convert.ToInt32(signupJsonModel.role) == (int)Roles.StudentAffairs;
USER user = new USER();
user.Active = true;
user.Password = signupJsonModel.password.Trim();
user.Person_Id = createdPerson.Id;
user.Role_Id = Convert.ToInt32(signupJsonModel.role);
user.Username = !string.IsNullOrEmpty(signupJsonModel.userName) ? signupJsonModel.userName.Trim() : signupJsonModel.regnumber.Trim();
USER existingUser = userLogic.GetEntityBy(u => u.Username == signupJsonModel.userName);
if (existingUser != null)
{
result.IsError = true;
result.Message = "User with this username already exist.";
return(Json(result, JsonRequestBehavior.AllowGet));
}
userLogic.Create(user);
result.IsError = false;
result.Message = "Operation Sucessful";
scope.Complete();
}
}
catch (Exception ex)
{
result.IsError = true;
result.Message = ex.Message;
return(Json(result, JsonRequestBehavior.AllowGet));
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public async Task <IHttpActionResult> addStaff(staffModifyReceiver input)
{
using (var trans = db.Database.BeginTransaction())
{
try
{
var staff = new STAFF
{
ID = "1",
ID_CARD_NUMBER = input.idCardNumber,
INSERT_TIME = DateTime.Now,
IS_SUPER = "0",
NAME = input.name,
PASSWORD = input.password,
TEL_NUMBER = input.telNumber,
UPDATE_TIME = DateTime.Now,
ACCOUNT_ID = input.status == "0" ? "p" : input.status == "1" ? "r" : input.status == "2" ? "d" : "x"
};
db.STAFF.Add(staff);
db.SaveChanges();
var staffID = db.STAFF.OrderByDescending(s => s.ID).FirstOrDefault().ID;
System.Diagnostics.Debug.Write(staffID + "\n");
if (input.status == "0")
{
var patrol = new PATROL
{
ID = staffID,
PATROL_START = input.startTime,
PATROL_STOP = input.endTime
};
db.PATROL.Add(patrol);
}
else if (input.status == "1")
{
var repairer = new REPAIRER
{
ID = staffID,
};
db.REPAIRER.Add(repairer);
}
else if (input.status == "2")
{
var dispatcher = new DISPATCHER
{
ID = staffID,
DISPATCH_START = input.startTime,
DISPATCH_STOP = input.endTime
};
db.DISPATCHER.Add(dispatcher);
}
await db.SaveChangesAsync();
trans.Commit();
NotificationController.NotificationCallbackMsg("新增员工" + input.name + " 编号" + staff.ID);
return(Ok(new staffAddDto
{
data = getDtoList(),
info1 = "ok",
info2 = staff.ACCOUNT_ID
}));
}
catch (Exception e)
{
trans.Rollback();
System.Diagnostics.Debug.Write(e);
return(Ok(returnHelper.fail()));
}
}
}
public void insertStaff(STAFF staff)
{
staff.SIGN_DATE = DateTime.Now;
Db.Insertable(staff).ExecuteCommand();
}
public String verifyPasswordAndId(String id, String password)
{
STAFF staff = Db.Queryable <STAFF>().InSingle(id);
return(verifyStaff(staff, password, BY_ID));
}
public String verifyPasswordAndPhone(String phone, String password)
{
STAFF staff = Db.Queryable <STAFF>().Where(it => it.PHONE == phone).First();
return(verifyStaff(staff, password, BY_PHONE));
}
public int SaveDataStaff(StaffModel data)
{
try
{
if (data.StaffID == 0)
{
var staffcheck = _context.STAFFs.Where(x => x.UserName == data.UserName).ToList();
if (staffcheck.Count > 0)
{
return(-1);
}
var staff = new STAFF();
staff.Status = 1;
staff.Fname = data.Fname;
staff.Lname = data.Lname;
staff.UserName = data.UserName;
staff.Password = StaffModel.Encrypt(data.Password);
staff.CreateBy = data.UpdateBy;
staff.CreateDate = DateTime.Now;
staff.UpdateBy = data.UpdateBy;
staff.UpdateDate = DateTime.Now;
staff.DepartmentID = data.DepartmentID;
_context.Entry(staff).State = EntityState.Added;
_context.SaveChanges();
return(1);
}
else
{
var staffcheck = _context.STAFFs.Where(x => x.UserName == data.UserName && x.StaffID != data.StaffID).ToList();
if (staffcheck.Count > 0)
{
return(-1);
}
var staff = _context.STAFFs.Find(data.StaffID);
if (staff != null)
{
staff.Fname = data.Fname;
staff.Lname = data.Lname;
staff.UserName = data.UserName;
staff.Password = StaffModel.Encrypt(data.Password);
staff.UpdateBy = data.UpdateBy;
staff.UpdateDate = DateTime.Now;
staff.DepartmentID = data.DepartmentID;
_context.Entry(staff).State = EntityState.Modified;
_context.SaveChanges();
return(1);
}
return(0);
}
}
catch (Exception ex)
{
LogPOS.WriteLog("SaveDataStaff :::::::::::::::::::::::::" + ex.Message);
return(0);
}
}
