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
});
}
}
