public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
using (var db = new EmeciEntities())
{
var q = (from r in db.Registro
join m in db.Medico on r.idRegistro equals m.IdRegistro
where
r.Emeci == context.UserName &&
r.clave == context.Password &&
r.Status == "V"
select new
{
r.Emeci,
m.Idmedico
}).FirstOrDefault();
if (q != null)
{
context.Response.Headers.Add("Access-Control-Expose-Headers", new[] { "dId" });
context.Response.Headers.Add("dId", new[] { q.Idmedico.ToString() });
identity.AddClaim(new Claim(ClaimTypes.Role, "User"));
identity.AddClaim(new Claim(ClaimTypes.Name, q.Emeci));
identity.AddClaim(new Claim("LoggedOn", DateTime.Now.ToString()));
await Task.Run(() => context.Validated(identity));
}
else
{
context.SetError("Wrong credentials", "Provided username or password is incorrect");
}
return;
}
}
void SendEmail(string Reference)
{
using (EmeciEntities DB = new EmeciEntities())
{
var x = (from n in DB.NewMembership
where n.Reference == Reference
select n).FirstOrDefault();
if (x != null)
{
MembershipModel.MembershipType MembershipT = MembershipModel.MembershipType.NewFile;
string Subject = string.Empty;
if (!string.IsNullOrEmpty(x.EMECI))
{
Subject = "Renovación expediente";
MembershipT = MembershipModel.MembershipType.Renewal;
}
else
{
Subject = "Nuevo expediente";
}
var Email = new EmailMembership
{
To = x.Email,
Subject = Subject,
Name = x.Name,
EMECI = x.EMECI,
MembershipT = MembershipT
};
Email.Send();
}
}
}
bool CheckStatusTransaction(string Reference)
{
using (EmeciEntities DB = new EmeciEntities())
{
var Row = (from x in DB.NewMembership
where x.Reference == Reference
select new { x.Status }).FirstOrDefault();
if (Row != null)
{
return((int)StatusT.Confirmado == Row.Status.Value);
}
}
return(false);
}
public void UpdateTransaction(StatusT StatusTransaction, string Reference,
string ReferenceBank, string PaymentMethod)
{
using (EmeciEntities DB = new EmeciEntities())
{
NewMembership Membership = (from x in DB.NewMembership
where x.Reference == Reference
select x).First();
if (Membership != null)
{
Membership.ReferenceBank = ReferenceBank;
Membership.Status = (int)StatusTransaction;
Membership.PaymentMethod = PaymentMethod;
try
{
DB.SaveChanges();
}
catch (Exception) { }
}
}
}
public ActionResult Membership(MembershipModel Model)
{
switch (Model.Type)
{
case MembershipModel.MembershipType.NewFile:
if (!string.IsNullOrEmpty(Model.Name) && !string.IsNullOrEmpty(Model.Phone) &&
!string.IsNullOrEmpty(Model.Email))
{
TempData["Membership"] = Model;
return(RedirectToAction("PayUReq", "PayU"));
}
break;
case MembershipModel.MembershipType.Renewal:
if (!string.IsNullOrEmpty(Model.EMECI))
{
using (EmeciEntities DB = new EmeciEntities())
{
var x = (from r in DB.Registro
where r.Emeci == Model.EMECI
select new { r.Nombre, r.Apellido, r.Emails, r.Telefono }).FirstOrDefault();
if (x != null)
{
Model.Name = $"{x.Nombre} {x.Apellido}";
Model.Phone = x.Telefono;
Model.Email = x.Emails.Split(',')[0];
TempData["Membership"] = Model;
return(RedirectToAction("PayUReq", "PayU"));
}
else
{
Model.Error = "Número de tarjeta no encontrado";
}
}
}
break;
}
return(View(Model));
}
public void AddTransaction(MembershipModel Model, string Reference)
{
using (EmeciEntities DB = new EmeciEntities())
{
DB.NewMembership.Add(new NewMembership()
{
Name = Model.Name,
Phone = Model.Phone,
Email = Model.Email,
C_Date = DateTime.Now,
Reference = Reference,
Status = (int)StatusT.Proceso,
EMECI = Model.EMECI
});
try
{
DB.SaveChanges();
}
catch (Exception) { }
}
}
