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