//public List<Usuario> SearchInfo(string txtLogin, string UserType)
//{
// using (SmartBagEntities entities = new SmartBagEntities())
// {
// var query = from tbtu in entities.TBT_USER
// join tbtut in entities.TBT_USER_TYPE
// on tbtu.UserTypeCode equals tbtut.UserTypeCode
// join tbtc in entities.TBT_CLIENT
// on tbtu.ClientCode equals tbtc.ClientCode into _a
// from tbtc in _a.DefaultIfEmpty()
// join tbti in entities.TBT_INSPECTOR
// on tbtu.InspectorCode equals tbti.InspectorCode
// into _t
// from tbti in _a.DefaultIfEmpty()
// select new Usuario
// {
// Login = tbtu.Login,
// Active = tbtu.Active == 1 ? true : false,
// UserTypeCode = tbtu.UserTypeCode,
// UserType = tbtut.Description,
// ClientName = tbtc.Name,
// InspectorName = tbti.Name
// };
// if (!string.IsNullOrEmpty(txtLogin))
// query = query.Where(x => x.Login.Contains(txtLogin));
// if (!string.IsNullOrEmpty(UserType))
// {
// int code = Convert.ToInt32(UserType);
// query = query.Where(x => x.UserTypeCode == code);
// }
// return query.ToList();
// }
//}
//public Collection<SelectListItem> UserTypeList()
//{
// try
// {
// Collection<SelectListItem> lista = new Collection<SelectListItem>();
// using (SmartBagEntities entities = new SmartBagEntities())
// {
// var ListaCinema = from tbti in entities.TBT_USER_TYPE
// select tbti;
// lista.Add(new SelectListItem { Text = "", Selected = true });
// foreach (var item in ListaCinema)
// {
// lista.Add(new SelectListItem { Value = item.UserTypeCode.ToString(), Text = item.Description });
// }
// }
// return lista;
// }
// catch (Exception)
// {
// throw new Exception("Erro: " + HttpStatusCode.BadRequest);
// }
//}
public static Usuario AutenticaUsuario(String login, String senha)
{
if (string.IsNullOrEmpty(login) || string.IsNullOrEmpty(senha))
{
throw new Exception("User/Password incorrect");
return(null);
}
using (SmartBagEntities entities = new SmartBagEntities())
{
var query = (from u in entities.TBT_USUARIO
where u.Login.ToUpper().Equals(login.ToUpper()) &&
u.Senha.ToUpper().Equals(senha.ToUpper()) &&
u.IndAtivo == 1
select new Usuario()
{
CodUsuario = u.CodUsuario,
CodPessoa = u.CodPessoa,
Login = u.Login,
Ativo = u.IndAtivo > 0 ? true : false,
ID = u.ID,
CreationDate = u.CtrlDataOperacao.Value
});
Usuario usuario = query.FirstOrDefault();
if (usuario == null)
{
throw new Exception("User/Password incorrect");
}
return(usuario);
}
}
public List <Usuario> ListofUser(string TxtNomePessoa = null, decimal?Status = null, string TxtLogin = null)
{
using (SmartBagEntities entities = new SmartBagEntities())
{
bool blStatus = Status == 1 ? true : false;
var query = (from tbtu in entities.TBT_USUARIO.Where(x => x.Login != "ADMIN")
join tbtp in entities.TBT_PESSOA on tbtu.CodPessoa equals tbtp.CodPessoa
select new Usuario
{
CodUsuario = tbtu.CodUsuario,
Login = tbtu.Login,
Ativo = tbtu.IndAtivo == 1 ? true : false,
NomePessoa = tbtp.Nome
});
if (!string.IsNullOrEmpty(TxtLogin))
{
query = query.Where(x => x.Login.Contains(TxtLogin));
}
if (Status != null)
{
query = query.Where(x => x.Ativo == blStatus);
}
if (!string.IsNullOrEmpty(TxtNomePessoa))
{
query = query.Where(x => x.NomePessoa.Contains(TxtNomePessoa));
}
return(query.OrderBy(x => x.NomePessoa).ToList());
}
}
public Marketing IncluirMkt(Marketing mkt)
{
using (SmartBagEntities entities = new SmartBagEntities())
{
try
{
TBT_MARKETING m = new TBT_MARKETING();
m.Titulo = mkt.Titulo;
m.CodTipoMarketing = mkt.CodTipoMarketing;
m.Descricao = mkt.Descricao;
m.TipoArquivo = mkt.TipoArquivo;
m.NomeArquivo = mkt.NomeArquivo;
m.IndAtivo = mkt.Ativo ? 1 : 0;
m.CodMarca = mkt.CodMarca;
entities.TBT_MARKETING.Add(m);
entities.Entry(m).State = EntityState.Added;
entities.SaveChanges();
//TBT_MARKETING m2 = entities.TBT_MARKETING.Find((decimal)mkt.CodMarketing);
//m2.CodMarketing = m2.ID;
//entities.Entry(m2).State = EntityState.Modified;
//entities.SaveChanges();
return(GetMarketing((int)m.CodMarketing));
}
catch (Exception e)
{
return(null);
}
}
}
public List <Marketing> SearchMarketing(int?Status, int?CodTipoMarketing, string Descricao, string Titulo)
{
using (SmartBagEntities entities = new SmartBagEntities())
{
try
{
var query = (from mk in entities.TBT_MARKETING
join tpM in entities.TBT_TIPO_MARKETING
on mk.CodTipoMarketing equals tpM.CodTipoMarketing
join m in entities.TBT_MARCA
on mk.CodMarca equals m.CodMarca
select new Marketing
{
CodMarketing = (int)mk.CodMarketing,
CodTipoMarketing = (int)tpM.CodTipoMarketing,
TipoMarketing = tpM.Descricao,
CodMarca = m.CodMarca,
Marca = m.Descricao,
Titulo = mk.Titulo,
Descricao = mk.Descricao,
TipoArquivo = mk.TipoArquivo,
NomeArquivo = mk.NomeArquivo,
Ativo = mk.IndAtivo == 1,
Destaque = mk.IndDestaque == 1,
DataCadastro = mk.CtrlDataOperacao.Value
});
if (CodTipoMarketing != null)
{
int codMkt = CodTipoMarketing.Value;
query = query.Where(x => x.CodTipoMarketing == codMkt);
}
if (Status != null)
{
bool StAtivo = Status.Value == 1;
query = query.Where(x => x.Ativo == StAtivo);
}
if (!string.IsNullOrEmpty(Descricao))
{
query = query.Where(x => x.Descricao.Contains(Descricao));
}
if (!string.IsNullOrEmpty(Titulo))
{
query = query.Where(x => x.Titulo.Contains(Titulo));
}
return(query.ToList());
}
catch (Exception e)
{
throw e;
}
}
}
public static string GetParameter(string CodParametro)
{
using (SmartBagEntities entities = new SmartBagEntities())
{
try
{
string valor = (entities.AFV_PARAMETRO_SINCRONIZACAO.Where(x => x.CodParametro.Equals(CodParametro)).Select(x => x.Valor)).FirstOrDefault();
return(valor);
}
catch (Exception e)
{
throw e;
}
}
}
public Usuario GetUser(decimal CodUsuario)
{
using (SmartBagEntities entities = new SmartBagEntities())
{
var query = (from tbtu in entities.TBT_USUARIO.Where(x => x.CodUsuario == CodUsuario)
join tbtp in entities.TBT_PESSOA on tbtu.CodPessoa equals tbtp.CodPessoa
select new Usuario
{
CodUsuario = tbtu.CodUsuario,
Login = tbtu.Login,
Ativo = tbtu.IndAtivo == 1 ? true : false,
NomePessoa = tbtp.Nome,
CodPessoa = tbtp.CodPessoa
}).FirstOrDefault();
return(query);
}
}
public decimal?UserCreate(Usuario usr)
{
using (SmartBagEntities entities = new SmartBagEntities())
{
try
{
TBT_USUARIO newUser = new TBT_USUARIO();
newUser.IndAtivo = 1;
newUser.CodPessoa = usr.CodPessoa;
newUser.Login = usr.Login;
newUser.Senha = usr.Senha;
entities.TBT_USUARIO.Add(newUser);
entities.SaveChanges();
return(newUser.CodUsuario);
}
catch (Exception)
{
return(null);
}
}
}
public bool SaveEdit(Marketing mkt)
{
using (SmartBagEntities entities = new SmartBagEntities())
{
try
{
TBT_MARKETING m = entities.TBT_MARKETING.Find((decimal)mkt.CodMarketing);
m.Titulo = mkt.Titulo;
m.CodTipoMarketing = mkt.CodTipoMarketing;
m.Descricao = mkt.Descricao;
m.TipoArquivo = mkt.TipoArquivo;
m.NomeArquivo = mkt.NomeArquivo;
m.IndAtivo = mkt.Ativo ? 1 : 0;
m.CodMarca = mkt.CodMarca;
entities.Entry(m).State = EntityState.Modified;
entities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool UserEdit(Usuario usr)
{
using (SmartBagEntities entities = new SmartBagEntities())
{
try
{
TBT_USUARIO editedUser = entities.TBT_USUARIO.Where(x => x.CodUsuario == usr.CodUsuario).Select(x => x).FirstOrDefault();
editedUser.IndAtivo = usr.Ativo ? 1 : 0;
editedUser.CodPessoa = usr.CodPessoa;
editedUser.Login = usr.Login;
if (!string.IsNullOrEmpty(usr.Senha))
{
editedUser.Senha = usr.Senha;
}
entities.Entry(editedUser).State = EntityState.Modified;
entities.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public Marketing GetMarketing(int CodMarketing)
{
using (SmartBagEntities entities = new SmartBagEntities())
{
try
{
Marketing tBT_Marketing = (from mk in entities.TBT_MARKETING.Where(x => x.CodMarketing == CodMarketing)
join tpM in entities.TBT_TIPO_MARKETING
on mk.CodTipoMarketing equals tpM.CodTipoMarketing
join m in entities.TBT_MARCA
on mk.CodMarca equals m.CodMarca
select new Marketing
{
CodMarketing = (int)mk.CodMarketing,
CodTipoMarketing = (int)tpM.CodTipoMarketing,
TipoMarketing = tpM.Descricao,
CodMarca = m.CodMarca,
Marca = m.Descricao,
Titulo = mk.Titulo,
Descricao = mk.Descricao,
TipoArquivo = mk.TipoArquivo,
NomeArquivo = mk.NomeArquivo,
Ativo = mk.IndAtivo == 1,
Destaque = mk.IndDestaque == 1,
DataCadastro = mk.CtrlDataOperacao.Value
}).FirstOrDefault();
return(tBT_Marketing);
}
catch (Exception e)
{
throw e;
}
}
}
