public ActionResult ForgotPassword(int id) { var dbcontext = new RegisterOwnersContext(); var user = dbcontext.Users.Single(e => e.Id == id); return(View("ForgotPassword", user)); }
public static bool Login(string UserName, string PassWord) { //. > var dbcontext = new RegisterOwnersContext(); return(dbcontext.Users.Any(e => e.Email == UserName && e.Password == PassWord)); }
public RegistrationUserData RegisterUser(User data) { try { var dbcontext = new RegisterOwnersContext(); dbcontext.Users.Add(data); dbcontext.SaveChanges(); string url = " <a href=http://registerownertest.apphb.com/Home/EmailVerification?Id=" + data.Id + ">" + "Verify Email" + "</a>"; SendEmail(data.Email, url); return(new RegistrationUserData { IsUserRegisterd = true, Message = "User Is Registered SuccessFully", ErrorException = null }); } catch (Exception ex) { return(new RegistrationUserData { IsUserRegisterd = false, Message = "Internal Server Error", ErrorException = ex }); } }
public dynamic UpdateUser(UserDto input) { try { var dbcontext = new RegisterOwnersContext(); var user = dbcontext.Users.Single(e => e.Id == input.Id); user.FirstName = input.FirstName; user.LastName = input.LastName; user.MobileNo = input.MobileNo; user.Dob = input.Dob; user.Adress = input.Adress; user.ZipCode = input.ZipCode; user.Place = input.Place; user.Country = input.Country; user.MobileNo = input.MobileNo; dbcontext.SaveChanges(); return(new { IsUpdated = true, }); } catch (Exception ex) { return(new { IsUpdated = false, ErrorException = ex }); } }
public dynamic ItemHistoryBySerialNo(DeleteItemHistoryInput[] input) { var dbcontext = new RegisterOwnersContext(); var inputRegNo = input[0].RegNo; return(dbcontext.ItemOwnerHistories.Where(e => e.RegNo == inputRegNo).ToList()); }
public bool VerifyEmail(int id) { try { var dbcontext = new RegisterOwnersContext(); var user = dbcontext.Users.Single(e => e.IsEmailVerified == null && e.Id == id); user.IsEmailVerified = true; dbcontext.SaveChanges(); return(true); } catch { return(false); } }
public dynamic ChangePassword(User input) { try { var dbcontext = new RegisterOwnersContext(); var user = dbcontext.Users.Single(e => e.IsEmailVerified == true && e.Id == input.Id); user.Password = input.Password; dbcontext.SaveChanges(); return(new { passwordChanged = true }); } catch { return(new { passwordChanged = false }); } }
public dynamic ForgotPassword(ForgotPasswordInput input) { // ForGot Pass try { var dbcontext = new RegisterOwnersContext(); var user = dbcontext.Users.Single(e => e.Email == input.Email); string url = " <a href=http://registerownertest.apphb.com/Home/ForgotPassword?Id=" + user.Id + ">" + "Forgot Password" + "</a>"; SendEmail(input.Email, url); return(new { emailSent = true }); } catch (Exception ex) { return(new { emailSent = false }); } }
public dynamic UpdateItem(Item input) { try { var dbcontext = new RegisterOwnersContext(); var itemToUpdate = dbcontext.Items.Single(e => e.Id == input.Id); itemToUpdate.Category = input.Category; itemToUpdate.Type = input.Type; itemToUpdate.Producer = input.Producer; itemToUpdate.Model = input.Model; itemToUpdate.ItemId = input.ItemId; itemToUpdate.ItemSerial = input.ItemSerial; itemToUpdate.OtherInfo = input.OtherInfo; itemToUpdate.DateofPurchase = input.DateofPurchase; itemToUpdate.BoolPlace = input.BoolPlace; itemToUpdate.BoolItem = input.BoolItem; itemToUpdate.BoolAdress = input.BoolAdress; itemToUpdate.BoolFirstName = input.BoolFirstName; itemToUpdate.BoolPhoneNo = input.BoolPhoneNo; itemToUpdate.BoolLastName = input.BoolLastName; itemToUpdate.BoolEmail = input.BoolEmail; itemToUpdate.BoolReceipt = input.BoolReceipt; dbcontext.SaveChanges(); return(new { IsUpdated = true, Message = "Updated SuccessFully", }); } catch (Exception ex) { return(new { IsUpdated = false, Message = "Error", ErrorException = ex }); }; }
public dynamic SignIn(User input) { var dbcontext = new RegisterOwnersContext(); var userEntity = dbcontext.Users.FirstOrDefault(e => e.Email == input.Email && e.Password == input.Password && e.IsEmailVerified == true); if (userEntity == null) { return new { IsSignedIn = false, //Message = "User Does Not Exist", Message = dbcontext.Users.FirstOrDefault(e => e.Email == input.Email && e.Password == input.Password) != null? "Verify Email": "User Does Not Exist" } } ; return(new { IsSignedIn = true, Message = "SuccessFully SignedIn", LogInResponse = Mapper.Map <User, UserDto>(userEntity) }); // return Mapper.Map<User, UserDto>(userEntity); }
public dynamic CleanRegistrationNumber(DeleteItemHistoryInput input) { try { var dbcontext = new RegisterOwnersContext(); var regNoSize = input.RegNo.Length; if (regNoSize == 1) { var regNo = dbcontext.BridgeRegNoItemsS1.Single(e => e.RegId == input.RegNoId); var listOfitemHistory = dbcontext.ItemOwnerHistories.Where(e => e.RegNo == input.RegNo).ToList(); if (listOfitemHistory.Count > 0) { listOfitemHistory.ForEach(e => { dbcontext.ItemOwnerHistories.Remove(e); }); } dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemsS1.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 2) { var regNo = dbcontext.BridgeRegNoItemS2.Single(e => e.RegId == input.RegNoId); var listOfitemHistory = dbcontext.ItemOwnerHistories.Where(e => e.RegNo == input.RegNo).ToList(); if (listOfitemHistory.Count > 0) { listOfitemHistory.ForEach(e => { dbcontext.ItemOwnerHistories.Remove(e); }); } dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemS2.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 3) { var regNo = dbcontext.BridgeRegNoItemsS3.Single(e => e.RegId == input.RegNoId); var listOfitemHistory = dbcontext.ItemOwnerHistories.Where(e => e.RegNo == input.RegNo).ToList(); if (listOfitemHistory.Count > 0) { listOfitemHistory.ForEach(e => { dbcontext.ItemOwnerHistories.Remove(e); }); } dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemsS3.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 4) { var regNo = dbcontext.BridgeRegNoItemsS4.Single(e => e.RegId == input.RegNoId); var listOfitemHistory = dbcontext.ItemOwnerHistories.Where(e => e.RegNo == input.RegNo).ToList(); if (listOfitemHistory.Count > 0) { listOfitemHistory.ForEach(e => { dbcontext.ItemOwnerHistories.Remove(e); }); } dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemsS4.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 5) { var regNo = dbcontext.BridgeRegNoItemsS5.Single(e => e.RegId == input.RegNoId); var listOfitemHistory = dbcontext.ItemOwnerHistories.Where(e => e.RegNo == input.RegNo).ToList(); if (listOfitemHistory.Count > 0) { listOfitemHistory.ForEach(e => { dbcontext.ItemOwnerHistories.Remove(e); }); } dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemsS5.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 6) { var regNo = dbcontext.BridgeRegNoItemsS6.Single(e => e.RegId == input.RegNoId); var listOfitemHistory = dbcontext.ItemOwnerHistories.Where(e => e.RegNo == input.RegNo).ToList(); if (listOfitemHistory.Count > 0) { listOfitemHistory.ForEach(e => { dbcontext.ItemOwnerHistories.Remove(e); }); } dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemsS6.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 7) { var regNo = dbcontext.BridgeRegNoItemsS7.Single(e => e.RegId == input.RegNoId); var listOfitemHistory = dbcontext.ItemOwnerHistories.Where(e => e.RegNo == input.RegNo).ToList(); if (listOfitemHistory.Count > 0) { listOfitemHistory.ForEach(e => { dbcontext.ItemOwnerHistories.Remove(e); }); } dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemsS7.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 8) { var regNo = dbcontext.BridgeRegNosItemS8.Single(e => e.RegId == input.RegNoId); var listOfitemHistory = dbcontext.ItemOwnerHistories.Where(e => e.RegNo == input.RegNo).ToList(); if (listOfitemHistory.Count > 0) { listOfitemHistory.ForEach(e => { dbcontext.ItemOwnerHistories.Remove(e); }); } dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNosItemS8.Remove(regNo); dbcontext.SaveChanges(); } return(new { IsCleaned = true, Message = "Record Deleted" }); } catch (Exception ex) { return(new { IsCleaned = false, Message = "Error", ErrorException = ex }); }; }
public dynamic DeleteItemHistory(DeleteItemHistoryInput input) { try { var dbcontext = new RegisterOwnersContext(); var regNoSize = input.RegNo.Length; if (regNoSize == 1) { var regNo = dbcontext.BridgeRegNoItemsS1.Single(e => e.RegId == input.RegNoId); dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemsS1.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 2) { var regNo = dbcontext.BridgeRegNoItemS2.Single(e => e.RegId == input.RegNoId); dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemS2.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 3) { var regNo = dbcontext.BridgeRegNoItemsS3.Single(e => e.RegId == input.RegNoId); dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemsS3.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 4) { var regNo = dbcontext.BridgeRegNoItemsS4.Single(e => e.RegId == input.RegNoId); dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemsS4.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 5) { var regNo = dbcontext.BridgeRegNoItemsS5.Single(e => e.RegId == input.RegNoId); dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemsS5.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 6) { var regNo = dbcontext.BridgeRegNoItemsS6.Single(e => e.RegId == input.RegNoId); dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemsS6.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 7) { var regNo = dbcontext.BridgeRegNoItemsS7.Single(e => e.RegId == input.RegNoId); dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNoItemsS7.Remove(regNo); dbcontext.SaveChanges(); } else if (regNoSize == 8) { var regNo = dbcontext.BridgeRegNosItemS8.Single(e => e.RegId == input.RegNoId); dbcontext.Items.Remove(regNo.Item); dbcontext.BridgeRegNosItemS8.Remove(regNo); dbcontext.SaveChanges(); } return(new { IsDeleted = true, Message = "Record Deleted" }); } catch (Exception ex) { return(new { IsDeleted = false, Message = "Error", ErrorException = ex }); }; }
public dynamic GetItemDetailsUsingByItemId(GetItemDetailsUsingItemIdInput[] input) { RegisterOwnersContext dbcontext = new RegisterOwnersContext(); var inputItemId = input[0].ItemId; var listOfData = dbcontext.Items.Where(e => e.ItemId == inputItemId).Select( e => new GetItemDetailsUsingSerialNoOutput() { Item = e, UserId = null, User = null } ).ToList(); listOfData.ForEach(e => { if (e.Item.BridgeRegNoItemsS1.Count > 0) { var user = e.Item.BridgeRegNoItemsS1.First().RegistrationNoS1.User; //e.User = Mapper.Map<User, UserDto>(user); e.User = dbcontext.Users.AsNoTracking().Single(u => u.Id == user.Id); e.UserId = user.Id; } else if (e.Item.BridgeRegNoItemS2.Count > 0) { var user = e.Item.BridgeRegNoItemS2.First().RegistrationNoS2.User; //e.User = Mapper.Map<User, UserDto>(user); //e.User = user; e.User = dbcontext.Users.AsNoTracking().Single(u => u.Id == user.Id); e.UserId = user.Id; } else if (e.Item.BridgeRegNoItemsS3.Count > 0) { var user = e.Item.BridgeRegNoItemsS3.First().RegistrationNoS3.User; //e.User = Mapper.Map<User, UserDto>(user); //e.User = user; e.User = dbcontext.Users.AsNoTracking().Single(u => u.Id == user.Id); e.UserId = user.Id; } else if (e.Item.BridgeRegNoItemsS4.Count > 0) { var user = e.Item.BridgeRegNoItemsS4.First().RegistrationNoS4.User; //e.User = Mapper.Map<User, UserDto>(user); //e.User = Mapper.Map<User, UserDto>(user); //e.User = user; e.User = dbcontext.Users.AsNoTracking().Single(u => u.Id == user.Id); e.UserId = user.Id; } else if (e.Item.BridgeRegNoItemsS5.Count > 0) { var user = e.Item.BridgeRegNoItemsS5.First().RegistrationNoS5.User; //e.User = Mapper.Map<User, UserDto>(user); //e.User = Mapper.Map<User, UserDto>(user); //e.User = user; e.User = dbcontext.Users.AsNoTracking().Single(u => u.Id == user.Id); e.UserId = user.Id; } else if (e.Item.BridgeRegNoItemsS6.Count > 0) { var user = e.Item.BridgeRegNoItemsS6.First().RegistrationNoS6.User; //e.User = Mapper.Map<User, UserDto>(user); //e.User = Mapper.Map<User, UserDto>(user); //e.User = user; e.User = dbcontext.Users.AsNoTracking().Single(u => u.Id == user.Id); e.UserId = user.Id; } else if (e.Item.BridgeRegNoItemsS7.Count > 0) { var user = e.Item.BridgeRegNoItemsS7.First().RegistrationNoS7.User; //e.User = Mapper.Map<User, UserDto>(user); //e.User = Mapper.Map<User, UserDto>(user); //e.User = user; e.User = dbcontext.Users.AsNoTracking().Single(u => u.Id == user.Id); e.UserId = user.Id; } else if (e.Item.BridgeRegNosItemS8.Count > 0) { var user = e.Item.BridgeRegNosItemS8.First().RegistrationNoS8.User; //e.User = Mapper.Map<User, UserDto>(user); //e.User = Mapper.Map<User, UserDto>(user); //e.User = user; e.User = dbcontext.Users.AsNoTracking().Single(u => u.Id == user.Id); e.UserId = user.Id; } }); return(listOfData.Select(e => new { UserId = e.UserId, UserDto = Mapper.Map <User, UserDto>(e.User), Item = Mapper.Map <Item, ItemDto>(e.Item) }).ToList()); }
public dynamic GetItemDetailsUsingRegistrationNo(GetItemDetailsUsingRegistrationNoInput input) { RegisterOwnersContext dbcontext = new RegisterOwnersContext(); Item item = null; //var currentRegistrationNo = dbcontext.CurrentRegistrationNoes.First(); if (input.RegNo.Length == 1) { var regNo = dbcontext.RegistrationNoS1.SingleOrDefault(e => e.RegNo == input.RegNo); var itemToCheck = regNo.BridgeRegNoItemsS1.FirstOrDefault(); if (itemToCheck != null) { item = dbcontext.Items.SingleOrDefault(e => e.Id == itemToCheck.ItemId); } return(new { UserId = regNo.userId, Item = item != null?Mapper.Map <Item, ItemDto>(item) : null, User = Mapper.Map <User, UserDto>(regNo.User), }); } else if (input.RegNo.Length == 2) { var regNo = dbcontext.RegistrationNoS2.SingleOrDefault(e => e.RegNo == input.RegNo); var itemToCheck = regNo.BridgeRegNoItemS2.FirstOrDefault(); if (itemToCheck != null) { item = dbcontext.Items.SingleOrDefault(e => e.Id == itemToCheck.ItemId); } return(new { UserId = regNo.userId, Item = item != null?Mapper.Map <Item, ItemDto>(item) : null, User = Mapper.Map <User, UserDto>(regNo.User), }); } else if (input.RegNo.Length == 3) { var regNo = dbcontext.RegistrationNoS3.SingleOrDefault(e => e.RegNo == input.RegNo); var itemToCheck = regNo.BridgeRegNoItemsS3.FirstOrDefault(); if (itemToCheck != null) { item = dbcontext.Items.SingleOrDefault(e => e.Id == itemToCheck.ItemId); } return(new { UserId = regNo.userId, Item = item != null?Mapper.Map <Item, ItemDto>(item) : null, User = Mapper.Map <User, UserDto>(regNo.User), }); } else if (input.RegNo.Length == 4) { var regNo = dbcontext.RegistrationNoS4.SingleOrDefault(e => e.RegNo == input.RegNo); var itemToCheck = regNo.BridgeRegNoItemsS4.FirstOrDefault(); if (itemToCheck != null) { item = dbcontext.Items.SingleOrDefault(e => e.Id == itemToCheck.ItemId); } return(new { UserId = regNo.userId, Item = item != null?Mapper.Map <Item, ItemDto>(item) : null, User = Mapper.Map <User, UserDto>(regNo.User), }); } else if (input.RegNo.Length == 5) { var regNo = dbcontext.RegistrationNoS5.SingleOrDefault(e => e.RegNo == input.RegNo); var itemToCheck = regNo.BridgeRegNoItemsS5.FirstOrDefault(); if (itemToCheck != null) { item = dbcontext.Items.SingleOrDefault(e => e.Id == itemToCheck.ItemId); } return(new { UserId = regNo.userId, Item = item != null?Mapper.Map <Item, ItemDto>(item) : null, User = Mapper.Map <User, UserDto>(regNo.User), }); } else if (input.RegNo.Length == 6) { var regNo = dbcontext.RegistrationNoS6.SingleOrDefault(e => e.RegNo == input.RegNo); var itemToCheck = regNo.BridgeRegNoItemsS6.FirstOrDefault(); if (itemToCheck != null) { item = dbcontext.Items.SingleOrDefault(e => e.Id == itemToCheck.ItemId); } return(new { UserId = regNo.userId, Item = item != null?Mapper.Map <Item, ItemDto>(item) : null, User = Mapper.Map <User, UserDto>(regNo.User), }); } else if (input.RegNo.Length == 7) { var regNo = dbcontext.RegistrationNoS7.SingleOrDefault(e => e.RegNo == input.RegNo); var itemToCheck = regNo.BridgeRegNoItemsS7.FirstOrDefault(); if (itemToCheck != null) { item = dbcontext.Items.SingleOrDefault(e => e.Id == itemToCheck.ItemId); } return(new { UserId = regNo.userId, Item = item != null?Mapper.Map <Item, ItemDto>(item) : null, User = Mapper.Map <User, UserDto>(regNo.User), }); } else if (input.RegNo.Length == 8) { var regNo = dbcontext.RegistrationNoS8.SingleOrDefault(e => e.RegNo == input.RegNo); var itemToCheck = regNo.BridgeRegNosItemS8.FirstOrDefault(); if (itemToCheck != null) { item = dbcontext.Items.SingleOrDefault(e => e.Id == itemToCheck.ItemId); } return(new { UserId = regNo.userId, Item = item != null?Mapper.Map <Item, ItemDto>(item) : null, User = Mapper.Map <User, UserDto>(regNo.User), }); } return(null); }
public dynamic RegisterItem(ItemDto input) { try { RegisterOwnersContext dbcontext = new RegisterOwnersContext(); var item = Mapper.Map <ItemDto, Item>(input); var itemAdded = dbcontext.Items.Add(item); // Adding Data In BridgeTable if (input.RegNoSize == 1) { dbcontext.BridgeRegNoItemsS1.Add(new BridgeRegNoItemsS1() { RegId = input.RegNoId, ItemId = itemAdded.Id, }); } else if (input.RegNoSize == 2) { dbcontext.BridgeRegNoItemS2.Add(new BridgeRegNoItemS2() { RegId = input.RegNoId, ItemId = itemAdded.Id, }); } else if (input.RegNoSize == 3) { dbcontext.BridgeRegNoItemsS3.Add(new BridgeRegNoItemsS3() { RegId = input.RegNoId, ItemId = itemAdded.Id, }); } else if (input.RegNoSize == 4) { dbcontext.BridgeRegNoItemsS4.Add(new BridgeRegNoItemsS4() { RegId = input.RegNoId, ItemId = itemAdded.Id, }); } else if (input.RegNoSize == 5) { dbcontext.BridgeRegNoItemsS5.Add(new BridgeRegNoItemsS5() { RegId = input.RegNoId, ItemId = itemAdded.Id, }); } else if (input.RegNoSize == 6) { dbcontext.BridgeRegNoItemsS6.Add(new BridgeRegNoItemsS6() { RegId = input.RegNoId, ItemId = itemAdded.Id, }); } else if (input.RegNoSize == 7) { dbcontext.BridgeRegNoItemsS7.Add(new BridgeRegNoItemsS7() { RegId = input.RegNoId, ItemId = itemAdded.Id, }); } else if (input.RegNoSize == 8) { dbcontext.BridgeRegNosItemS8.Add(new BridgeRegNosItemS8() { RegId = input.RegNoId, ItemId = itemAdded.Id, }); } dbcontext.SaveChanges(); return(new { IsItemRegistered = true, ItemId = itemAdded.Id }); } catch (Exception ex) { return(new { IsItemRegistered = false, ErrorException = ex }); } }