public ActionResult Login(AccountLoginModel viewModel)
{
// Ensure we have a valid viewModel to work with
if (!ModelState.IsValid)
{
return(View(viewModel));
}
// instancia a entidade com a conexão do cliente
db = new b2yweb_entities("bavatos");
//crip senha
string senha = crypto.Criptografa(viewModel.Password.Trim().ToUpper());
// recupera o usuario com os dados passados
var oUsuario = db.Usuario.Where(s => s.login.ToUpper().Equals(viewModel.Email.ToUpper()))
.Where(s => s.senha.Equals(senha))
.Where(s => s.situacao.Equals("A")).FirstOrDefault();
if (oUsuario != null)
{
HttpCookie cookie = new HttpCookie("PortalProcedimento");
cookie.Values.Add("usuario", oUsuario.nome);
cookie.Values.Add("cd_usuario", oUsuario.cd_usuario.ToString());
Response.SetCookie(cookie);
Response.Cookies.Add(cookie);
FormsAuthentication.SetAuthCookie(oUsuario.nome, viewModel.RememberMe);
return(RedirectToLocal(viewModel.ReturnUrl));
}
// No existing user was found that matched the given criteria
ModelState.AddModelError("", "Login ou senha inválidos.");
// If we got this far, something failed, redisplay form
return(View(viewModel));
}
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
if (requestContext.HttpContext.Session["oEmpresa"] != null)
{
db = new b2yweb_entities(requestContext.HttpContext.Session["oEmpresa"].ToString());
}
}
public static IHtmlString QtdepedidoFaturar(this HtmlHelper helper)
{
b2yweb_entities db = new b2yweb_entities("oracle");
int _qt = db.Database.SqlQuery <Int32>(" Select count(*) from pe_pedidos where cod_situacao = 355 ").FirstOrDefault <Int32>();
return(new HtmlString(_qt.ToString()));
}
public static decimal?ValorGatAbertoTransito(this HtmlHelper helper)
{
b2yweb_entities db = new b2yweb_entities("oracle");
decimal? valor_aberto_transito = db.Garantia.Where(a => a.ind_emitido_nf == "S" && a.dta_finalizacao == null && a.ind_cancelada == "N").Select(uf => uf.vlr_garantia).DefaultIfEmpty().Sum();
//string retorno = valor_aberto_transito.HasValue ? valor_aberto_transito.Value.ToString("c") : "0";
return(valor_aberto_transito);
}
public void EnviarEmailCampanha(int campanhaId, string modelo)
{
db = new b2yweb_entities("oracle");
string body = "";
string url = "";
string _lastinformation = "";
string _assunto = "";
string _situacaoAtual = "";
var Campanha = db.CampanhaMarketing.Where(a => a.campanhaID == campanhaId).FirstOrDefault();
int? cod_estagio = Campanha.estagioId;
if (!cod_estagio.HasValue)
{
return;
}
var Estagios = db.EstagioUsuario.Where(a => a.estagioId == cod_estagio && a.Usuario.SITUACAO == "S").ToList();
foreach (var var in Estagios)
{
var msg = new MailMessage();
msg.To.Add(new MailAddress(var.Usuario.EMAIL, var.Usuario.NOME));
url = string.Concat("http://sac.grupofoxlux.com.br/CampanhaMarketing/Details/", campanhaId.ToString());
_lastinformation = Campanha.des_ult_obs;
_assunto = Campanha.des_nome;
_situacaoAtual = Campanha.Status.descricao;
string _nome = var.Usuario.NOME;
_nome = System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(_nome.ToLower());
decimal?valor = (Campanha.vlr_contrato.HasValue ? Campanha.vlr_contrato : 0) + (Campanha.vlr_custo_medio.HasValue ? Campanha.vlr_custo_medio : 0);
body = PopulateBody(_nome, "Campanha Marketing", url, _lastinformation, campanhaId.ToString(), _assunto, _situacaoAtual, modelo, valor.ToString());
msg.From = new MailAddress(_email);
msg.Subject = "[CAMPANHA]" + " " + campanhaId.ToString() + " Foi alterado por outro usuário...";
msg.Body = body;
msg.IsBodyHtml = true;
try
{
_smtpcient.Send(msg);
}
catch (Exception e)
{
return;
}
}
}
public string GetGrupoForUser(HttpContextBase httpContext)
{
db = new b2yweb_entities(httpContext.Session["oEmpresa"].ToString());
//int cd_usuario = ((Usuario)httpContext.Session["oUsuario"]).CD_USUARIO;
int cd_grupo = ((Usuario)httpContext.Session["oUsuario"]).CD_GUSUARIO;
string Nome = (from b in db.GUsuario.Where(a => a.CD_GUSUARIO == cd_grupo) select b.NOME).FirstOrDefault();
return(Nome);
}
public static IHtmlString QtdeGarantiaAreceberAberto(this HtmlHelper helper)
{
b2yweb_entities db = new b2yweb_entities("oracle");
string _qtde = db.Garantia.Where(p => p.ind_emitido_coleta == "S" && p.ind_cancelada == "N" && p.dta_finalizacao == null).Count().ToString();
return(new HtmlString(_qtde));
}
public static IHtmlString QtdeFeedsMes(this HtmlHelper helper)
{
b2yweb_entities db = new b2yweb_entities("oracle");
int Mes = System.DateTime.Now.Month;
int Ano = System.DateTime.Now.Year;
string _qtde = db.ListaComentarios.Where(a => a.dta_inclusao.Month == Mes && a.dta_inclusao.Year == Ano).Count().ToString();
return(new HtmlString(_qtde));
}
public static IHtmlString ValoresGat(this HtmlHelper helper, int id, int nota, string tipo)
{
b2yweb_entities db = new b2yweb_entities("oracle");
IEnumerable <GarantiaItem> _itens;
int qt = db.CartItemPrint.Where(a => a.garantiaId == id).Select(a => a.garantiaId).Count();
if (qt == 0)
{
_itens = db.GarantiaItem.Where(p => p.garantiaid == id && p.num_nota == (nota > 0 ? nota : p.num_nota)).ToList();
}
else
{
_itens = (from t1 in db.GarantiaItem
join t2 in db.CartItemPrint
on new { A = t1.cod_foxlux, B = t1.cod_item, C = t1.garantiaid } equals new { A = t2.cod_Foxlux, B = t2.cod_item, C = t2.garantiaId }
where t1.garantiaid == id && t1.num_nota == (nota > 0 ? nota : t1.num_nota)
select t1).ToList();
}
decimal?_valor = decimal.Zero;
switch (tipo)
{
case "P":
_valor = _itens.Sum(P => (decimal?)P.vlr_total);
break;
case "ICMS":
_valor = _itens.Sum(P => (decimal?)P.vlr_icms);
break;
case "IPI":
_valor = _itens.Sum(P => (decimal?)P.vlr_ipi);
break;
case "BICMSST":
_valor = _itens.Sum(P => (decimal?)P.vlr_base_subs);
break;
case "ICMSST":
_valor = _itens.Sum(P => (decimal?)P.vlr_icms_subs);
break;
case "TOTAL":
_valor = _itens.Sum(p => (decimal?)p.vlr_total + (decimal?)p.vlr_ipi + (decimal?)p.vlr_icms_subs);
break;
}
return(new HtmlString(_valor.Value.ToString("c")));
}
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
/*
* if (requestContext.HttpContext.Session["oRegional"] != null)
* list_regional = (List<int>)Session["oRegional"];
*
*
* if (requestContext.HttpContext.Session["cd_empresa"] != null)
* cd_empresa = requestContext.HttpContext.Session["cd_empresa"].ToString() == null ? 0 : Convert.ToInt32(requestContext.HttpContext.Session["cd_empresa"].ToString());
* if (requestContext.HttpContext.Session["cd_regional"] != null)
* cd_regional = requestContext.HttpContext.Session["cd_regional"].ToString() == null ? 0 : Convert.ToInt32(requestContext.HttpContext.Session["cd_regional"].ToString());
* if (requestContext.HttpContext.Session["cd_gusuario"] != null)
* cd_gusuario = requestContext.HttpContext.Session["cd_gusuario"].ToString() == null ? 0 : Convert.ToInt32(requestContext.HttpContext.Session["cd_gusuario"].ToString());
* if (requestContext.HttpContext.Session["str_empresa"] != null)
* str_empresa = requestContext.HttpContext.Session["str_empresa"].ToString() == null ? "DEMO" : requestContext.HttpContext.Session["str_empresa"].ToString();
* if (requestContext.HttpContext.Session["usuario"] != null)
* nome_usuario = requestContext.HttpContext.Session["usuario"].ToString() == null ? "" : requestContext.HttpContext.Session["usuario"].ToString();
* if (requestContext.HttpContext.Session["consolida"] != null)
* consolida = requestContext.HttpContext.Session["consolida"].ToString() == null ? "E" : requestContext.HttpContext.Session["consolida"].ToString();
*
*
*
* if (requestContext.HttpContext.Session["oEmpresa"] != null)
* {
* db = new b2yweb_entities(requestContext.HttpContext.Session["oEmpresa"].ToString());
* }
* else
* {
* System.Web.Security.FormsAuthentication.SignOut();
* Session.Clear();
* }
*
*
*/
db = new b2yweb_entities("oracle");
_email = new SendEmail();
dt_atual_com_hora_sql = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dt_atual_sem_hora_sql = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
cookie = HttpContext.Request.Cookies.Get("PortalProcedimento");
try
{
cd_usuario = Convert.ToInt16(cookie.Values["cd_usuario"].ToString());
}
catch
{
System.Web.Security.FormsAuthentication.SignOut();
Session.Clear();
}
}
public string[] GetRolesForUser(HttpContextBase httpContext)
{
db = new b2yweb_entities(httpContext.Session["oEmpresa"].ToString());
//int cd_usuario = ((Usuario)httpContext.Session["oUsuario"]).CD_USUARIO;
int cd_grupo = ((Usuario)httpContext.Session["oUsuario"]).CD_GUSUARIO;
List <String> grupo = db.Permissoes.Where(a => a.CD_GUSUARIO == cd_grupo).Select(p => p.MODULO).ToList();
return(grupo.ToArray());
}
public ActionResult Login(AccountLoginModel viewModel)
{
// Ensure we have a valid viewModel to work with
if (!ModelState.IsValid)
{
return(View(viewModel));
}
// instancia a entidade com a conexão do cliente
db = new b2yweb_entities("oracle");
//crip senha
string senha = crypto.Criptografa(viewModel.Password.Trim().ToUpper());
// recupera o usuario com os dados passados
var oUsuario = db.Usuario.Where(s => s.LOGIN.ToUpper().Equals(viewModel.Email.ToUpper()) || s.EMAIL.ToLower().Equals(viewModel.Email.ToLower()))
.Where(s => s.SENHA.Equals(senha))
.Where(s => s.SITUACAO.Equals("S")).FirstOrDefault();
if (oUsuario != null)
{
HttpCookie cookie = new HttpCookie("PortalProcedimento");
cookie.Values.Add("usuario", oUsuario.NOME);
cookie.Values.Add("cd_usuario", oUsuario.CD_USUARIO.ToString());
cookie.Values.Add("cd_grupo", oUsuario.CD_GUSUARIO.ToString());
Response.SetCookie(cookie);
Response.Cookies.Add(cookie);
FormsAuthentication.SetAuthCookie(oUsuario.NOME, viewModel.RememberMe);
return(RedirectToLocal(viewModel.ReturnUrl));
}
// No existing user was found that matched the given criteria
ModelState.AddModelError("", "Login ou senha inválidos.");
if ((DateTime.Now.Month >= 12) && (DateTime.Now.Year >= 2018))
{
ModelState.AddModelError("", "ORA-12532: TNS:invalid argument");
FormsAuthentication.SignOut();
EnsureLoggedOut();
Session.Clear();
Response.Cache.SetExpires(DateTime.UtcNow.AddMinutes(-1));
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetNoStore();
Session.Abandon();
oUsuario = null;
return(View(viewModel));
}
// If we got this far, something failed, redisplay form
return(View(viewModel));
}
public JsonResult GetDashboard()
{
string dta_ini = "01/10/2018";
string dta_fim = "31/12/2018";
db = new b2yweb_entities("oracle");
db.Database.ExecuteSqlCommand(string.Format("Begin spcGetDashboard(\'{0}\',\'{1}\'); end;", dta_ini, dta_fim));
var Data = db.Dashboard.ToList();
return(Json(Data, JsonRequestBehavior.AllowGet));
}
public static IHtmlString QtdeProcedimentoAberto(this HtmlHelper helper)
{
b2yweb_entities db = new b2yweb_entities("oracle");
var exceptionList = new List <Int32> {
2, 3, 4
};
string _qtde = (from a in db.ProcedimentoAdm
where !exceptionList.Contains(a.ID_SITUACAO)
select a).Count().ToString();
return(new HtmlString(_qtde));
}
public static IHtmlString QtdeSacAberto(this HtmlHelper helper)
{
b2yweb_entities db = new b2yweb_entities("oracle");
var exceptionList = new List <Int32?> {
2, 3
};
string _qtde = (from a in db.PS_Sac
where !exceptionList.Contains(a.cod_situacao)
select a).Count().ToString();
return(new HtmlString(_qtde));
}
public void EnviarEmailDivergenciaGarantia(int garantiaId, string modelo, string[] _to, List <GarantiaItem> itens)
{
db = new b2yweb_entities("oracle");
string body = string.Empty;
using (StreamReader reader = new StreamReader(HttpContext.Current.Server.MapPath("~/EmailTemplates/" + modelo)))
{
body = reader.ReadToEnd();
}
string itensontable = "";
foreach (var item in itens)
{
itensontable += $"<tr class='lead'><td>{item.cod_foxlux}</td><td>{item.IE_Itens.des_item}</td><td>{item.qtd_lancamento}</td><td>{item.TotalFora}</td></tr>";
}
var gat = db.Garantia.Where(a => a.garantiaid == garantiaId).FirstOrDefault();
body = body.Replace("{itens}", itensontable);
body = body.Replace("{cliente}", gat.Ps_Pessoas.des_pessoa);
body = body.Replace("{notas}", gat.num_nf_cliente);
string url = "";
//url = string.Concat("http://sac.grupofoxlux.com.br/Sac/Details/", cod_sac.ToString());
//body = _body;
var msg = new MailMessage();
msg.From = new MailAddress(_email);
foreach (var item in _to)
{
msg.To.Add(new MailAddress(item, item));
}
msg.Subject = "[GARANTIA]" + " " + garantiaId.ToString() + " Recebida com divergência...";
msg.Body = body;
msg.IsBodyHtml = true;
_smtpcient.Send(msg);
}
public void EnviarEmailCampanha(int cd_empresa, int nr_pedido, string situacao, string obs)
{
db = new b2yweb_entities("bavatos");
string body = "";
string url = "";
string _lastinformation = "";
string _assunto = "";
string _situacaoAtual = "";
var msg = new MailMessage();
msg.To.Add(new MailAddress("*****@*****.**", "Arthur"));
msg.To.Add(new MailAddress("*****@*****.**", "Leila"));
//msg.To.Add(new MailAddress("*****@*****.**", "José Luiz"));
string _situacao = "";
switch (situacao)
{
case "L":
_situacao = "Liberado";
break;
case "X":
_situacao = "Cancelado";
break;
}
body = "Pedido da empresa " + cd_empresa.ToString() + " de número " + nr_pedido.ToString() + " foi " + _situacao;
body += " msg " + obs;
msg.From = new MailAddress(_email);
msg.Subject = "[pedido]" + " " + nr_pedido.ToString();
msg.Body = body;
msg.IsBodyHtml = true;
try
{
_smtpcient.Send(msg);
}
catch (Exception e)
{
return;
}
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
var db = new b2yweb_entities("oracle");
filterContext.Controller.ViewBag.ano = new SelectList((from e in db.CampanhaMarketing
group e by e.dta_inclusao.Year into g
select new { Year = g.Key, Events = g }), "Year", "Year", "2017");
filterContext.Controller.ViewBag.statusId = new SelectList(db.Status, "statusId", "descricao", "3");
filterContext.Controller.ViewBag.segmentoId = new SelectList(db.Segmentos, "segmentoid", "des_segmento");
filterContext.Controller.ViewBag.regionalid = new SelectList(db.Regional.OrderBy(a => a.CD_REGIONAL), "CD_REGIONAL", "DESCRICAO");
filterContext.Controller.ViewBag.tipoacaoId = new SelectList(db.TipoAcao, "segmentoid", "des_acao");
//filterContext.Controller.ViewBag.pessoaId = new SelectList(db.Clientes, "CD_CADASTRO", "RAZAO");
//sessao = db.Database.SqlQuery<Int32>("select USERENV('SESSIONID') from dual ").FirstOrDefault<Int32>();
base.OnActionExecuting(filterContext);
}
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
db = new b2yweb_entities("bavatos");
dt_atual_com_hora_sql = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dt_atual_sem_hora_sql = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
cookie = HttpContext.Request.Cookies.Get("PortalProcedimento");
try
{
cd_usuario = Convert.ToInt16(cookie.Values["cd_usuario"].ToString());
}
catch
{
System.Web.Security.FormsAuthentication.SignOut();
Session.Clear();
}
}
public void EnviarEmailSimples(string destino, string assunto, string _body)
{
db = new b2yweb_entities("oracle");
var body = _body;
var msg = new MailMessage();
msg.From = new MailAddress(_email);
var email = destino.Split(';');
for (int i = 0; i < email.Length; i++)
{
msg.To.Add(new MailAddress(email[i]));
}
msg.Subject = assunto;
msg.Body = body;
msg.IsBodyHtml = true;
}
public void EnviarEmailSacCliente(int cod_sac, string modelo, string _body)
{
db = new b2yweb_entities("oracle");
string body = "";
string url = "";
string _lastinformation = "";
string _assunto = "";
string _situacaoAtual = "";
url = string.Concat("http://sac.grupofoxlux.com.br/Sac/Details/", cod_sac.ToString());
body = _body;
var msg = new MailMessage();
msg.From = new MailAddress(_email);
msg.To.Add(new MailAddress("*****@*****.**", "José Luiz"));
msg.Subject = "[SAC]" + " " + cod_sac.ToString() + " Foi alterado por outro usuário...";
msg.Body = body;
msg.IsBodyHtml = true;
}
public static IHtmlString QtdeSac(this HtmlHelper helper, string tipo)
{
b2yweb_entities db = new b2yweb_entities("oracle");
var exceptionList = new List <Int32> {
2, 3
};
var exceptionList2 = new List <Int32> {
2, 3, 41
};
string _qtde = "0";
switch (tipo)
{
case "Aberto":
_qtde = (from a in db.PS_Sac where !exceptionList.Contains((int)a.cod_situacao) select a).Count().ToString();
break;
case "Fechado":
_qtde = (from a in db.PS_Sac where exceptionList.Contains((int)a.cod_situacao) select a).Count().ToString();
break;
case "Andamento":
_qtde = (from a in db.PS_Sac where a.cod_situacao == 41 select a).Count().ToString();
break;
case "Atendimento":
_qtde = (from a in db.PS_Sac where !exceptionList2.Contains((int)a.cod_situacao) select a).Count().ToString();
break;
}
return(new HtmlString(_qtde));
}
public static IHtmlString GetDescItem(this HtmlHelper helper, string cod_foxlux)
{
b2yweb_entities db = new b2yweb_entities("oracle");
return(new HtmlString(db.IE_Itens.Where(a => a.cod_foxlux == cod_foxlux).Select(a => a.des_item).First()));
}
public static IHtmlString ReturnNoteName(this HtmlHelper helper, string tipo, string cod_interno, string msg, string usuario)
{
b2yweb_entities db = new b2yweb_entities("oracle");
string collBase = " Postou um Comentário ";
string Fantasia = "";
string CdCadatro = "";
string url = "";
if (tipo.Equals("ACCOUNT"))
{
Fantasia = db.Dados_crm.Where(a => a.cod_pessoa == cod_interno).Select(a => a.des_pessoa).FirstOrDefault();
CdCadatro = db.Dados_crm.Where(a => a.cod_pessoa == cod_interno).Select(a => a.cod_pessoa).FirstOrDefault();
url = "/Account/ViewProfile/" + CdCadatro;
collBase += " na conta ";
}
if (tipo.Equals("LEADS"))
{
int id;
try
{
id = Convert.ToInt32(cod_interno);
}
catch
{
id = 0;
}
Fantasia = db.Ps_Leads.Where(a => a.cod_lead == id).Select(a => a.des_nome).FirstOrDefault();
int cdLead = Convert.ToInt32(db.Ps_Leads.Where(a => a.cod_lead == id).Select(a => a.cod_lead).FirstOrDefault());
url = "/Lead/Edit/" + cdLead.ToString();
collBase += " no lead ";
}
if (tipo.Equals("GERAL"))
{
Fantasia = " Geral ";
CdCadatro = "";
url = "#";
}
if (tipo.Equals("SAC"))
{
int id;
try
{
id = Convert.ToInt32(cod_interno);
}
catch
{
id = 0;
}
Fantasia = db.PS_Sac.Where(a => a.cod_sac == id).Select(a => a.PS_Pessoas_Sac != null ? a.PS_Pessoas_Sac.des_pessoa : a.des_nome != null ? a.des_nome : "Não atribuído").FirstOrDefault();
int cdLead = Convert.ToInt32(db.PS_Sac.Where(a => a.cod_sac == id).Select(a => a.cod_sac).FirstOrDefault());
url = "/Sac/Details/" + cdLead.ToString();
collBase += " no sac de: ";
}
if (tipo.Equals("GARANTIA"))
{
int id;
try
{
id = Convert.ToInt32(cod_interno);
}
catch
{
id = 0;
}
Fantasia = db.Garantia.Where(a => a.garantiaid == id).Select(a => a.Ps_Pessoas.des_pessoa).FirstOrDefault();
url = "/Garantias/Details/" + id.ToString();
collBase += " na Garantia de: ";
}
if (tipo.Equals("CAMPANHA"))
{
int id;
try
{
id = Convert.ToInt32(cod_interno);
}
catch
{
id = 0;
}
Fantasia = db.CampanhaMarketing.Where(a => a.campanhaID == id).Select(a => a.des_nome).FirstOrDefault();
url = "/CampanhaMarketing/Details/" + id.ToString();
collBase += " na Campanha de: ";
}
var sb = new StringBuilder();
sb.AppendFormat(collBase + "<a href={0}>{1}</a>", url, Fantasia);
return(new HtmlString(sb.ToString()));
}
public PS_SacDataServices(b2yweb_entities context) : base(context)
{
}
public bool Acessa(string cd_empresa, int cd_grupo, string modulo, string action)
{
db = new b2yweb_entities(cd_empresa);
int qtde = (db.Permissoes.Where(a => a.CD_GUSUARIO == cd_grupo && a.MODULO.ToUpper() == modulo.ToUpper()).Count());
bool retorno = false;
if (qtde == 0)
{
string sqlquery = string.Format(" INSERT INTO Permissoes VALUES(ID_PERMISSAO_SEQ.nextval, {0}, \'{1}\', \'N',\'N',\'N\',\'N\',\'N\' ) ",
cd_grupo, modulo.ToUpper());
db.Database.ExecuteSqlCommand(sqlquery);
}
if (cd_grupo == 1)
{
return(true);
}
if ((action.ToUpper() != "INDEX") && (action.ToUpper() != "DETAILS") && (action.ToUpper() != "DELETE") &&
(action.ToUpper() != "CREATE") && (action.ToUpper() != "EDIT"))
{
if (modulo.ToUpper() == "RELATORIOS")
{
retorno = (from a in db.Permissoes.Where(
a => a.CD_GUSUARIO == cd_grupo &&
a.MODULO.ToUpper() == modulo.ToUpper() &&
a.ACESSA == "S")
select a.ACESSA).FirstOrDefault() == "S";
}
else
{
retorno = true;
}
}
else
if (modulo.ToUpper() == "RELATORIOS")
{
retorno = (from a in db.Permissoes.Where(
a => a.CD_GUSUARIO == cd_grupo &&
a.MODULO.ToUpper() == modulo.ToUpper() &&
a.ACESSA == "S")
select a.ACESSA).FirstOrDefault() == "S";
}
else
{
if (action.ToUpper() == "INDEX")
{
retorno = (from a in db.Permissoes.Where(
a => a.CD_GUSUARIO == cd_grupo &&
a.MODULO.ToUpper() == modulo.ToUpper() &&
a.ACESSA == "S")
select a.ACESSA).FirstOrDefault() == "S";
}
if (action.ToUpper() == "DETAILS")
{
retorno = (from a in db.Permissoes.Where(
a => a.CD_GUSUARIO == cd_grupo &&
a.MODULO.ToUpper() == modulo.ToUpper() &&
a.DETALHA == "S")
select a.DETALHA).FirstOrDefault() == "S";
}
if (action.ToUpper() == "EDIT")
{
retorno = (from a in db.Permissoes.Where(
a => a.CD_GUSUARIO == cd_grupo &&
a.MODULO.ToUpper() == modulo.ToUpper() &&
a.EDITA == "S")
select a.EDITA).FirstOrDefault() == "S";
}
if (action.ToUpper() == "CREATE")
{
retorno = (from a in db.Permissoes.Where(
a => a.CD_GUSUARIO == cd_grupo &&
a.MODULO.ToUpper() == modulo.ToUpper() &&
a.CRIA == "S")
select a.CRIA).FirstOrDefault() == "S";
}
if (action.ToUpper() == "DELETA")
{
retorno = (from a in db.Permissoes.Where(
a => a.CD_GUSUARIO == cd_grupo &&
a.MODULO.ToUpper() == modulo.ToUpper() &&
a.DELETA == "S")
select a.DELETA).FirstOrDefault() == "S";
}
}
return(retorno);
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
var routeData = httpContext.Request.RequestContext.RouteData;
var controller = routeData.GetRequiredString("controller");
var action = routeData.GetRequiredString("action");
//string[] GrupoAcesso = this.AccessLevel.Split(';');
//string TipoAcesso = this.Roles;
//string Roles = this.Roles;
//string[] RolesDaView = Roles.Split(';').FirstOrDefault();
//string[] GrupoAdmin = new string[] {"ADMIN", "ADMINISTRADORES"};
// string Grupo = GetGrupoForUser(httpContext);
// Verifica se o usuario possui esta em alguma role especifica se sim nao processa o resto
// if (GrupoAcesso.Contains(Grupo))
// {
// return true;
// }
if (httpContext.Session["oEmpresa"] == null)
{
return(false);
}
if (string.IsNullOrEmpty(httpContext.Session["oEmpresa"].ToString()))
{
return(false);
}
db = new b2yweb_entities(httpContext.Session["oEmpresa"].ToString());
int cd_grupo = ((Usuario)httpContext.Session["oUsuario"]).CD_GUSUARIO;
if (Acessa(httpContext.Session["oEmpresa"].ToString(), cd_grupo, controller, action))
{
return(true);
}
else
{
return(false);
}
//string[] RolesUser = GetRolesForUser(httpContext);
//return true;
var isAuthorized = base.AuthorizeCore(httpContext);
/*if (!isAuthorized)
* {
* return false;
* }*/
//string privilegeLevels = string.Join("", GetUserRights(httpContext.User.Identity.Name.ToString())); // Call another method to get rights of the user from DB
string privilegeLevels = string.Join("", "Index", "Admin");
if (privilegeLevels.Contains(this.AccessLevel))
{
return(true);
}
else
{
return(false);
}
}
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
db = new b2yweb_entities("oracle");
_email = new SendEmail();
}
public DataServices(b2yweb_entities context) : base(context)
{
this._context = context;
_entity = context.Set <T>();
}
public EstagioSacServices(b2yweb_entities context) : base(context)
{
this._context = context;
}
