//to use with SelectList UserDropDownList
public SelectList GetUserList()
{
AssignPartnerUser assignPartnerUser = new AssignPartnerUser();
List<AssignPartnerUser> userList = new List<AssignPartnerUser>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_GetUserList, conn);
SqlDataReader results = cmd.ExecuteReader();
while (results.Read())
{
userList.Add(new AssignPartnerUser
{
Text = Convert.ToString(results["username"]),
Value = Convert.ToString(results["username"])
});
}
}
assignPartnerUser.UserDropDownList = new SelectList(userList, "Value", "Text");
}
catch (SqlException ex)
{
throw;
}
return assignPartnerUser.UserDropDownList;
}
public ActionResult AssignPartnerUser(AssignPartnerUser partnerUser)
{
if (!ModelState.IsValid)
{
return(View("CreatePartner", partnerUser));
}
sqlDAL.AssignPartnerUser(partnerUser);
return(View("SuccessPartnerUserAssigned", partnerUser));
}
public ActionResult AssignPartnerUser()
{
if (Session["currentUser"] != null)
{
if ((Session["currentUser"] as User).Administrator)
{
AssignPartnerUser dropDowns = new AssignPartnerUser();
dropDowns.UserDropDownList = sqlDAL.GetUserList();
dropDowns.PartnerDropDownList = sqlDAL.GetPartnerList();
return(View(dropDowns));
}
}
return(RedirectToAction("AccessDenied", "User"));
}
public void AssignPartnerUserTest()
{
//Arrange
PartnerSqlDAL dalObject = new PartnerSqlDAL(connectionString);
AssignPartnerUser partnerUser = new AssignPartnerUser()
{
Partner = "Test Partner X",
User = "******"
};
//Act
bool wasAssigned = dalObject.AssignPartnerUser(partnerUser);
//Assert
Assert.AreEqual(true, wasAssigned);
}
//assign user to partner
public bool AssignPartnerUser(AssignPartnerUser partnerUser)
{
int rowsAffected = 0;
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd;
conn.Open();
cmd = new SqlCommand(SQL_AssignPartnerUser, conn);
cmd.Parameters.AddWithValue("@partner", partnerUser.Partner);
cmd.Parameters.AddWithValue("@username", partnerUser.User);
rowsAffected = cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
throw;
}
return rowsAffected > 0;
}
