/// <summary>
/// Saves the customer.
/// </summary>
/// <param name="customer">The customer.</param>
public void SaveCustomer(Customer customer)
{
var filter = Builders <CustomerDO> .Filter.Eq(r => r.ExternalId, customer.Id);
CustomerDO customerDO = this.Customers.Find(filter).FirstOrDefault();
if (customerDO == null)
{
this.Customers.InsertOne(new CustomerDO()
{
ExternalId = customer.Id,
IdCard = customer.IdCard,
Name = customer.Name,
Surname = customer.Surname,
Balance = 0,
});
}
else
{
customerDO.IdCard = customer.IdCard;
customerDO.Name = customer.Name;
customerDO.Surname = customer.Surname;
this.Customers.ReplaceOne(filter, customerDO);
}
}
public Customer GetCustomerByCustomerID(int customerID)
{
CustomerDO customerDAL = new CustomerDO();
Customer customer = customerDAL.GetCustomerByCustomerID(customerID);
return(customer);
}
public List <Customer> SearchCustomersByFirstNameOrLastName(string FirstName, string LastName)
{
CustomerDO customerDAL = new CustomerDO();
List <Customer> customers = customerDAL.SearchCustomersByFirstNameOrLastName(FirstName, LastName);
return(customers);
}
public void UpdateCustomer(Customer customer)
{
CustomerDO customerDO = new CustomerDO();
customerDO.UpdateCustomer(customer);
return;
}
public List <Customer> GetCustomersByLastName(string LastName)
{
CustomerDO customerDAL = new CustomerDO();
List <Customer> customers = customerDAL.GetCustomersByLastName(LastName);
return(customers);
}
public List <Customer> GetCustomersByFirstNameAndLastName(string FirstName, string LastName)
{
CustomerDO customerDAL = new CustomerDO();
List <Customer> customers = customerDAL.GetCustomersByFirstNameAndLastName(FirstName, LastName);
return(customers);
}
public int AddCustomer(CustomerDO customer)
{
// Check if customer of same name exists
if (db.Customers.ToList().Exists(c => c.Name.ToLower() == customer.Name.ToLower()))
{
return(0);
}
db.Customers.Add(customer);
db.SaveChanges();
return(customer.CustomerId);
}
public List <Customer> GetCustomers()
{
CustomerDO customerDAL = new CustomerDO();
List <Customer> customers = new List <Customer>();
try
{
customers = customerDAL.GetCustomers();
if (customers == null)
{
customers = new List <Customer>();
customers.Add(new Customer
{
customerID = 1,
firstName = "Fred",
lastName = "Flinstone",
middleInitial = "",
name = "Fred Flinstone",
address1 = "",
address2 = "",
city = "Bedrock",
state = "A place right out of History",
zip = "",
address = "Bedrock, A place right out of History"
});
customers.Add(new Customer
{
customerID = 2,
firstName = "Wilma",
lastName = "Flinstone",
middleInitial = "",
name = "Wilma Flinstone",
address1 = "",
address2 = "",
city = "Bedrock",
state = "A place right out of History",
zip = "",
address = "Bedrock, A place right out of History"
});
}
else
{
FormatCustomers(ref customers);
}
}
catch (Exception ex)
{
throw;
}
return(customers);
}
public decimal GetAvailableFunds(int customerId)
{
var filter = Builders <CustomerDO> .Filter.Eq(r => r.ExternalId, customerId);
CustomerDO customer = this.Customers.Find(filter).FirstOrDefault();
if (customer == null)
{
throw new AccountNotFound();
}
return(customer.Balance);
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
try
{
if (result.Succeeded)
{
CustomerDO dataModel = new CustomerDO();
dataModel.FirstName = model.FirstName;
dataModel.LastName = model.LastName;
dataModel.Contact = model.Contact;
dataModel.City_ID = model.City_ID;
dataModel.User_ID = user.Id;
//dataModel.UpdatedDate = model.UpdatedDate;
CustomerManagement customerManagement = new CustomerManagement();
customerManagement.CreateUser(dataModel);
RegisterViewModel modelData = new RegisterViewModel();
modelData.Cities = getCityDropDownData();
UserManager.AddToRole(user.Id, "Customer");
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
// For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
return(RedirectToAction("Index", "Home"));
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public void WithdrawFunds(int customerId, decimal funds)
{
var filter = Builders <CustomerDO> .Filter.Eq(r => r.ExternalId, customerId);
CustomerDO customerDO = this.Customers.Find(filter).FirstOrDefault();
if (customerDO == null)
{
throw new AccountNotFound();
}
var update = Builders <CustomerDO> .Update.Set(x => x.Balance, customerDO.Balance - funds);
var result = this.Customers.UpdateOneAsync(filter, update).Result;
}
public void CreateUser(CustomerDO dataModel)
{
SqlCommand cmd = new SqlCommand("insert into Customer values(@FirstName, @LastName, @Contact, @City_ID, @User_ID)", conn);
cmd.Parameters.AddWithValue("@FirstName", dataModel.FirstName);
cmd.Parameters.AddWithValue("@LastName", dataModel.LastName);
cmd.Parameters.AddWithValue("@Contact", dataModel.Contact);
cmd.Parameters.AddWithValue("@City_ID", dataModel.City_ID);
cmd.Parameters.AddWithValue("@User_ID", dataModel.User_ID);
//cmd.Parameters.AddWithValue("@UpdatedDate", dataModel.UpdatedDate);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public List <Customer> GetCustomers()
{
CustomerDO customerDAL = new CustomerDO();
List <Customer> customers = new List <Customer>();
try
{
customers = customerDAL.GetCustomers();
if (customers == null)
{
customers = new List <Customer>();
customers.Add(new Customer
{
CustomerID = 1,
FirstName = "Fred",
LastName = "Flinstone",
MiddleInitial = "",
Address1 = "",
Address2 = "",
City = "Bedrock",
State = "A place right out of History",
Zip = ""
});
customers.Add(new Customer
{
CustomerID = 2,
FirstName = "Wilma",
LastName = "Flinstone",
MiddleInitial = "",
Address1 = "",
Address2 = "",
City = "Bedrock",
State = "A place right out of History",
Zip = ""
});
}
}
catch (Exception ex)
{
throw;
}
return(customers);
}
public void GetCustomersAccess(object sender, System.EventArgs e)
{
CustomerDO customerDO = new CustomerDO();
List <CustomerRow> customerRows = customerDO.GetCustomers();
if (customerRows != null)
{
if (customerRows.Count > 0)
{
foreach (CustomerRow customerRow in customerRows)
{
bindingSource1.Add(customerRow);
}
}
}
// BuildCustomerGrid();
}
/// <summary>
/// Gets the customer.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
public Customer GetCustomer(int id)
{
var filter = Builders <CustomerDO> .Filter.Eq(r => r.ExternalId, id);
CustomerDO customer = this.Customers.Find(filter).FirstOrDefault();
if (customer == null)
{
throw new AccountNotFound();
}
return(new Customer()
{
Id = customer.ExternalId,
IdCard = customer.IdCard,
Name = customer.Name,
Surname = customer.Surname,
});
}
public void UpdatePhotos()
{
CustomerDO customerDO = new CustomerDO();
//customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face2.jpg", 1699);
//customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face1.jpg", 1700);
//customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face7.jpg", 1701);
//customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face9.jpg", 1701);
//customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face4.jpg", 1703);
//customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face5.jpg", 1704);
//customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face6.jpg", 1705);
//customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face8.jpg", 1706);
//customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face3.jpg", 1707);
//customerDO.saveImage(@"C:\Dev\Web Services\WebAPI\SampleWebApi\SampleDemoWebApi\Images", "FemaleSillouette.jpg", 1708);
// customerDO.saveImage(@"C:\Dev\Web Services\WebAPI\SampleWebApi\SampleDemoWebApi\Images", "generic.png", -1);
//customerDO.saveImage(@"C:\Dev\Web Services\WebAPI\SampleWebApi\SampleDemoWebApi\Images", "Female2.jpg", -2);
customerDO.saveImage(@"C:\Dev\Web Services\WebAPI\SampleWebApi\SampleDemoWebApi\Images", "MaleSillouette.png", -3);
}
public void RetrievePhotos()
{
CustomerDO customerDO = new CustomerDO();
Image mike = customerDO.getImage();
}
