public ActionResult Index(FormCollection frmCollection)
{
bool IsDriver = false;
if (Request.Form["IsDriver"] != null)
{
IsDriver = true;
}
if (frmCollection["passwd"].ToString() == frmCollection["cnfPassword"].ToString())
{
User ObjUser = new User();
ObjUser.FirstName = frmCollection["firstname"];
ObjUser.LastName = frmCollection["lastname"];
ObjUser.Email = frmCollection["email"];
ObjUser.Password = frmCollection["passwd"];
ObjUser.IsDriver = IsDriver;
ObjUser.LisenceNo = 2323;
UserDataLayer UserDataLayer = new UserDataLayer();
UserReponse Response = UserDataLayer.InsertUserAndGetResponse(ObjUser);
if (Response.ResultCode == ResultCodes.Error)
{
ViewBag.InfoError = Response.Message;
}
else if (Response.ResultCode == ResultCodes.Exists)
{
ViewBag.InfoMessage = Response.Message;
}
else if (Response.ResultCode == ResultCodes.Success)
{
ViewBag.InfoMessage = Response.Message;
}
}
else
{
ViewBag.InfoError = "Password doesnt Match!!!";
}
return(View());
}
/// <summary>
/// Sauvegarde de la Reponse et du commentaire du User dans la BDD
/// </summary>
/// <param name="questionViewModel"></param>
public void SaveUserResponse(List <Reponses> reponses, int quizzId, string commentaire)
{
using (FilRougeDBContext db = new FilRougeDBContext())
{
//Boucle pour les reponses du User
foreach (var reponse in reponses)
{
var uneReponseUser = new UserReponse()
{
QuizzId = quizzId,
ReponseId = reponse.ReponseId,
//TODO Changer pour recuperer la valeur de la reponse
Valeur = reponse.Content.ToString(),
Commentaire = commentaire,
EstRepondu = true
};
db.UserReponse.Add(uneReponseUser);
}
db.SaveChanges();
}
}
/// <summary>
/// Sauvegarde de la Reponse du User dans la BDD
/// </summary>
/// <param name="questionViewModel"></param>
public void SaveUserResponse(List <Reponses> reponses, int quizzId)
{
using (FilRougeDBContext db = new FilRougeDBContext())
{
//mapping de la question
//var question = questionViewModel.MapToQuestion();
//Boucle pour les reponses du User
foreach (var reponse in reponses)
{
var uneReponseUser = new UserReponse()
{
QuizzId = quizzId,
ReponseId = reponse.ReponseId,
//TODO Changer pour recuperer la valeur de la reponse
Valeur = reponse.Content.ToString()
};
db.UserReponse.Add(uneReponseUser);
}
db.SaveChanges();
}
}
// GET
public IActionResult SeeOrder()
{
int currentid = 0;
string sql = "Select user_id from users where enabled=0 AND username=@name ";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@name", "visiteur");
currentid = st.LookIfNotAVisitor(cmd);
if (currentid == 0)
{
menu.Connected = true;
string sqlre = "Select user_id from users where enabled=0 ";
_currentid = st.getCurrentIdOrVisiteur(sqlre);
}
var path = "http://*****:*****@id";
user = cart.AllInformationAboutUser(sqldata, _currentid);
if (order.Liste != null)
{
ViewData["OrderReponse"] = order;
ViewData["UserReponse"] = user;
return(View());
}
error.NomService = "Service order";
ViewData["ReponseError"] = error;
return(View("ErrorView"));
}
public async Task <UserReponse> GetUserByIdAsync(string Id)
{
var users = await _userManager.FindByIdAsync(Id.ToString());
if (users == null)
{
throw new Exception($"{Id} not found");
}
var roles = await _userManager.GetRolesAsync(users);
var data = new UserReponse()
{
Id = users.Id,
UserName = users.UserName,
FirstName = users.FirstName,
LastName = users.LastName,
Dob = users.Dob,
Email = users.Email,
PhoneNumber = users.PhoneNumber,
Roles = roles
};
return(data);
}
public UserReponse InsertUserAndGetResponse(User ObjBindedUser)
{
UserReponse Response;
using (SqlConnection con = new SqlConnection(ConnectionString))
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SPHeeraUserInsert", con);
cmd.CommandType = CommandType.StoredProcedure;
string encryptedPassword = FormsAuthentication.
HashPasswordForStoringInConfigFile(ObjBindedUser.Password, "SHA1");
cmd.Parameters.AddWithValue("@FIRST_NAME", ObjBindedUser.FirstName);
cmd.Parameters.AddWithValue("@LAST_NAME", ObjBindedUser.LastName);
cmd.Parameters.AddWithValue("@EMAIL", ObjBindedUser.Email);
cmd.Parameters.AddWithValue("@PASSWORD", encryptedPassword);
cmd.Parameters.AddWithValue("@IsDriver", ObjBindedUser.IsDriver);
cmd.Parameters.AddWithValue("@LisenceNo", ObjBindedUser.LisenceNo);
string Result = (string)cmd.ExecuteScalar();
if (Result == "USER_EXISTS")
{
Response = new UserReponse
{
Message = "User already exists",
ResultCode = ResultCodes.Exists
};
}
else if (Result == "USER_INSERTED")
{
Response = new UserReponse
{
Message = "User inserted successfully",
ResultCode = ResultCodes.Success
};
}
else
{
Response = new UserReponse
{
Message = "Some thing went wrong",
ResultCode = ResultCodes.Error
};
}
}
catch (Exception ex)
{
Response = new UserReponse
{
Message = ex.Message,
ResultCode = ResultCodes.Error
};
}
finally
{
con.Close();
}
}
return(Response);
}
