public ActionResult AddUser(UserModel userModel,HttpPostedFileBase uploadFile)
{
ViewData["Roles"] = new List<string>(Enum.GetNames(typeof(Role))).AsEnumerable();
if(ModelState.IsValid)
{
if (uploadFile != null)
{
userModel.Photo = new byte[uploadFile.ContentLength];
uploadFile.InputStream.Read(userModel.Photo, 0, uploadFile.ContentLength);
}
var repository = Repository.GetRepository();
var isUserAlreadyExist = repository.ExecuteScalar<int>("Select count(*) From t_user where UserName='******'");
if(isUserAlreadyExist>0)
ModelState.AddModelError("UserAlreadyExists","User already exists.please enter a new user.");
else
{
var sqLiteParameters = new[]
{
new SQLiteParameter("@userName", DbType.String, 200)
{Value = userModel.UserName},
new SQLiteParameter("@role", DbType.String, 20) {Value = userModel.Role}
,
new SQLiteParameter("@photo", DbType.Binary, 20)
{Value = userModel.Photo},
new SQLiteParameter("@gender", DbType.String, 20)
{Value = userModel.Gender}
};
repository.ExecuteQuery("insert into t_user values(null,@userName,@role,@photo,@gender);",
sqLiteParameters);
return RedirectToAction("ViewUsers");
}
}
return View();
}
private List<UserModel> GetAllUserDetails()
{
var dataTable = Repository.GetRepository().LoadData("Select * from t_user");
var userModels = new List<UserModel>();
foreach (DataRow row in dataTable.Rows)
{
var userModel = new UserModel();
userModel.UserName= row["UserName"] as string;
userModel.Role= row["Role"] as string;
userModel.Gender= row["Gender"] as string;
userModel.Photo= row["Photo"] as Byte[];
userModel.ID = Convert.ToInt32(row["PK_ID"]);
userModels.Add(userModel);
}
return userModels;
}
private static bool isThesePairsInAnyCombination(UserModel pairTwo, UserModel pairOne, DataRow row)
{
return (Convert.ToString(row["PAIRONE"]) == pairOne.UserName && Convert.ToString(row["PAIRTWO"]) == pairTwo.UserName) ||
(Convert.ToString(row["PAIRONE"]) == pairTwo.UserName && Convert.ToString(row["PAIRTWO"]) == pairOne.UserName);
}