public ActionResult saveProfile(AccIndexer form)
{
if (!ModelState.IsValid)
{
return(View("editU", form));
}
else
{
var profile = _content.Users.SingleOrDefault(m => m.Id.ToString() == form.ApplicationUser.Id.ToString()); //To load selected user details from the database.
if (profile == null) //To verify that profile exist
{
TempData["Error"] = "User Profile Does not exist."; //To display an error message to the user
return(View("editU", form));
}
else
{
//To update user details
profile.Branch = form.ApplicationUser.Branch;
profile.homeAddress = form.ApplicationUser.homeAddress;
profile.fullName = form.ApplicationUser.fullName;
profile.Email = form.ApplicationUser.Email;
profile.PhoneNumber = form.ApplicationUser.PhoneNumber;
_content.SaveChanges(); //To save update changes to database
}
}
TempData["Success"] = "Update Successful";
return(RedirectToAction("Index", "Users"));
}
public void DeleteAccount(int id)
{
var acctInDB = _content.customAccts.SingleOrDefault(m => m.id == id);
var savingsAcct = _content.acctIndex.SingleOrDefault(m => m.id == 1);
var currentAcct = _content.acctIndex.SingleOrDefault(m => m.id == 3);
if (acctInDB == null)
{
throw new HttpRequestException(HttpStatusCode.NotFound.ToString());
}
else
{
_content.customAccts.Remove(acctInDB);
if (acctInDB.customerAccountType == savingsAcct.accountName)
{
var interestAcct = _content.SIlog.SingleOrDefault(m => m.customerAccNumb == acctInDB.customerAccountNumber && m.customerAcctype == acctInDB.customerAccountType);
if (interestAcct != null)
{
_content.SIlog.Remove(interestAcct);
}
}
if (acctInDB.customerAccountType == currentAcct.accountName)
{
var interestAcct = _content.CIlog.SingleOrDefault(m => m.customerAccNumb == acctInDB.customerAccountNumber && m.customerAcctype == acctInDB.customerAccountType);
if (interestAcct != null)
{
_content.CIlog.Remove(interestAcct);
}
}
}
_content.SaveChanges();
}
public ActionResult CreateCategoryGL(AccIndexer form)
{
if (!ModelState.IsValid)
{
return(View("CreateSubCategory", form)); //Return View if model state is not valid with the form contents.
}
else
{
var checkName = _content.subCategory.SingleOrDefault(m => m.categoryName == form.SubCategory.categoryName);
if (checkName != null)
{
TempData["Error"] = "Sorry Category Name already exists in the database.";
return(View("CreateSubCategory", form));
}
_content.subCategory.Add(form.SubCategory); //Add new GL Category to database.
_content.SaveChanges(); //Save Changes to database.
TempData["Success"] = "GL Category Created Successfully!"; //Display Success message to user.
return(RedirectToAction("ViewSubGL", "Accounts")); //To return view back to the index page.
}
}
public void DeleteAccount(int id)
{
var acctInDB = _content.closedAcct.SingleOrDefault(m => m.id == id);
if (acctInDB == null)
{
throw new HttpRequestException(HttpStatusCode.NotFound.ToString());
}
else
{
_content.closedAcct.Remove(acctInDB);
}
_content.SaveChanges();
}
public void DeleteCustomer(int id)
{
var customerInDB = _content.custom.SingleOrDefault(m => m.id.ToString() == id.ToString());
var savingsAcct = _content.acctIndex.SingleOrDefault(m => m.id == 1);
var currentAcct = _content.acctIndex.SingleOrDefault(m => m.id == 3);
if (customerInDB == null)
{
throw new HttpRequestException(HttpStatusCode.NotFound.ToString());
}
else
{
var customerAccountsInDB = _content.customAccts.ToList();
foreach (var item in customerAccountsInDB)
{
if (item.CustomerID == customerInDB.id)
{
if (item.customerAccountType == savingsAcct.accountName)
{
var interestAcct = _content.SIlog.SingleOrDefault(m => m.customerAccNumb == item.customerAccountNumber && m.customerAcctype == item.customerAccountType);
if (interestAcct != null)
{
_content.SIlog.Remove(interestAcct);
}
}
if (item.customerAccountType == currentAcct.accountName)
{
var interestAcct = _content.CIlog.SingleOrDefault(m => m.customerAccNumb == item.customerAccountNumber && m.customerAcctype == item.customerAccountType);
if (interestAcct != null)
{
_content.CIlog.Remove(interestAcct);
}
}
_content.customAccts.Remove(item);
}
}
_content.custom.Remove(customerInDB);
}
_content.SaveChanges();
}
public ActionResult CreateProfilee(AccIndexer form)
{
if (!ModelState.IsValid)
{
TempData["Error"] = "Error Creating Customer Profile,pls check inputs and try again."; //Displaying Error message to the user.
return(RedirectToAction("CreateProfile", "Customers"));
}
else
{
var checkName = _content.custom.SingleOrDefault(m => m.customerName == form.Customer.customerName);
if (checkName != null)
{
TempData["Error"] = "Customer Name Already exists in the database."; //Displaying Error message to the user.
return(View("CreateProfile", form));
}
var checkEmail = _content.custom.SingleOrDefault(m => m.customerEmail == form.Customer.customerEmail); //To check that customer email doesn't already exist in the database.
if (checkEmail != null)
{
TempData["Error"] = "Customer Email Already exists in the database, pls use another email."; //Displaying Error message to the user.
return(View("CreateProfile", form));
}
//To add new customer profile to the database
_content.custom.Add(form.Customer);
_content.SaveChanges();
TempData["Success"] = "Customer Profile Created Successfully"; //Displaying Success message to the user.
return(RedirectToAction("Index", "Customers"));
}
}