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