private bool existUser(string userName)
{
using (DB_TESTASPNETEntities db = new DB_TESTASPNETEntities())
{
return(db.Users.Any(x => x.UserName == userName));
}
}
public ActionResult New(SeriesAddViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (DB_TESTASPNETEntities db = new DB_TESTASPNETEntities())
{
if (!existUser(model.UserName.Trim()))
{
createUser(model.UserName.Trim());
}
var oTabla = new Series();
oTabla.IDUser = getUserId(model.UserName);
oTabla.SeriesSplit = calculatedSerie(model.InvtervalInitial, model.InvtervalEnd);
oTabla.CreationDate = DateTime.Now;
db.Series.Add(oTabla);
db.SaveChanges();
}
return(Redirect("~/Series/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private int getUserId(string userName)
{
using (DB_TESTASPNETEntities db = new DB_TESTASPNETEntities())
{
var u = db.Users.FirstOrDefault(x => x.UserName == userName);
return(u.IDUser);
}
}
public ActionResult ListUser(string UserName)
{
List <sp_GetSeriesUser_Result> lst;
using (DB_TESTASPNETEntities db = new DB_TESTASPNETEntities())
{
lst = db.sp_GetSeriesUser(UserName).ToList();
}
return(View(lst));
}
// GET: Series
public ActionResult Index()
{
List <sp_GetAllSeriesUser_Result> lst;
using (DB_TESTASPNETEntities db = new DB_TESTASPNETEntities())
{
lst = db.sp_GetAllSeriesUser().ToList();
}
return(View(lst));
}
private int createUser(string userName)
{
int idUser = -1;
using (DB_TESTASPNETEntities db = new DB_TESTASPNETEntities())
{
var oTabla = new Users();
oTabla.UserName = userName;
oTabla.CreationDate = DateTime.Now;
db.Users.Add(oTabla);
db.SaveChanges();
idUser = oTabla.IDUser;
}
return(idUser);
}
