public List <Complaint> GetAllComplaint()
{
ComplaintContext oCon = new ComplaintContext();
List <Complaint> complaintList = oCon.complaintDB.ToList <Complaint>();
return(complaintList);
}
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
ComplaintContext Con = new ComplaintContext();
string Role = "";
bool User = Con.Profile.Any(a => a.UserName == context.UserName && a.Password == context.Password);
if (User)
{
var UserRole = Con.Profile.Where(a => a.UserName == context.UserName).Select(a => new
{
RoleName = a.PTRef.Name
});
foreach (var r in UserRole)
{
Role = r.RoleName;
}
identity.AddClaim(new Claim(ClaimTypes.Role, Role));
identity.AddClaim(new Claim("username", context.UserName));
identity.AddClaim(new Claim(ClaimTypes.Name, context.UserName));
context.Validated(identity);
}
else
{
context.SetError("invalid_grant", "provided username and password is incorrect");
}
}
public List <Complaint> GetComplaintById(int _id)
{
ComplaintContext oCon = new ComplaintContext();
List <Complaint> complaintList = oCon.complaintDB.Where(a => a.userId == _id).ToList <Complaint>();
return(complaintList);
}
public User GetUserById(int _id)
{
ComplaintContext context = new ComplaintContext();
User _user = context.userDb.Find(_id);
return(_user);
}
public List <Complaint> LoadComplaintWithDetailsByProfileID(int ProfileID)
{
ComplaintContext Con = new ComplaintContext();
Complaint Comp = new Complaint();
List <Complaint> LiComplaint = new List <Complaint>();
var Data = Con.Complaint.Where(a => a.ProfileID == ProfileID).Select(a => new
{
ComplaintID = a.ID,
ComplaintTitle = a.Title,
ComplaintDesc = a.Description,
ComplaintEntryDate = a.EntryDate,
ComplaintType = a.CTRef.Name,
ComplaintStatus = a.CSRef.Name,
ComplaintUserName = a.ProfileRef.UserName
});
foreach (var a in Data)
{
Comp = new Complaint();
Comp.ID = a.ComplaintID;
Comp.Title = a.ComplaintTitle;
Comp.Description = a.ComplaintDesc;
Comp.EntryDate = a.ComplaintEntryDate;
Comp.ComplaintType = a.ComplaintType;
Comp.ComplaintStatus = a.ComplaintStatus;
Comp.UserName = a.ComplaintUserName;
LiComplaint.Add(Comp);
}
return(LiComplaint);
}
public List <User> GetAllUser()
{
ComplaintContext context = new ComplaintContext();
List <User> userList = context.userDb.ToList <User>();
return(userList);
}
public Profile LoadProfile(string UserName, string Password)
{
ComplaintContext Con = new ComplaintContext();
Profile P = new Profile();
P = Con.Profile.Where(a => a.UserName == UserName && a.Password == Password).FirstOrDefault();
return(P);
}
public Complaint LoadComplaintByComplaintID(int Complaintid)
{
ComplaintContext Con = new ComplaintContext();
Complaint obj = new Complaint();
obj = Con.Complaint.Where(a => a.ID == Complaintid).SingleOrDefault();
return(obj);
}
public void PostInsert(Complaint obj)
{
if (ModelState.IsValid)
{
ComplaintContext oCon = new ComplaintContext();
oCon.complaintDB.Add(obj);
oCon.SaveChanges();
}
}
public void UpdateComplaintStatus(int ComplaintID, int StatusID)
{
ComplaintContext Con = new ComplaintContext();
Complaint obj = new Complaint();
obj = Con.Complaint.Find(ComplaintID);
obj.ComplaintStatusID = StatusID;
Con.SaveChanges();
}
public User GetInfo(string sentEmail, string sentPassword)
{
ComplaintContext context = new ComplaintContext();
var query = from us in context.userDb
where us.email == sentEmail && us.password == sentPassword
select us;
var user = query.FirstOrDefault <User>();
User _user = user;
return(_user);
}
public void PostInsertAdmin(User obj)
{
obj.userType = 1;
if (ModelState.IsValid)
{
ComplaintContext oCon = new ComplaintContext();
oCon.userDb.Add(obj);
oCon.SaveChanges();
}
}
public void PostInsert(User user)
{
System.Diagnostics.Debugger.Break();
user.userType = 2;
if (ModelState.IsValid)
{
ComplaintContext oCon = new ComplaintContext();
oCon.userDb.Add(user);
oCon.SaveChanges();
}
}
protected override ValidationResult IsValid(object value, ValidationContext validationContext)
{
ComplaintContext Context = new ComplaintContext();
bool Validation = Context.Profile.Any(a => a.UserName == (string)value);
if (Validation)
{
return(new ValidationResult(base.ErrorMessage));
}
else
{
return(ValidationResult.Success);
}
}
public Complaint(ComplaintContext context)
{
_context = context;
}
public Generic()
{
con = new ComplaintContext();
table = con.Set <x>();
}
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, ComplaintContext dbContext)
{
app.Use(async(context, next) =>
{
await next();
if (context.Response.StatusCode == 404 &&
!Path.HasExtension(context.Request.Path.Value) &&
!context.Request.Path.Value.StartsWith("/api/"))
{
context.Request.Path = "/index.html";
await next();
}
});
AutoMapper.Mapper.Initialize(config =>
{
config.CreateMap <ComplaintViewModel, Complaint>().ReverseMap();
config.CreateMap <CitizenViewModel, Citizen>().ReverseMap();
});
app.UseMvcWithDefaultRoute();
app.UseDefaultFiles();
app.UseStaticFiles();
DbInitializer.Initialize(dbContext);
}
public ComplaintsController(ComplaintContext context)
{
_context = context;
}
public ComplaintRepository(ComplaintContext context)
{
_context = context;
}
