public async Task <ActionResult <Logindetails> > PostLogindetails(Logindetails logindetails)
{
_context.Logindetails.Add(logindetails);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetLogindetails", new { id = logindetails.LoginId }, logindetails));
}
public async Task <IActionResult> PutLogindetails(int id, Logindetails logindetails)
{
if (id != logindetails.LoginId)
{
return(BadRequest());
}
_context.Entry(logindetails).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LogindetailsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public OwnerDetails GetUser(Logindetails logindetails)
{
OwnerDetails ownerdetail = new OwnerDetails();
using (DbDataReader datareader = _ExamAcces.GetUser(logindetails))
{
ownerdetail = datareader.ToCustomEntity <OwnerDetails>();
return(ownerdetail);
}
}
public DbDataReader GetUser(Logindetails logindetails)
{
string procedure = "[dbo].[GetUser]";
List <DbParameter> DbParameter = new List <DbParameter>();
DbParameter.Add(new SqlParameter {
ParameterName = "@username", Value = logindetails.username, SqlDbType = SqlDbType.VarChar
});
DbParameter.Add(new SqlParameter {
ParameterName = "@password", Value = logindetails.password, SqlDbType = SqlDbType.VarChar
});
return(GetDataReader(1, procedure, DbParameter, CommandType.StoredProcedure));
}
public HttpResponseMessage post(Logindetails obj)
{
if (entities.tblUsers.Where(u => u.EmailId == obj.EmailId).FirstOrDefault() != null)
{
tblUser uobj = entities.tblUsers.Where(uo => uo.EmailId == obj.EmailId).FirstOrDefault();
if (obj.Password == uobj.Password)
{
obj.UserType = "admin";
return Request.CreateResponse<Logindetails>(HttpStatusCode.OK, obj);
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, "incorrect password");
}
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, "you are not authorized");
}
}
public IActionResult GetUser(Logindetails logindetails)
{
return(Ok(_ExamOrchetration.GetUser(logindetails)));
}
public OwnerDetails GetUser(Logindetails logindetails)
{
return(_ExamRepository.GetUser(logindetails));
}
public HttpResponseMessage PosttblUser(Logindetails obj)
{
var ff = db.tblFarmers.Where(f => f.fEmailId == obj.EmailId).FirstOrDefault();
var bb = db.tblBidders.Where(b => b.bEmailId == obj.EmailId).FirstOrDefault();
if (ff != null || bb != null)
{
if (db.tblUsers.Where(u => u.EmailId == obj.EmailId).FirstOrDefault() != null)
{
tblUser uobj = db.tblUsers.Where(uo => uo.EmailId == obj.EmailId).FirstOrDefault();
if (obj.Password == Pass.ConvertToDecrypt(uobj.Password))
{
if (uobj.fId != null)
{
obj.fId = (int)uobj.fId;
var x = db.tblFarmers.Where(f => f.fId == obj.fId).FirstOrDefault();
obj.Username = x.fUserName;
obj.UserType = "Farmer";
}
if (uobj.bId != null)
{
obj.bId = (int)uobj.bId;
var y = db.tblBidders.Where(b => b.bId == obj.bId).FirstOrDefault();
obj.Username = y.bUserName;
obj.UserType = "Bidder";
}
return(Request.CreateResponse <Logindetails>(HttpStatusCode.OK, obj));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Incorrect Password"));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "documents are not verified yet"));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "You are not registered"));
}
/*if (obj.EmailId != (db.tblUsers.Select(f => f.EmailId).FirstOrDefault()))
* {
* if (obj.UserType == "farmer")
* {
* var fobj = db.tblFarmers.Where(f => f.fEmailId == obj.EmailId).FirstOrDefault();
* if (fobj != null)
* {
* if (fobj.fPassword == obj.Password)
* {
*
* obj.fId = fobj.fId;
*
* //obj.UserType = "farmer";
* //db.tblUsers.Add(obj);
* //db.SaveChanges();
*
* }
* else
* {
* return Request.CreateErrorResponse(HttpStatusCode.NotFound, "Incorrect Password");
* }
* }
* else
* {
* return Request.CreateErrorResponse(HttpStatusCode.NotFound, "You are not Registered");
* }
*
* }
* else if (obj.UserType == "bidder")
* {
* var bobj = db.tblBidders.Where(b => b.bEmailId == obj.EmailId).FirstOrDefault();
* if (bobj != null)
* {
* if (bobj.bPassword == obj.Password)
* {
*
* obj.fId = bobj.bId;
* obj.Password = bobj.bPassword;
* obj.EmailId = bobj.bEmailId;
* obj.UserType = "bidder";
* db.tblUsers.Add(obj);
* db.SaveChanges();
* return Request.CreateResponse<tblUser>(HttpStatusCode.OK, obj);
* }
* else
* {
* return Request.CreateErrorResponse(HttpStatusCode.NotFound, "Incorrect Password");
* }
* }
* else
* {
* return Request.CreateErrorResponse(HttpStatusCode.NotFound, "You are not Registered");
* }
*
* }
* else
* {
* return Request.CreateErrorResponse(HttpStatusCode.NotFound, "usertype is required");
* }
* }
* else
* {
* return Request.CreateErrorResponse(HttpStatusCode.MethodNotAllowed, "user already exists");
* }
* return Request.CreateResponse<tblUser>(HttpStatusCode.OK, obj);*/
}
