public void Db_UpdateCustomer()
{
// arrange
var customerDb = new CustomerDb(_connectionString);
var customer = new Customer.EF.Customer {
Id = 0, FirstName = "Marli", LastName = "Smith", Password = "******"
};
// act
customer = customerDb.AddCustomer(customer);
customer.FirstName = "Marlo";
customer = customerDb.UpdateCustomer(customer);
// assert
Assert.AreEqual(customer.FirstName, "Marlo");
}
public ActionResult DeleteCustomer(int id, FormCollection collection)
{
CustomerDb dbCustomer = new CustomerDb();
bool customerValid;
customerValid = dbCustomer.DeleteCustomer(id);
if (customerValid)
{
return(RedirectToAction("Customers"));
}
else
{
return(RedirectToAction("DeleteCustomer", id));
}
}
private static void Main()
{
//var f = new Form1();
//Application.EnableVisualStyles();
//Application.SetCompatibleTextRenderingDefault(false);
//Application.Run(new Form1());
var lr =
new LocalReport();
string deviceInfo =
"<DeviceInfo>" +
"<SimplePageHeaders>True</SimplePageHeaders>" +
"</DeviceInfo>";
lr.ReportPath = @"Report1.rdlc";
CustomerDb db = CustomerDb.Create();
Customer cust = db.Customers[0];
var ds1 = new ReportDataSource
{
DataSourceId = "DataModel_Customer",
DataMember = "DataModel_Customer",
Name = "DataModel_Customer"
};
lr.DataSources.Add(ds1);
lr.DataSources.Add(new ReportDataSource("DataModel_Order"));
string mimeType;
string encoding;
string fileNameExtension;
string[] streams;
Warning[] warnings;
byte[] bytes = lr.Render("PDF", deviceInfo,
out mimeType,
out encoding, out fileNameExtension,
out streams,
out warnings);
using (var fs = new FileStream(@"Report.pdf", FileMode.Create)) {
fs.Write(bytes, 0, bytes.Length);
fs.Close();
}
}
/// <summary>
/// Show view to edit password current account
/// </summary>
/// <returns>View|Redirect</returns>
public ActionResult EditPassword()
{
CustomerDb dbCustomer = new CustomerDb();
var claimIdentity = User.Identity as ClaimsIdentity;
int id = Convert.ToInt32(claimIdentity.FindFirst(ClaimTypes.NameIdentifier).Value);
if (id > 0)
{
PasswordViewModel passwordViewModel = new PasswordViewModel
{
IdUser = id
};
return(View(passwordViewModel));
}
return(RedirectToAction("Index", "Home"));
}
// GET: Clients/Remove/5
public ActionResult Remove(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CustomerDb customerDb = _db.Customers.Find(id);
if (customerDb == null)
{
return(HttpNotFound());
}
Customer customer = JsonConvert.DeserializeObject <Customer>(customerDb.Obj_Data);
customer.Id = (int)id;
return(View(customer));
}
public int Save(Customer customer, CustomerDb db)
{
if (IsDbContextNull(db) || IsCustomerNull(customer))
{
return(0);
}
db.Customers.Add(customer);
try
{
db.SaveChanges();
return(customer.Id);
}
catch (Exception e)
{
_logger.LogError(e, $"Error occurred while saving customer{(_logSensitiveData ? JsonConvert.SerializeObject(customer) : "")}");
return(0);
}
}
public ActionResult Register(Customer customer)
{
if (ModelState.IsValid)
{
CustomerDb dbCustomer = new CustomerDb();
bool isCustomerCreated;
isCustomerCreated = dbCustomer.AddCustomer(customer);
if (isCustomerCreated)
{
return(RedirectToAction("Login", "Authentication"));
}
return(RedirectToAction("Register", "Authentication"));
}
else
{
return(View());
}
}
public Customer GetById(int id, CustomerDb db)
{
if (IsDbContextNull(db))
{
return(null);
}
try
{
Customer customer = db.Customers.SingleOrDefault(c => c.Id == id);
if (customer == null)
{
_logger.LogDebug($"No customer found for id: {id}");
}
return(customer);
}
catch (Exception e)
{
_logger.LogError(e, $"Error occurred while getting customer by id{(_logSensitiveData ? "{" + id + "}" : "")}");
return(null);
}
}
public int UpdatePartial(int id, dynamic customer, CustomerDb db)
{
if (IsDbContextNull(db))
{
return(0);
}
Customer trackedCustomer = null;
try
{
trackedCustomer = db.Customers.SingleOrDefault(c => c.Id == id);
}
catch (Exception e)
{
_logger.LogError(e, $"Error occurred while getting customer by id{(_logSensitiveData ? "{" + id + "}" : "")} for partial update");
}
if (trackedCustomer == null)
{
_logger.LogDebug($"No customer found for given id{(_logSensitiveData ? "{" + id + "}" : "")}");
return(0);
}
if (customer.GetType().GetProperty("Id") != null)
{
customer.Id = id; //cannot update the id
}
try
{
db.Entry(trackedCustomer).CurrentValues.SetValues(customer);
return(db.SaveChanges());
}
catch (Exception e)
{
_logger.LogError(e, $"Error occurred while partially updating customer{(_logSensitiveData ? JsonConvert.SerializeObject(customer, new JsonSerializerSettings() { NullValueHandling = NullValueHandling.Ignore }) : " ")}");
return(0);
}
}
public ActionResult Edit(AccountViewModel customerViewModel)
{
if (ModelState.IsValid)
{
CustomerDb dbCustomer = new CustomerDb();
bool isCustomerEdited;
Customer customer = new Customer
{
IdUser = customerViewModel.IdUser,
FirstName = customerViewModel.FirstName,
LastName = customerViewModel.LastName,
Address = customerViewModel.Address,
PostalCode = customerViewModel.PostalCode,
Town = customerViewModel.Town,
Country = customerViewModel.Country,
Email = customerViewModel.Email,
Username = customerViewModel.Username
};
isCustomerEdited = dbCustomer.UpdateCustomer(customer);
if (isCustomerEdited)
{
var claimIdentity = User.Identity as ClaimsIdentity;
int id = Convert.ToInt32(claimIdentity.FindFirst(ClaimTypes.NameIdentifier).Value);
if (id > 0)
{
return(RedirectToAction("Detail", "Account"));
}
return(RedirectToAction("Index", "Home"));
}
return(RedirectToAction("Index", "Home"));
}
return(RedirectToAction("Index", "Home"));
}
/// <summary>
/// Send json request to check a user in DB exist with this email
/// </summary>
/// <param name="Email"></param>
/// <returns>Json</returns>
public JsonResult IsEmailExist(string Email, int?IdUser)
{
UserDb dbUser = new UserDb();
User userFound = new User();
userFound = dbUser.GetUserByEmail(Email);
int id = 0;
string email = "";
CustomerDb dbCustomer = new CustomerDb();
var claimIdentity = User.Identity as ClaimsIdentity;
if (claimIdentity.GetUserId() != null)
{
id = Convert.ToInt32(claimIdentity.FindFirst(ClaimTypes.NameIdentifier).Value);
email = Convert.ToString(claimIdentity.FindFirst(ClaimTypes.Email).Value);
}
// Check if the account is the same of account edited by the admin
if (IdUser != null && userFound.IdUser == IdUser)
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
// Check if the edit email is the same of the connected account
if (id > 0 && userFound.Email == email)
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
if (userFound.Username != null)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
}
public int UpdateFull(int id, Customer customer, CustomerDb db)
{
if (IsDbContextNull(db) || IsCustomerNull(customer))
{
return(0);
}
Customer trackedCustomer = null;
try
{
trackedCustomer = db.Customers.SingleOrDefault(c => c.Id == id);
}
catch (Exception e)
{
_logger.LogError(e, $"Error occurred while getting customer by id{(_logSensitiveData ? "{" + id + "}" : "")} for full update");
return(0);
}
if (trackedCustomer == null)
{
_logger.LogDebug($"No customer found for given id{(_logSensitiveData ? "{" + id + "}" : "")}");
return(0);
}
customer.Id = id; //avoid updating the id
try
{
db.Entry(trackedCustomer).CurrentValues.SetValues(customer);
return(db.SaveChanges());
}
catch (Exception e)
{
_logger.LogError(e, $"Error occurred while fully updating customer{(_logSensitiveData ? JsonConvert.SerializeObject(customer) : "")}");
return(0);
}
}
public CustomerBaseBusiness()
{
customerDb = new CustomerDb();
customerTypeDb = new CustomerTypeDb();
}
public CustomerController()
{
CustomerContextFactory factory = new CustomerContextFactory();
_db = factory.Create();
}
public CustomerRepository(CustomerDb context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public CustomerBL()
{
customerDb = new CustomerDb();
}
public void Fill() => customers = CustomerDb.GetCustomers();
// GET: Customer
public ActionResult Index()
{
var customers = CustomerDb.GetAll();
return(View(customers));
}
public void Save() => CustomerDb.SaveCustomers(customers);
// GET: Customer
public ActionResult Index()
{
var customers = CustomerDb.GetAllCustomers();
return(Json(customers));
}
public static void AddReference(string keyName, CustomerDb cdb)
{
ReferenceHolder.Add(keyName, cdb);
}
public IActionResult GetAll([FromQuery] Page page, [FromQuery] CustomerFilter filter, [FromServices] CustomerDb db)
{
if (page == null || page.PageNo < 1 || page.PageSize < 1)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { error = "invalid page details" }));
}
return(Ok(_dao.GetAll(page, filter, db)));
}
public ActionResult Delete(int Id)
{
var customerInDb = CustomerDb.GetById(Id);
return(View(customerInDb));
}
public CustomerBs()
{
CustomerDb = new CustomerDb();
}
