public ActionResult Note(List <TblNote> note)
{
using (DatabaseModels db = new DatabaseModels())
{
connection.ConnectionString = cParameter.cnnstring;
command.Connection = connection;
int userID = cParameter.userID;
command.CommandText = "select * from TblNote where REF_TblUser='******' ";
connection.Open();
SqlDataReader sdr = command.ExecuteReader();
List <TblNote> objModel = new List <TblNote>();
if (sdr.HasRows)
{
while (sdr.Read())
{
var details = new TblNote();
details.Title = sdr["Title"].ToString();
details.Description = sdr["Description"].ToString();
details.CreationTime = (DateTime)sdr["CreationTime"];
details.ID = Convert.ToInt32(sdr["ID"]);
objModel.Add(details);
}
note = objModel;
connection.Close();
}
return(View("Note", note));
}
}
public ActionResult AddOrEdit(user user)
{
using (DatabaseModels databaseModel = new DatabaseModels())
{
try
{
if (databaseModel.users.Any(x => x.email == user.email))
{
ViewBag.ErrorMessage = "Ya existe un usuario con ese email";
return(View("AddOrEdit", new user()));
}
else
{
databaseModel.users.Add(user);
databaseModel.SaveChanges();
ModelState.Clear();
ViewBag.SuccessMessage = "Se ha Registrado el usuario: " + user.email;
return(View("Login"));
}
}
catch (Exception exception)
{
ViewBag.ErrorMessage = "Ha ocurrido un error al intentar registrar el usuario" + exception.StackTrace;
return(View("AddOrEdit", new user()));
}
}
}
