private void PopulateGrid(int id = -1)
{
mdc = new ModelDataContext();
try
{
var sourceNota = from nota in mdc.Notas
join alu in mdc.Aluno on nota.idAluno equals alu.idAluno
where nota.idTurma == id
select new { alu.Nome, nota.a1, nota.a2, nota.a3, nota.media };
gwNotas.DataSource = sourceNota;
gwNotas.DataBind();
}
catch (Exception)
{
throw;
}
finally
{
mdc.Dispose();
}
}
public static RideDto GetRideDto(ModelDataContext context, int rideId, int?userId)
{
var ride = context.Rides
.Where(row => row.RideId == rideId)
.Where(row => userId == null || row.UserId == userId)
.Select(row => new RideDto {
RideId = row.RideId,
StartUtc = row.StartUtc,
EndUtc = row.EndUtc,
Name = row.Name,
AverageSpeedMph = row.AverageSpeedMph,
MaxSpeedMph = row.MaxSpeedMph,
DistanceMiles = row.DistanceMiles,
UserId = row.UserId,
UserName = row.User.Name,
UserProfileImageUrl = row.User.ProfileImageUrl,
})
.SingleOrDefault();
if (ride == null)
{
return(null);
}
ride.Jumps = GetJumps(context, rideId);
ride.Locations = GetLocations(context, rideId);
ride.TrailAttempts = GetTrailAttempts(context, rideId);
ride.Achievements = GetAchievements(context, rideId);
return(ride);
}
/// <summary>
/// Perform the query
/// </summary>
protected IQueryable <TDomain> QueryInternal(ModelDataContext context, Expression <Func <TModel, bool> > query)
{
var domainQuery = m_mapper.MapModelExpression <TModel, TDomain>(query);
this.m_tracer.TraceEvent(System.Diagnostics.TraceEventType.Verbose, 0, "LINQ2SQL: {0}", domainQuery);
return(context.GetTable <TDomain>().Where(domainQuery));
}
public List <Artista> ObtenerArtistaGenero(int idGenero, bool insertarSeleccion)
{
List <Artista> result;
ModelDataContext db = new ModelDataContext();
try
{
db.ContextOptions.ProxyCreationEnabled = _proxy;
result = db.Artista.Where(w => w.IdGenero == idGenero).OrderBy(o => o.Descripcion).ToList();;
if (insertarSeleccion)
{
result.Insert(0,
new Artista
{
Id = BusinessVariables.ComboBoxCatalogo.ValueSeleccione,
Descripcion = BusinessVariables.ComboBoxCatalogo.DescripcionSeleccione
});
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
db.Dispose();
}
return(result);
}
/// <summary>
/// Perform the actual update.
/// </summary>
/// <param name="context">Context.</param>
/// <param name="data">Data.</param>
public override TModel Update(ModelDataContext context, TModel data, IPrincipal principal)
{
// Check for key
if (data.Key == Guid.Empty)
{
throw new SqlFormalConstraintException(SqlFormalConstraintType.NonIdentityUpdate);
}
// Get current object
var domainObject = this.FromModelInstance(data, context, principal) as TDomain;
var currentObject = context.GetTable <TDomain>().FirstOrDefault(ExpressionRewriter.Rewrite <TDomain>(o => o.Id == data.Key));
// Not found
if (currentObject == null)
{
throw new KeyNotFoundException(data.Key.ToString());
}
// VObject
var vobject = domainObject as IDbNonVersionedBaseData;
if (vobject != null)
{
vobject.UpdatedBy = principal.GetUser(context).UserId;
vobject.UpdatedTime = DateTimeOffset.Now;
}
currentObject.CopyObjectData(domainObject);
context.SubmitChanges();
return(this.ToModelInstance(domainObject, context, principal));
}
private void populateFields(int pGetID = 0)
{
mdc = new ModelDataContext();
try
{
if (pGetID > 0)
{
Materia materia = mdc.Materia.First(mat => mat.idMateria == pGetID);
tbCodigo.Text = pGetID.ToString();
tbNome.Text = materia.Nomem.Trim();
tbDescricao.Text = materia.Descricao.Trim();
}
else
{
Response.Redirect("Materias.aspx");
}
}
catch (Exception)
{
throw;
}
finally
{
mdc.Dispose();
}
}
public void GeneraSolicitudCancion(int idUsuario, string idGenero, string idArtista, string idAlbum, string cancion, string comentarios)
{
ModelDataContext db = new ModelDataContext();
try
{
Sugerencia sugerencia = new Sugerencia
{
IdUsuario = idUsuario,
Genero = idGenero.Trim().ToUpper(),
Artista = idArtista.Trim().ToUpper(),
Album = idAlbum.Trim().ToUpper(),
Cancion = cancion.Trim().ToUpper(),
Comentarios = comentarios.Trim().ToUpper()
};
db.Sugerencia.AddObject(sugerencia);
db.SaveChanges();
BusinessCorreo.SendMail("*****@*****.**", "Solicitud de Cancion", string.Format("Genero: {0}\nArtista: {1}\nAlbum: {2}\nCanción: {3}\n Comentarios: {4}", sugerencia.Genero, sugerencia.Artista, sugerencia.Album, sugerencia.Cancion, sugerencia.Comentarios));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
db.Dispose();
}
}
public void CrearCancion(int idAlbum, string nombreArchivo)
{
ModelDataContext db = new ModelDataContext();
try
{
Cancion newSong = new Cancion();
FileInfo fileInfo = new FileInfo(BusinessVariables.Directorios.RepositorioTemporal + nombreArchivo);
BusinessFile.MoverTemporales(BusinessVariables.Directorios.RepositorioTemporal, BusinessVariables.Directorios.Repositorio, nombreArchivo);
switch (fileInfo.Extension.ToLower())
{
case ".mp3":
newSong = new Cancion
{
IdAlbum = idAlbum,
Descripcion = nombreArchivo,
Extension = fileInfo.Extension,
ContentType = "audio/mpeg3",
FilePath = BusinessVariables.Directorios.Repositorio + nombreArchivo,
Data = null
};
break;
case ".m4a":
newSong = new Cancion
{
IdAlbum = idAlbum,
Descripcion = nombreArchivo,
Extension = fileInfo.Extension,
ContentType = "audio/mpeg4",
FilePath = BusinessVariables.Directorios.Repositorio + nombreArchivo,
Data = null
};
break;
case ".m4b":
newSong = new Cancion
{
IdAlbum = idAlbum,
Descripcion = nombreArchivo,
Extension = fileInfo.Extension,
ContentType = "audio/mpeg4",
FilePath = BusinessVariables.Directorios.Repositorio + nombreArchivo,
Data = null
};
break;
}
db.Cancion.AddObject(newSong);
db.SaveChanges();
BusinessFile.LimpiarTemporales(nombreArchivo);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
db.Dispose();
}
}
private void PopulateFields(int pGetID = 0)
{
mdc = new ModelDataContext();
try
{
if (pGetID > 0)
{
Model.Turma turma = mdc.Turma.First(tur => tur.idTurma == pGetID);
tbCodTurma.Text = pGetID.ToString();
tbCodMateria.Text = turma.idMateria.ToString().Trim();
tbNome.Text = turma.Nome.Trim();
}
else
{
Response.Redirect("Turma.aspx");
}
}
catch (Exception)
{
}
finally
{
mdc.Dispose();
}
}
public void Analyse(ModelDataContext context, int userId, int rideId)
{
var distanceAchievements = context.DistanceAchievements
.Select(row => new MinDistanceAchievement {
DistanceAchievementId = row.DistanceAchievementId,
MinDistanceMiles = row.MinDistanceMiles,
Name = row.Name,
})
.ToList();
double distance = context.Rides
.Where(row => row.RideId == rideId)
.Select(row => row.DistanceMiles)
.SingleOrDefault();
foreach (var distanceAchievement in distanceAchievements)
{
if (distanceAchievement.Check(distance))
{
UserDistanceAchievement userDistanceAchievement = new UserDistanceAchievement {
RideId = rideId,
DistanceAchievementId = distanceAchievement.DistanceAchievementId,
UserId = userId,
};
context.UserDistanceAchievements.Add(userDistanceAchievement);
context.SaveChanges();
}
}
}
public void GeneraVisita(string ip)
{
if (ip.Trim() == string.Empty)
{
return;
}
ModelDataContext db = new ModelDataContext();
try
{
Visita visita = db.Visita.SingleOrDefault(s => s.Ip == ip);
if (visita == null)
{
visita = new Visita {
Ip = ip, Veces = 1
};
db.Visita.AddObject(visita);
}
else
{
visita.Veces += 1;
}
db.SaveChanges();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
db.Dispose();
}
}
/// <summary>
/// Insert the specified TModel into the database
/// </summary>
public override TModel Insert(ModelDataContext context, TModel data, IPrincipal principal)
{
var inserted = this.m_actPersister.Insert(context, data, principal);
data.Key = inserted.Key;
return(base.Insert(context, data, principal));
}
public string Verify(String id)
{
try
{
ModelDataContext db = new ModelDataContext();
var query = from p in db.UserInformations where p.GUID == id select p;
foreach (UserInformation p in query)
{
/*UserInformation info = new UserInformation();
* info.FirstName = p.FirstName;
* info.LastName = p.LastName;
* info.Address = p.Address;
* info.Phone = p.Phone;
* info.PostalCode = p.PostalCode;
* info.Email = p.Email;
* info.Username = p.Username;
* info.Password=p.Password;*/
p.IsVerified = true;
}
db.SubmitChanges();
return("verified.");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public ListaReproduccion ObtenerListaReproduccionById(int idLista)
{
ListaReproduccion result = null;
ModelDataContext db = new ModelDataContext();
try
{
db.ContextOptions.ProxyCreationEnabled = _proxy;
result = db.ListaReproduccion.SingleOrDefault(w => w.Id == idLista);
db.LoadProperty(result, "ListaReproduccionDetalle");
foreach (ListaReproduccionDetalle detalle in result.ListaReproduccionDetalle)
{
db.LoadProperty(detalle, "Cancion");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
db.Dispose();
}
return(result);
}
private void onInsert()
{
mdc = new ModelDataContext();
try
{
Loja loja = new Loja();
loja.IdLoja = int.Parse(tbIdLoja.Text.Trim());
loja.Loja1 = tbLoja.Text.Trim();
loja.DataCadastro = DateTime.Parse(lblDataCadastro.Text.Trim());
loja.Endereco = tbEndereco.Text.Trim();
loja.Celular = tbTelefone.Text.Trim();
loja.Cep = tbCep.Text.Trim();
loja.Cidade = tbCidade.Text.Trim();
loja.Municipio = tbMunicipio.Text.Trim();
loja.UF = tbUF.Value.ToString();
mdc.Lojas.InsertOnSubmit(loja);
mdc.SubmitChanges();
Response.Write("<script language=javascript>alert('Cadastro efetuado com sucesso!!!');window.location.href='Loja_Add.aspx';</script>");
}
catch (Exception)
{
Response.Write("<script language=javascript>alert('Cadastro Existente !!!');window.location.href='Loja_Add.aspx';</script>");
}
finally
{
mdc.Dispose();
}
}
public void InsertUserInformation(UserInformation info)
{
ModelDataContext db = new ModelDataContext();
db.UserInformations.InsertOnSubmit(info);
db.SubmitChanges();
}
public string UpdateOrder(int id, Order order)
{
try
{
ModelDataContext db = new ModelDataContext();
var query = from p in db.Orders where p.ID == id select p;
foreach (Order p in query)
{
p.ClientID = order.ClientID;
p.ProductID = order.ProductID;
p.OrderQuantity = order.OrderQuantity;
p.OrderDate = order.OrderDate;
p.IsInCart = order.IsInCart;
}
db.SubmitChanges();
return(order.OrderDate + " updated successfully.");
}
catch (Exception e)
{
return("Error: " + e);
}
}
public MeasuresController(ModelDataContext modelDB, IConfiguration config, IServiceProvider serviceProvider, ILogger <MeasuresController> logger)
{
_modelDB = modelDB;
_config = config;
_fileService = (IFileService)serviceProvider.GetRequiredService(Type.GetType(config["Files:Type"]));
_logger = logger;
}
private void populateFields(int pGetID = 0)
{
mdc = new ModelDataContext();
try
{
if (pGetID > 0)
{
Model.Curso curso = mdc.Curso.First(cur => cur.idCurso == pGetID);
tbCodCurso.Text = pGetID.ToString();
tbNome.Text = curso.Nome.Trim();
tbDescricao.Text = curso.Descricao.Trim();
}
else
{
Response.Redirect("Materias.aspx");
}
}
catch (Exception)
{
}
finally
{
mdc.Dispose();
}
}
private void OnUpdate()
{
mdc = new ModelDataContext();
try
{
Model.Aluno aluno = mdc.Aluno.First(alu => alu.idAluno == int.Parse(tbCodAluno.Text.Trim()));
aluno.Nome = tbNome.Text.Trim();
aluno.Endereco = tbEndereco.Text.Trim();
aluno.Cep = tbCep.Text.Trim();
aluno.Telefone = tbTelefone.Text.Trim();
aluno.Celular = tbCelular.Text.Trim();
aluno.dataNascimento = DateTime.Parse(tbDataNasc.Text.Trim());
aluno.dataAtualizacao = DateTime.Parse(DateTime.Now.ToShortDateString());
mdc.SubmitChanges();
Response.Redirect("Aluno.aspx");
}
catch (Exception)
{
throw;
}
finally
{
mdc.Dispose();
}
}
private void Initialize()
{
if (_result == null)
{
var item = (IMenuDocItem)this.Document.ProjectItem;
_result = (IExperimentResultItem)item.Arguments[0];
}
if (_result == null)
{
return;
}
_modelContext = this._result.GetCtx <ModelDataContext>();
_resultCtx = _result.GetCtx <ResultDataContext>();
_stdStepInfos = new Dictionary <string, StdStep>();
_datas = new Dictionary <string, ResultData>();
_eaInfos = new Dictionary <string, List <EAItem> >();
_maMatchInfos = new Dictionary <string, List <MAItem> >();
_eaMatchInfos = new Dictionary <string, List <EAItem> >();
_eamMatchInfos = new Dictionary <string, List <EAItem> >();
ImportData_StdStep();
ImportData();
//this.gridView1.OptionsBehavior.Editable = false;
}
private void OnInsert()
{
mdc = new ModelDataContext();
try
{
Model.Turma turma = new Model.Turma();
turma.idMateria = int.Parse(tbCodMaterias.Text.Trim());
turma.Nome = tbNome.Text.Trim();
turma.dataCadastro = Convert.ToDateTime(tbDataCadastro.Text.Trim());
mdc.Turma.InsertOnSubmit(turma);
mdc.SubmitChanges();
Response.Redirect("Turma.aspx");
}
catch (Exception)
{
throw;
}
finally
{
mdc.Dispose();
}
}
public void AddCustomerTest()
{
using (var dataContext = new ModelDataContext())
using (var unitOfWork = new UnitOfWork(dataContext))
{
var customerID = Guid.NewGuid();
var customer = new Customer()
{
ID = Guid.NewGuid(),
Name = "BBC",
Address = "No.1 Bee Street",
City = "London",
Country = "UK",
Region = "AA",
Fax = "000000",
Phone = "00000000000",
PostalCode = "555555"
};
var customerRepository = unitOfWork.Repository <Customer>();
customerRepository.Insert(customer);;
unitOfWork.SaveChanges();
var insertedCustomer = customerRepository.Find(customerID);
Assert.IsNotNull(insertedCustomer);
Assert.AreEqual(customerID, insertedCustomer.ID);
}
}
public Usuario GetUserDataAutenticateId(int idUsuario, string ip)
{
Usuario result;
ModelDataContext db = new ModelDataContext();
try
{
db.ContextOptions.ProxyCreationEnabled = _proxy;
result = db.Usuario.SingleOrDefault(w => w.Id == idUsuario && w.Activo && w.Habilitado);
if (result != null)
{
BitacoraAcceso nuevoAcceso = new BitacoraAcceso
{
IdUsuario = result.Id,
Fecha = DateTime.Now,
Ip = ip
};
db.BitacoraAcceso.AddObject(nuevoAcceso);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
db.Dispose();
}
return(result);
}
public List <TipoIncidencia> ObtenerTodos(bool insertarSeleccion)
{
List <TipoIncidencia> result;
ModelDataContext db = new ModelDataContext();
try
{
db.ContextOptions.ProxyCreationEnabled = _proxy;
result = db.TipoIncidencia.OrderBy(o => o.Descripcion).ToList();;
if (insertarSeleccion)
{
result.Insert(0,
new TipoIncidencia
{
Id = BusinessVariables.ComboBoxCatalogo.ValueSeleccione,
Descripcion = BusinessVariables.ComboBoxCatalogo.DescripcionSeleccione
});
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
db.Dispose();
}
return(result);
}
/// <summary>
/// Delete the specified identity
/// </summary>
public void DeleteIdentity(string userName, IPrincipal authContext)
{
if (String.IsNullOrEmpty(userName))
{
throw new ArgumentNullException(nameof(userName));
}
this.m_traceSource.TraceInformation("Delete identity {0}", userName);
try
{
// submit the changes
using (var dataContext = new ModelDataContext(this.m_configuration.ReadWriteConnectionString))
{
new PolicyPermission(System.Security.Permissions.PermissionState.Unrestricted, PermissionPolicyIdentifiers.UnrestrictedAdministration, authContext).Demand();
var user = dataContext.SecurityUsers.FirstOrDefault(o => o.UserName == userName);
if (user == null)
{
throw new KeyNotFoundException("Specified user does not exist!");
}
// Obsolete
user.ObsoletionTime = DateTimeOffset.Now;
user.ObsoletedByEntity = authContext.GetUser(dataContext);
user.SecurityStamp = Guid.NewGuid().ToString();
dataContext.SubmitChanges();
}
}
catch (Exception e)
{
this.m_traceSource.TraceEvent(TraceEventType.Error, e.HResult, e.ToString());
throw;
}
}
/// <summary>
/// Update the specified user entity
/// </summary>
public override Core.Model.Entities.UserEntity Update(ModelDataContext context, Core.Model.Entities.UserEntity data, IPrincipal principal)
{
data.SecurityUser?.EnsureExists(context, principal);
data.SecurityUserKey = data.SecurityUser?.Key ?? data.SecurityUserKey;
this.m_personPersister.Update(context, data, principal);
return(base.Insert(context, data, principal));
}
private void OnInsert()
{
mdc = new ModelDataContext();
try
{
Materia materia = new Materia();
materia.Nome = tbNome.Text.Trim();
materia.Descricao = tbDescriao.Text.Trim();
materia.dataCadastro = Convert.ToDateTime(tbDataCadastro.Text.Trim());
mdc.Materia.InsertOnSubmit(materia);
mdc.SubmitChanges();
Response.Redirect("Materias.aspx");
}
catch (Exception)
{
throw;
}
finally
{
mdc.Dispose();
}
}
/// <summary>
/// Update the roles to security user
/// </summary>
public override Core.Model.Security.SecurityApplication Update(ModelDataContext context, Core.Model.Security.SecurityApplication data, IPrincipal principal)
{
var domainInstance = this.FromModelInstance(data, context, principal) as Data.SecurityApplication;
var currentObject = context.GetTable <Data.SecurityApplication>().FirstOrDefault(ExpressionRewriter.Rewrite <Data.SecurityApplication>(o => o.Id == data.Key));
if (currentObject == null)
{
throw new KeyNotFoundException(data.Key.ToString());
}
currentObject.CopyObjectData(domainInstance);
currentObject.ObsoletedBy = data.ObsoletedByKey == Guid.Empty ? null : data.ObsoletedByKey;
currentObject.ObsoletionTime = data.ObsoletionTime;
context.SubmitChanges();
context.SecurityApplicationPolicies.DeleteAllOnSubmit(context.SecurityApplicationPolicies.Where(o => o.ApplicationId == domainInstance.Id));
context.SubmitChanges();
context.SecurityApplicationPolicies.InsertAllOnSubmit(data.Policies.Select(o => new Data.SecurityApplicationPolicy
{
PolicyId = o.PolicyKey.Value,
PolicyAction = (int)o.GrantType,
ApplicationId = domainInstance.Id,
SecurityPolicyInstanceId = Guid.NewGuid()
}));
context.SubmitChanges();
return(data);
}
private void populateFields(int pGetID = 0)
{
mdc = new ModelDataContext();
try
{
if (pGetID > 0)
{
Model.Aluno aluno = mdc.Aluno.First(alu => alu.idAluno == pGetID);
tbCodAluno.Text = pGetID.ToString();
tbNome.Text = aluno.Nome.Trim();
tbEndereco.Text = aluno.Endereco.Trim();
tbCep.Text = aluno.Cep.Trim();
tbTelefone.Text = aluno.Telefone.Trim();
tbCelular.Text = aluno.Celular.Trim();
tbDataNasc.Text = aluno.dataNascimento.ToString();
}
else
{
Response.Redirect("Aluno.aspx");
}
}
catch (Exception)
{
throw;
}
finally
{
mdc.Dispose();
}
}
public List<T_Model> GetModelByID(long ID)
{
ModelDataContext db1 = new ModelDataContext(Shove._Web.WebConfig.GetAppSettingsString("ConnectionString"));
var Model = from s in db1.T_Model
where s.id.Equals(ID)
select s;
return Model.ToList<T_Model>();
}
public List<T_Model> GetModel(long UserID, string PlayType, string TypeName)
{
ModelDataContext db1 = new ModelDataContext(Shove._Web.WebConfig.GetAppSettingsString("ConnectionString"));
var Model = from s in db1.T_Model
where s.UserID.Equals(UserID) && s.PlayTypeID.Equals(PlayType) && s.TypeName.Equals(TypeName)
select s;
return Model.ToList<T_Model>();
}
public User GetUserByUsername(String username)
{
var db = new ModelDataContext(connectionString);
var user = from u in db.Users
where u.username == username
select u;
return user.FirstOrDefault<User>();
}
public Boolean ValidCredentials(String username, String password)
{
var db = new ModelDataContext(connectionString);
var users = from u in db.Users
where u.username == username && u.password == password
select u;
int rows = users.Count<User>();
return rows > 0;
}
public bool removeByUserId(string question, string vacancyNumber)
{
try
{
var obj = (from p in ctx.VacancyKillerQuestions
where p.question == @question && p.vacancyNumber == @vacancyNumber
select p).Single();
model.VacancyKillerQuestion accObj = (VacancyKillerQuestion)obj;
ctx.VacancyKillerQuestions.DeleteOnSubmit(accObj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public bool presist(ApplicationDTO entity)
{
try
{
model.Application obj = new Application();
obj.userName = entity.userName;
obj.vacancyNumber = entity.vacancyNumber;
obj.status = entity.status;
ctx.Applications.InsertOnSubmit(obj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public bool removeByUserId(string userName, string vacancyNumber)
{
try
{
var obj = (from p in ctx.Applications
where p.userName == @userName && p.vacancyNumber == @vacancyNumber
select p).Single();
Application accObj = (Application)obj;
ctx.Applications.DeleteOnSubmit(accObj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
protected void SignUp_Click(object sender, EventArgs e)
{
try
{
Datamanager dtm = new Datamanager();
ModelDataContext mod = new ModelDataContext();
UvaRequest uvReq = new UvaRequest();
string userUvaId = uvReq.GetUvaUserIdByUsername(txt_uvauser.Text);
if (userUvaId != null && !userUvaId.Equals("0") && !userUvaId.Equals(""))
{
MembershipUser user =
Membership.CreateUser(txt_uvauser.Text, txt_password.Text, txt_email.Text);
Guid id = (Guid)user.ProviderUserKey;
int intUserUvaId = int.Parse(userUvaId);
Usuario us = new Usuario()
{
Nombre = txt_name.Text,
IdUser = id,
Universidad = txt_uni.Text,
Uname = txt_uvauser.Text,
Uid = intUserUvaId
};
mod.Usuarios.InsertOnSubmit(us);
mod.SubmitChanges();
//FormsAuthentication.SetAuthCookie(txt_name.Text, false);
Response.Redirect("Login.aspx");
}
else
{
if (userUvaId.Equals("")) Msg.Text = "Hubo un problema con el servidor de uHunt intenta el registro más tarde.";
if (userUvaId == null||userUvaId.Equals("0")) Msg.Text = "Usuario de Uva no esta registrado";
}
}
catch (System.Web.Security.MembershipCreateUserException ex)
{
switch (ex.StatusCode)
{
case MembershipCreateStatus.DuplicateEmail:
Msg.Text = "Email está en uso";
break;
case MembershipCreateStatus.DuplicateProviderUserKey:
Msg.Text = "DPUK";
break;
case MembershipCreateStatus.DuplicateUserName:
Msg.Text = "Usuario está en uso";
break;
case MembershipCreateStatus.InvalidAnswer:
Msg.Text = "Respuesta Invalida";
break;
case MembershipCreateStatus.InvalidEmail:
Msg.Text = "Email inválido";
break;
case MembershipCreateStatus.InvalidPassword:
Msg.Text = "Contraseña inválida";
break;
case MembershipCreateStatus.InvalidProviderUserKey:
Msg.Text = "Invalid Provider User Key";
break;
case MembershipCreateStatus.InvalidQuestion:
Msg.Text = "Invalid Question";
break;
case MembershipCreateStatus.InvalidUserName:
Msg.Text = "Usuario Inválido";
break;
case MembershipCreateStatus.ProviderError:
Msg.Text = "Provider Error";
break;
case MembershipCreateStatus.Success:
Msg.Text = "Succes!";
break;
case MembershipCreateStatus.UserRejected:
Msg.Text = "User Rejected";
break;
default:
break;
}
}
//MembershipUser current =
// Membership.GetUser();
//if (current != null)
//{
//}
//TODO: Crear usuario en la otra tabla
}
public static ModelDataContext getModelInstance()
{
if (modelCtx == null)
modelCtx = new ModelDataContext();
return modelCtx;
}
public ApplicationDAO()
{
ctx = new ModelDataContext();//ModelFactory.getModelInstance();
}
public bool merge(ApplicationDTO entity)
{
try
{
var addObj = (from p in ctx.Applications
where p.userName == @entity.userName && p.vacancyNumber == @entity.vacancyNumber
select p).Single();
model.Application obj = (Application)addObj;
/*Update*/
obj.userName = entity.userName;
obj.vacancyNumber = entity.vacancyNumber;
obj.status = entity.status;
ctx.SubmitChanges();
return true;
}
catch (Exception e)
{
model.Log log = new Log();
log.message = "Application Merge: " + " [" + entity.userName + " , " + entity.vacancyNumber + "] " + e.Message;
ctx.Dispose();
ctx = new ModelDataContext();
ctx.SubmitChanges();
return false;
}
}
public bool presist(SupportDocDTO entity)
{
try
{
model.supportDoc obj = new supportDoc();
obj.userName = entity.userName;
obj.title = entity.title;
obj.description = entity.description;
obj.content = new System.Data.Linq.Binary(entity.content);//Array of bytes to Linq.Binary
ctx.supportDocs.InsertOnSubmit(obj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public UserRepository()
{
db = new ModelDataContext(connectionString);
}
public bool removeByUserId(string userName, string title)
{
try
{
var obj = (from p in ctx.supportDocs
where p.userName == @userName && p.title == @title
select p).Single();
model.supportDoc accObj = (supportDoc)obj;
ctx.supportDocs.DeleteOnSubmit(accObj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public SupportDocDAO()
{
ctx = new ModelDataContext();//ModelFactory.getModelInstance();
}
public bool merge(SupportDocDTO entity)
{
try
{
var addObj = (from p in ctx.supportDocs
where p.userName == @entity.userName && p.title == @entity.title
select p).Single();
model.supportDoc obj = (supportDoc)addObj;
/*Update*/
obj.userName = entity.userName;
obj.title = entity.title;
obj.description = entity.description;
obj.content = new System.Data.Linq.Binary(entity.content);//Array of bytes to Linq.Binary
ctx.SubmitChanges();
return true;
}
catch (Exception e)
{
model.Log log = new Log();
log.message = "supportDoc Merge: " + " ["+entity.userName+" , "+entity.title+"] " + e.Message;
ctx.SubmitChanges();
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public bool merge(BasicEduSubjectDTO entity)
{
try
{
var addObj = (from p in ctx.BasicEduSubjects
where p.userName == @entity.userName && p.subjectName == @entity.subjectName
select p).Single();
model.BasicEduSubject obj = (BasicEduSubject)addObj;
/*Update*/
obj.userName = entity.userName;
obj.subjectName = entity.subjectName;
obj.subjectDescription = entity.subjectDescription;
ctx.SubmitChanges();
return true;
}
catch (Exception e)
{
model.Log log = new Log();
log.message = "BasicEduSubject Merge: " + " ["+entity.userName+" , "+entity.subjectName+"] " + e.Message;
ctx.Dispose();
ctx = new ModelDataContext();
ctx.SubmitChanges();
return false;
}
}
public bool removeByUserId(string userName, string subjectName)
{
try
{
var obj = (from p in ctx.BasicEduSubjects
where p.userName == @userName && p.subjectName == @subjectName
select p).Single();
BasicEduSubject accObj = (BasicEduSubject)obj;
ctx.BasicEduSubjects.DeleteOnSubmit(accObj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public bool presist(VacancyKillerQuestionDTO entity)
{
try
{
model.VacancyKillerQuestion obj = new VacancyKillerQuestion();
obj.question = entity.question;
obj.vacancyNumber = entity.vacancyNumber;
obj.answer = entity.answer;
ctx.VacancyKillerQuestions.InsertOnSubmit(obj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public bool merge(VacancyKillerQuestionDTO entity)
{
try
{
var addObj = (from p in ctx.VacancyKillerQuestions
where p.question == @entity.question && p.vacancyNumber == @entity.vacancyNumber
select p).Single();
model.VacancyKillerQuestion obj = (VacancyKillerQuestion)addObj;
/*Update*/
obj.question = entity.question;
obj.vacancyNumber = entity.vacancyNumber;
obj.answer = entity.answer;
ctx.SubmitChanges();
return true;
}
catch (Exception e)
{
model.Log log = new Log();
log.message = "VacancyKillerQuestion Merge: " + " [" + entity.question + " , " + entity.vacancyNumber + "] " + e.Message;
ctx.SubmitChanges();
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public VacancyKillerQuestionDAO()
{
ctx = new ModelDataContext();//ModelFactory.getModelInstance();
}
public Datamanager()
{
modx = new ModelDataContext();
uvareq = new UvaRequest();
}
public bool presist(UserDTO entity)
{
try
{
model.User obj = new User();
obj.userName = entity.userName;
obj.id = entity.id;
obj.fullName = entity.fullName;
obj.nickName = entity.nickName;
obj.gender = entity.gender;
obj.race = entity.race;
obj.disabled = entity.disabled;
obj.citizenship = entity.citizenship;
obj.idType = entity.idType;
obj.license = entity.license;
obj.basicEducation = entity.basicEducation;
obj.higherEducation = entity.higherEducation;
obj.language = entity.language;
obj.residentialAddress = entity.residentialAddress;
obj.postalAddress = entity.postalAddress;
obj.employed = entity.employed;
obj.employmentHistory = entity.employmentHistory;
ctx.Users.InsertOnSubmit(obj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public UserDAO()
{
ctx = new ModelDataContext();//ModelFactory.getModelInstance();
}
public bool merge(UserDTO entity)
{
try
{
var addObj = (from p in ctx.Users
where p.userName == @entity.userName && p.id == @entity.id
select p).Single();
model.User obj = (User)addObj;
/*Update*/
obj.userName = entity.userName;
obj.id = entity.id;
obj.fullName = entity.fullName;
obj.nickName = entity.nickName;
obj.gender = entity.gender;
obj.race = entity.race;
obj.disabled = entity.disabled;
obj.citizenship = entity.citizenship;
obj.idType = entity.idType;
obj.license = entity.license;
obj.basicEducation = entity.basicEducation;
obj.higherEducation = entity.higherEducation;
obj.language = entity.language;
obj.residentialAddress = entity.residentialAddress;
obj.postalAddress = entity.postalAddress;
obj.employed = entity.employed;
obj.employmentHistory = entity.employmentHistory;
ctx.SubmitChanges();
return true;
}
catch (Exception e)
{
model.Log log = new Log();
log.message = "User Merge: " + " ["+entity.userName+" , "+entity.id+"] " + e.Message;
ctx.SubmitChanges();
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public BasicEduSubjectDAO()
{
ctx = new ModelDataContext();// new ModelDataContext();//ModelFactory.getModelInstance();
}
public bool removeByUserId(string userName, string id)
{
try
{
var obj = (from p in ctx.Users
where p.userName == @userName && p.id == @id
select p).Single();
User accObj = (User)obj;
ctx.Users.DeleteOnSubmit(accObj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public bool merge(InboxDTO entity)
{
try
{
var addObj = (from p in ctx.Inboxes
where p.userName == @entity.userName && p.messageId == @entity.messageId
select p).Single();
model.Inbox obj = (Inbox)addObj;
/*Update*/
obj.userName = entity.userName;
obj.messageId = entity.messageId;
obj.date = entity.date;
obj.unread = entity.unread;
obj.message = entity.message;
ctx.SubmitChanges();
return true;
}
catch (Exception e)
{
model.Log log = new Log();
log.message = "Inbox Merge: " + " ["+entity.userName+" , "+entity.messageId+"] " + e.Message;
ctx.SubmitChanges();
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public bool removeByUserId(string userName, int messageId)
{
try
{
var obj = (from p in ctx.Inboxes
where p.userName == @userName && p.messageId == @messageId
select p).Single();
model.Inbox accObj = (Inbox)obj;
ctx.Inboxes.DeleteOnSubmit(accObj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public bool presist(BasicEduSubjectDTO entity)
{
try
{
model.BasicEduSubject obj = new BasicEduSubject();
obj.userName = entity.userName;
obj.subjectName = entity.subjectName;
obj.subjectDescription = entity.subjectDescription;
ctx.BasicEduSubjects.InsertOnSubmit(obj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
