public string AddUsersToTeamDA(Team_User team_User) { string msg = ""; Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>(); if (team_User.teamId > 0) { cmdParameters["teamId"] = new SqlParameter("teamId", team_User.teamId); } else { int teamId = GetSavedTeamIDDA(); cmdParameters["teamId"] = new SqlParameter("teamId", teamId); } cmdParameters["userId"] = new SqlParameter("userId", team_User.userId); int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[AddUserstoTeam]", cmdParameters); if (rc == -1) { msg = "add user to team successfully...!"; } else { msg = "OOPs, something went wrong...!"; } return(msg); }
public int DeleteTaskDA(int id) { Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>(); cmdParameters["id"] = new SqlParameter("id", id); int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[DeleteTask]", cmdParameters); return(rc); }
public int UpdateStatusDA(Tasks task) { Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>(); cmdParameters["id"] = new SqlParameter("id", task.id); cmdParameters["status"] = new SqlParameter("status", task.status); int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[UpdateTask]", cmdParameters); return(rc); }
public int CreateTaskDA(Tasks task) { Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>(); cmdParameters["taskDetails"] = new SqlParameter("taskDetails", task.taskDetails); cmdParameters["taskAssignedDate"] = new SqlParameter("taskAssignedDate", task.taskAssignedDate); cmdParameters["taskEndDate"] = new SqlParameter("taskEndDate", task.taskEndDate); cmdParameters["responsibleUserId"] = new SqlParameter("responsibleUserId", task.responsibleUserId); int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[InsertTask]", cmdParameters); return(rc); }
public string CreateTeamDA(Team team) { string msg = ""; Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>(); cmdParameters["teamName"] = new SqlParameter("teamName", team.teamName); int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[CreateTeam]", cmdParameters); if (rc == -1) { msg = "team create successfully...!"; } else { msg = "OOPs, something went wrong...!"; } return(msg); }
public string DeleteUserDA(User user) { string msg = ""; Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>(); cmdParameters["id"] = new SqlParameter("id", user.id); int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[DeleteUser]", cmdParameters); if (rc == -1) { msg = "user delete successfully...!"; } else { msg = "OOPs, something went wrong...!"; } return(msg); }
public string UpdatePasswordDA(User user) { string msg = ""; PasswordProtection pp = new PasswordProtection(); var hashedPassowrd = pp.GenerateSHA256(user.password); Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>(); cmdParameters["id"] = new SqlParameter("id", user.id); cmdParameters["password"] = new SqlParameter("password", hashedPassowrd); int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[UpdateUsers]", cmdParameters); if (rc == -1) { msg = "Password updated successfully...!"; } else { msg = "OOPs, something went wrong...!"; } return(msg); }
public string CreateUsersDA(User user) { string msg = ""; PasswordProtection pp = new PasswordProtection(); var hashedPassowrd = pp.GenerateSHA256(user.password); Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>(); cmdParameters["userName"] = new SqlParameter("userName", user.userName); cmdParameters["password"] = new SqlParameter("password", hashedPassowrd); cmdParameters["role"] = new SqlParameter("role", user.role); int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[InsertUser]", cmdParameters); if (rc == -1) { msg = "user create successfully...!"; } else { msg = "OOPs, something went wrong...!"; } return(msg); }