public async Task <ApiResponse> Login(TblUserMaster objuser) { var loginDetail = await _context.TblUserMaster.Where(i => i.Email == objuser.Email && i.Password == objuser.Password && i.Active == true && i.DeleteStatus == null).ToListAsync(); if (loginDetail.Count == 1) { var listGroupMaster = await _context.TblGroupMaster.ToListAsync(); var items = (from lu in loginDetail join lg in listGroupMaster on lu.UserTypeId equals lg.Id select new { emailId = lu.Email, userId = lu.Id, userName = lu.UserName, userTypeName = lg.GroupName, userTypeId = lu.UserTypeId }) .ToList(); var ApiResponse = await response.ApiResult("OK", items, "Data Found"); return(ApiResponse); } else { var ApiResponse = await response.ApiResult("OK", "", "Email/Password Wrong"); return(ApiResponse); } }
public async Task <IActionResult> PutTblUserMaster(long id, TblUserMaster tblUserMaster) { if (id != tblUserMaster.Id) { return(BadRequest()); } _context.Entry(tblUserMaster).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblUserMasterExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <TblUserMaster> > PostTblUserMaster(TblUserMaster tblUserMaster) { _context.TblUserMaster.Add(tblUserMaster); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTblUserMaster", new { id = tblUserMaster.Id }, tblUserMaster)); }