public bool AccountUpdate(string username, Userinformation updateinfo) { try { using (Cafeteria_Vernier_dbEntities cvDatabase= new Cafeteria_Vernier_dbEntities()) { var customerInfo = cvDatabase.CustomerInformations.First(x => x.UserID.Equals(username)); customerInfo.Address = updateinfo.Address; customerInfo.Email = updateinfo.Email; customerInfo.Logo = updateinfo.UserImage; customerInfo.NationalID = updateinfo.NationalID; customerInfo.Phone = updateinfo.Phone; cvDatabase.SaveChanges(); return true; } } catch { throw new FaultException(ServiceVariables.ERROR_MESSAGES[0,2]); } }
public bool AddNewTeam(TeamInfo teamInfo, List<AllUserAndTeam> members) { try { using (Cafeteria_Vernier_dbEntities cvDatabase = new Cafeteria_Vernier_dbEntities()) { cvDatabase.AddToTeams(new Team { AdminName = teamInfo.TeamAdmin, JoinDate = teamInfo.EntryDate, Logo = teamInfo.TeamImage, Name = teamInfo.TeamD, TeamAccount = new TeamAccount { Minutes = 0, Name = teamInfo.TeamD, Status = false, EntryDate = DateTime.Today } }); foreach (AllUserAndTeam teamMember in members) { cvDatabase.AddToTeamMembers(new TeamMember { AutoInc = default(long), UserID = teamMember.Name, Name = teamInfo.TeamD }); } cvDatabase.SaveChanges(); } return true; } catch (Exception) { throw new FaultException(ServiceVariables.ERROR_MESSAGES[0, 2]); } }
public bool UserMunitieCounter(string username, short counterNumber) { try { using (Cafeteria_Vernier_dbEntities cvDatabase= new Cafeteria_Vernier_dbEntities()) { var userAccount = cvDatabase.CustomerAccounts.FirstOrDefault(x => x.UserID.Equals(username) && x.Minutes > 1); if (userAccount!=null) { userAccount.Minutes--; userAccount.Status = true; userAccount.Counternumber = counterNumber; cvDatabase.SaveChanges(); return true; } else { return false; } } } catch (Exception error) { throw new FaultException(error.Message); } }
public bool UserLogout(string username, Int64 loginHistoryID) { try { using (Cafeteria_Vernier_dbEntities cvDatabase = new Cafeteria_Vernier_dbEntities()) { var userinfo = cvDatabase.CustomerAccounts.FirstOrDefault(x => x.UserID.Equals(username)); if (userinfo!=null) { userinfo.Status = false; userinfo.Counternumber = 0; cvDatabase.UserLoginHistories.First(x => x.AutoInc == loginHistoryID).EndTime = DateTime.Now; cvDatabase.SaveChanges(); } else { throw new FaultException(ServiceVariables.ERROR_MESSAGES[0, 3]); } } return true; } catch { throw new FaultException(ServiceVariables.ERROR_MESSAGES[0, 2]); } }
public List<Int64> UserLogin(string username, string password, short counterNumber) { try { using (Cafeteria_Vernier_dbEntities cvDatabase= new Cafeteria_Vernier_dbEntities()) { var loginfo = cvDatabase.CustomerAccounts.FirstOrDefault(x=>x.UserID.Equals(username) && x.Password.Equals(password) && x.Minutes>1 && x.Status==false); if (loginfo!=null) { UserLoginHistory newLoginHistory= new UserLoginHistory { AutoInc= default(long), CounterNumber=counterNumber, StratTime=DateTime.Now, UserID=username, }; cvDatabase.AddToUserLoginHistories(newLoginHistory); loginfo.Status=true; loginfo.Counternumber=counterNumber; cvDatabase.SaveChanges(); List<Int64> customerinfo = new List<Int64>(); customerinfo.Add(loginfo.Minutes); customerinfo.Add(newLoginHistory.AutoInc); return customerinfo; } else { throw new FaultException(ServiceVariables.ERROR_MESSAGES[0, 0]); } } } catch (Exception error) { throw new FaultException(error.Message); } }
public bool UpdateTeam(string teamName, List<AllUserAndTeam> teamMembers) { try { using (Cafeteria_Vernier_dbEntities cvDatabase= new Cafeteria_Vernier_dbEntities()) { foreach (var existingMember in cvDatabase.TeamMembers.Where(x=>x.Name.Equals(teamName))) { cvDatabase.TeamMembers.DeleteObject(existingMember); } foreach (AllUserAndTeam teamMember in teamMembers) { cvDatabase.AddToTeamMembers(new TeamMember { Name = teamName, UserID = teamMember.Name }); } cvDatabase.SaveChanges(); return true; } } catch (Exception error) { throw new FaultException(error.Message); } }
public bool TeamMunitieCounter(string teamName,string username, short counterNumber) { try { lock (signalEntry) { using (Cafeteria_Vernier_dbEntities cvDatabase = new Cafeteria_Vernier_dbEntities()) { var teamAccount = cvDatabase.TeamAccounts.FirstOrDefault(x => x.Name.Equals(teamName) && x.Minutes > 1); var userAccount = cvDatabase.CustomerAccounts.FirstOrDefault(x => x.UserID.Equals(username)); if (teamAccount != null && userAccount != null) { teamAccount.Minutes--; teamAccount.Status = true; userAccount.Status = true; userAccount.Counternumber = counterNumber; cvDatabase.SaveChanges(); return true; } else { return false; } } } } catch { throw new FaultException(ServiceVariables.ERROR_MESSAGES[0, 4]); } }
public List<Int64> TeamLogin(string username, string password, short counterNumber, string teamName) { try { using (Cafeteria_Vernier_dbEntities cvDatabase= new Cafeteria_Vernier_dbEntities()) { var teamInfo = cvDatabase.TeamAccounts.FirstOrDefault(x => x.Team.Name.Equals(teamName) && x.Status == false); var memberInfo = cvDatabase.TeamMembers.FirstOrDefault(x => x.UserID.Equals(username)); var userInfo = cvDatabase.CustomerAccounts.FirstOrDefault(x => x.UserID.Equals(username) && x.Password.Equals(password)); var isTeamAdmin = cvDatabase.Teams.FirstOrDefault(x => x.Name.Equals(teamName) && x.AdminName.Equals(username)); if (teamInfo!=null && (memberInfo!=null || isTeamAdmin!=null ) && userInfo!=null) { UserLoginHistory newUserLoginHistory = new UserLoginHistory { AutoInc =default(long), CounterNumber=counterNumber, StratTime=DateTime.Now, TeamName=teamName, UserID=username }; cvDatabase.AddToUserLoginHistories(newUserLoginHistory); teamInfo.Status = true; var userinfo= cvDatabase.CustomerAccounts.FirstOrDefault(x => x.UserID.Equals(username)); userinfo.Status = false; userinfo.Counternumber = counterNumber; cvDatabase.SaveChanges(); List<Int64> teamLoginInfo = new List<Int64>(); teamLoginInfo.Add(teamInfo.Minutes); teamLoginInfo.Add(newUserLoginHistory.AutoInc); return teamLoginInfo; } else { throw new FaultException(ServiceVariables.ERROR_MESSAGES[0, 1]); } } } catch (Exception error) { throw new FaultException(error.Message); } }
public bool PasswordChange(string username, string newPassword) { try { using (Cafeteria_Vernier_dbEntities cvDatabase = new Cafeteria_Vernier_dbEntities()) { var customerInfo = cvDatabase.CustomerAccounts.FirstOrDefault(x => x.UserID.Equals(username)); if (customerInfo!=null) { customerInfo.Password = newPassword; cvDatabase.SaveChanges(); return true; } else { throw new FaultException(ServiceVariables.ERROR_MESSAGES[0, 2]); } } } catch (Exception) { throw new FaultException(ServiceVariables.ERROR_MESSAGES[0, 2]); } }
public bool DeleteMember(string teamName, AllUserAndTeam member) { try { using (Cafeteria_Vernier_dbEntities cvDatabase= new Cafeteria_Vernier_dbEntities()) { cvDatabase.TeamMembers.DeleteObject(cvDatabase.TeamMembers.First(x => x.UserID.Equals(member.Name) && x.Name.Equals(teamName))); cvDatabase.SaveChanges(); return true; } } catch { throw new FaultException(ServiceVariables.ERROR_MESSAGES[0, 2]); } }