public void CreateWithExistingCustomerId()
{
long? existingcustomerId = 1;
string stringifiedexistingCustomerId = Convert.ToString(existingcustomerId.Value);
var customer = new customer { customerID = existingcustomerId.Value, name = "Test customer", state = "Florida" };
customer.customerList = new List<SelectListItem>();
customer.StateList = new List<SelectListItem>();
customer.TrainList = new List<SelectListItem>();
customer.CityList = new List<SelectListItem>();
mockedCustomerRepository.Setup(m => m.FindById(stringifiedexistingCustomerId)).Returns(customer);
var customerList = new List<customer> { customer };
mockedRepositoryCustomer.Setup(m => m.GetAll()).Returns(customerList.AsQueryable());
var stateList = new List<source>() { new source { state = "FL", state_name = "Florida", city = "Florida" } };
mockedCustomerRepository.Setup(m => m.GetStateList()).Returns(stateList);
var controller = new CustomerController(mockedRepositoryCustomer.Object, mockedCustomerRepository.Object, mockedRepositorySource.Object);
controller.ControllerContext = new ControllerContext();
var mockedHttpContext = new Mock<HttpContextBase>();
var mockedSessionState = new HttpSessionMock();
mockedHttpContext.SetupGet(ctx => ctx.Session).Returns(mockedSessionState);
controller.ControllerContext.HttpContext = mockedHttpContext.Object;
var returnObj = controller.Create(existingcustomerId);
Assert.IsNotNull(returnObj);
Assert.IsInstanceOfType(returnObj, typeof(PartialViewResult));
var result = (PartialViewResult)returnObj;
Assert.IsNotNull(result);
mockedCustomerRepository.Verify(m => m.FindById(Convert.ToString(existingcustomerId)), Times.Once());
mockedRepositoryCustomer.Verify(m => m.GetAll(), Times.Once());
mockedCustomerRepository.Verify(m => m.GetStateList(), Times.Once());
}
public bool CheckForDuplicate(string name, string state, string city)
{
try
{
customer customer = new customer();
customer.name = name;
customer.city = city;
customer.state = state;
return this.modifiedCustRepository.CheckForDuplicates(customer);
}
catch
{
throw;
}
}
/// <summary>
/// CostAnalyzer
/// </summary>
/// <returns></returns>
public ActionResult CostAnalyzer()
{
long customerId = 0;
if (this.Session["CustomerId"] != null)
{
customerId = Convert.ToInt64(this.Session["CustomerId"]);
}
customer CustDetails = new customer();
SystemSummaryViewModel SSVMDetails = new SystemSummaryViewModel();
customer_water CustWaterDetails = null;
try
{
//If valid customer id does not exist in the session
if (customerId != 0)
{
var Customer = this.customerRepository.GetAll();
CustDetails = Customer.Where(x => x.customerID == customerId).FirstOrDefault();
SSVMDetails = new SystemSummaryViewModel();
SSVMDetails.CustomerDetails = CustDetails;
CustWaterDetails = this.modifiedCustRepository.GetWaterSourceIds(customerId);
}
if (CustWaterDetails != null)
{
if (CustWaterDetails.first_sourceID != 0)
{
SSVMDetails.WaterSourceOne = this.modifiedCustRepository.GetWaterSourceDetails(CustWaterDetails.first_sourceID);//Get first watersource details
if (SSVMDetails.WaterSourceOne != null)
{
SSVMDetails.WaterSourceOne.full_site_name = SSVMDetails.WaterSourceOne.full_site_name.Replace("@", string.Empty);//Remove @ symbol from the watersource name
}
}
else
{
SSVMDetails.WaterSourceOne = null;
}
if (CustWaterDetails.second_sourceID != 0)
{
SSVMDetails.WaterSourceTwo = this.modifiedCustRepository.GetWaterSourceDetails(CustWaterDetails.second_sourceID);//Get second watersource details
if (SSVMDetails.WaterSourceTwo != null)
{
SSVMDetails.WaterSourceTwo.full_site_name = SSVMDetails.WaterSourceTwo.full_site_name.Replace("@ ", string.Empty);//Remove @ symbol from the watersource name
}
}
else
{
SSVMDetails.WaterSourceTwo = null;
}
SSVMDetails.Trains = this.modifiedCustRepository.GetCustomerTrains(customerId);//Get list of cutomer train details
}
else
{
this.Session["IsNewCustomer"] = "True";
this.Session["HasTrainDetails"] = "Check";
}
SSVMDetails.CustomerType = Convert.ToString(this.Session["IsNewCustomer"]);
SSVMDetails.HasTrainDetails = Convert.ToString(this.Session["HasTrainDetails"]);
if (Convert.ToString(this.Session["HasTrainDetails"]) == "Verify")
{
var count = (this.vesselRepository.GetAll().Where(p => p.vessel_customerID == (customerId).ToString())).Count();
if (count != 0)
{
SSVMDetails.HasTrainDetails = "Yes";
}
else
{
SSVMDetails.HasTrainDetails = "No";
}
}
}
catch
{
throw;
}
return this.View(SSVMDetails);
}
public ActionResult Create(long? customerId)
{
try
{
customer Cust = new customer()
{
customerList = new List<SelectListItem>(),
StateList = new List<SelectListItem>(),
TrainList = new List<SelectListItem>(),
CityList = new List<SelectListItem>()
};
if (customerId != null && customerId != -1)
{
Cust = this.modifiedCustRepository.FindById(Convert.ToString(customerId));
}
List<customer> c = new List<customer>();
List<source> s = new List<source>();
c = this.customerRepository.GetAll().ToList();
s = this.modifiedCustRepository.GetStateList();
Cust.customerList.Add(new SelectListItem() { Text = "New Customer..", Value = "-1" });
foreach (var item in c)
{
Cust.customerList.Add(new SelectListItem() { Text = item.name, Value = Convert.ToString(item.customerID) });
}
var createCustomerData = s.GroupBy(g => new { g.state_name, g.state }).Select(g => g.FirstOrDefault()).ToList();
foreach (var item in createCustomerData)
{
Cust.StateList.Add(new SelectListItem() { Text = item.state_name, Value = item.state_name });
}
for (int i = 1; i <= 20; i++)
{
Cust.TrainList.Add(new SelectListItem() { Text = i.ToString(), Value = i.ToString() });
}
if (customerId != null && customerId != -1)
{
foreach (var item in s.Where(x => x.state_name == Cust.state)
.GroupBy(g => new {
g.city
})
.Select(g => g.FirstOrDefault()).ToList())
{
Cust.CityList.Add(new SelectListItem() { Text = item.city, Value = item.city });
}
this.Session["IsDuplicate"] = "False";
return this.PartialView("_Edit", Cust);
}
else
{
if (Convert.ToString(this.Session["IsDuplicate"]) == "True")
{
ModelState.AddModelError("notes", "Customer Already exists");
}
this.Session["IsDuplicate"] = "False";
return this.PartialView("_Create", Cust);
}
}
catch
{
throw;
}
}
public ActionResult Edit(customer customer)
{
try
{
if (ModelState.IsValid)
{
this.modifiedCustRepository.UpdateCustomer(customer);
return RedirectToAction("Index");
}
return this.View(customer);
}
catch
{
throw;
}
}
public ActionResult Create(customer Customer)
{
try
{
if (ModelState.IsValid)
{
if (Customer.customerID == -1)
{
long Id = this.customerRepository.InsertAndGetID(Customer);
this.Session["CustomerId"] = Id;
this.Session["IsNewCustomer"] = "True";
this.Session["IsDuplicate"] = "False";
this.Session["HasTrainDetails"] = "Check";
return RedirectToAction("Dashboard", "ClientDatabase");
}
else
{
this.modifiedCustRepository.UpdateCustomer(Customer);
this.Session["CustomerId"] = Customer.customerID;
this.Session["IsNewCustomer"] = "False";
this.Session["IsDuplicate"] = "False";
this.Session["HasTrainDetails"] = "Verify";
return RedirectToAction("Dashboard", "ClientDatabase", new { id = Customer.customerID });
}
}
else
{
this.Session["IsDuplicate"] = "True";
return RedirectToAction("Dashboard", "ClientDatabase");
}
}
catch
{
throw;
}
}
/// <summary>
/// Predictive System Performance view
/// </summary>
/// <param name="id">customer identifier</param>
/// <returns>Returns the Predictive System Performance view</returns>
public ActionResult PredictiveSystemPerformance()
{
long customerId = 0;
if (this.Session["CustomerId"] != null)
{
customerId = Convert.ToInt64(this.Session["CustomerId"]);
}
customer customerDetails = new customer();
SystemSummaryViewModel ssvmDetails = new SystemSummaryViewModel();
customer_water custWaterDetails = null;
try
{
if (customerId != 0)
{
var Customer = this.customerRepository.GetAll();
customerDetails = Customer.Where(x => x.customerID == customerId).FirstOrDefault();
ssvmDetails = new SystemSummaryViewModel();
ssvmDetails.CustomerDetails = customerDetails;
custWaterDetails = this.modifiedCustomerRepository.GetWaterSourceIds(customerId);
}
if (custWaterDetails != null)
{
if (custWaterDetails.first_sourceID != 0)
{
ssvmDetails.WaterSourceOne = this.modifiedCustomerRepository.GetWaterSourceDetails(custWaterDetails.first_sourceID);//Get first watersource details
if (ssvmDetails.WaterSourceOne != null)
{
ssvmDetails.WaterSourceOne.full_site_name = ssvmDetails.WaterSourceOne.full_site_name.Replace("@", string.Empty);//Remove @ symbol from the watersource name
}
}
else
{
ssvmDetails.WaterSourceOne = null;
}
if (custWaterDetails.second_sourceID != 0)
{
ssvmDetails.WaterSourceTwo = this.modifiedCustomerRepository.GetWaterSourceDetails(custWaterDetails.second_sourceID);//Get second watersource details
if (ssvmDetails.WaterSourceTwo != null)
{
ssvmDetails.WaterSourceTwo.full_site_name = ssvmDetails.WaterSourceTwo.full_site_name.Replace("@ ", string.Empty);//Remove @ symbol from the watersource name
}
}
else
{
ssvmDetails.WaterSourceTwo = null;
}
ssvmDetails.Trains = this.modifiedCustomerRepository.GetCustomerTrains(customerId);//Get list of cutomer train details
}
else
{
this.Session["IsNewCustomer"] = "True";
this.Session["HasTrainDetails"] = "Check";
}
ssvmDetails.CustomerType = Convert.ToString(this.Session["IsNewCustomer"]);
ssvmDetails.HasTrainDetails = Convert.ToString(this.Session["HasTrainDetails"]);
if (Convert.ToString(this.Session["HasTrainDetails"]) == "Verify")
{
var count = this.vesselRepository.GetAll().Where(p => p.vessel_customerID == (customerId).ToString()).Count();
if (count != 0)
{
ssvmDetails.HasTrainDetails = "Yes";
}
else
{
ssvmDetails.HasTrainDetails = "No";
}
}
WaterStatisticsViewModel objWaterStatisticsViewModel = new WaterStatisticsViewModel();
objWaterStatisticsViewModel = this.modifiedPredictiveRepository.GetWaterStatistics(customerId);
ssvmDetails.waterStatisticsViewModeldetails = objWaterStatisticsViewModel;
}
catch (Exception)
{
throw;
}
return this.View(ssvmDetails);
}
public ActionResult WaterConductivity()
{
long customerId = 0;
if (this.Session["CustomerId"] != null)
{
customerId = Convert.ToInt64(this.Session["CustomerId"]);
}
customer CustDetails = new customer();
SystemSummaryViewModel SSVMDetails = new SystemSummaryViewModel();
customer_water CustWaterDetails = null;
try
{
//If valid customer id does not exist in the session
if (customerId != 0)
{
var Customer = this.customerRepository.GetAll();
CustDetails = Customer.Where(x => x.customerID == customerId).FirstOrDefault();
SSVMDetails = new SystemSummaryViewModel();
SSVMDetails.CustomerDetails = CustDetails;
CustWaterDetails = this.modifiedCustRepository.GetWaterSourceIds(customerId);
}
if (CustWaterDetails != null)
{
if (CustWaterDetails.first_sourceID != 0)
{
SSVMDetails.WaterSourceOne = this.modifiedCustRepository.GetWaterSourceDetails(CustWaterDetails.first_sourceID);//Get first watersource details
if (SSVMDetails.WaterSourceOne != null)
{
SSVMDetails.WaterSourceOne.full_site_name = SSVMDetails.WaterSourceOne.full_site_name.Replace("@", string.Empty);//Remove @ symbol from the watersource name
SSVMDetails.Source1Statistics = this.conductivityService.CalculateStatistics(CustWaterDetails.first_sourceID);
}
}
else
{
SSVMDetails.WaterSourceOne = null;
}
if (CustWaterDetails.second_sourceID != 0)
{
SSVMDetails.WaterSourceTwo = this.modifiedCustRepository.GetWaterSourceDetails(CustWaterDetails.second_sourceID);//Get second watersource details
if (SSVMDetails.WaterSourceTwo != null)
{
SSVMDetails.WaterSourceTwo.full_site_name = SSVMDetails.WaterSourceTwo.full_site_name.Replace("@ ", string.Empty);//Remove @ symbol from the watersource name
SSVMDetails.Source2Statistics = this.conductivityService.CalculateStatistics(CustWaterDetails.second_sourceID);
}
}
else
{
SSVMDetails.WaterSourceTwo = null;
}
SSVMDetails.Trains = this.modifiedCustRepository.GetCustomerTrains(customerId);//Get list of cutomer train details
}
else
{
this.Session["IsNewCustomer"] = "True";
this.Session["HasTrainDetails"] = "Check";
}
}
catch
{
throw;
}
return this.View(SSVMDetails);
}
public void CreateWithoutExistingCustomerIdWithDuplicate()
{
var customer = new customer { customerID = (long)1, name = "Test customer", state = "Florida" };
customer.customerList = new List<SelectListItem>();
customer.StateList = new List<SelectListItem>();
customer.TrainList = new List<SelectListItem>();
customer.CityList = new List<SelectListItem>();
mockedCustomerRepository.Setup(m => m.FindById(It.IsAny<string>())).Verifiable();
var customerList = new List<customer> { customer };
mockedRepositoryCustomer.Setup(m => m.GetAll()).Returns(customerList.AsQueryable());
var stateList = new List<source>() { new source { state = "FL", state_name = "Florida", city = "Florida" } };
mockedCustomerRepository.Setup(m => m.GetStateList()).Returns(stateList);
var controller = new CustomerController(mockedRepositoryCustomer.Object, mockedCustomerRepository.Object, mockedRepositorySource.Object);
controller.ControllerContext = new ControllerContext();
var mockedHttpContext = new Mock<HttpContextBase>();
var mockedSessionState = new HttpSessionMock();
mockedSessionState["IsDuplicate"] = "True";
mockedHttpContext.SetupGet(ctx => ctx.Session).Returns(mockedSessionState);
controller.ControllerContext.HttpContext = mockedHttpContext.Object;
long? customerId = null;
var returnObj = controller.Create(customerId);
Assert.IsNotNull(returnObj);
Assert.IsInstanceOfType(returnObj, typeof(PartialViewResult));
var result = (PartialViewResult)returnObj;
Assert.IsNotNull(result);
Assert.AreEqual(result.ViewName, "_Create");
Assert.AreEqual(result.ViewData.ModelState.IsValid, false);
Assert.AreEqual(result.ViewData.ModelState["notes"].Errors[0].ErrorMessage, "Customer Already exists");
mockedCustomerRepository.Verify(m => m.FindById(Convert.ToString(It.IsAny<string>())), Times.Never());
mockedRepositoryCustomer.Verify(m => m.GetAll(), Times.Once());
mockedCustomerRepository.Verify(m => m.GetStateList(), Times.Once());
}
public void UpdateCustomer()
{
customer customer = new customer() { customerID = 1 };
bool IsDuplicate = false;
mockedCustomerRepository.Setup(item => item.CheckForDuplicates(customer)).Returns(IsDuplicate);
mockedCustomerRepository.Setup(item => item.UpdateCustomer(customer)).Verifiable();
var controller = new CustomerController(mockedRepositoryCustomer.Object, mockedCustomerRepository.Object, mockedRepositorySource.Object);
controller.ControllerContext = new ControllerContext();
var mockedHttpContext = new Mock<HttpContextBase>();
var mockedSessionState = new HttpSessionMock();
mockedHttpContext.SetupGet(ctx => ctx.Session).Returns(mockedSessionState);
controller.ControllerContext.HttpContext = mockedHttpContext.Object;
var returnObj = controller.Create(customer);
Assert.IsNotNull(returnObj);
Assert.IsInstanceOfType(returnObj, typeof(RedirectToRouteResult));
var result = (RedirectToRouteResult)returnObj;
Assert.IsNotNull(result);
mockedCustomerRepository.Verify(m => m.CheckForDuplicates(customer), Times.Never());
mockedCustomerRepository.Verify(m => m.UpdateCustomer(customer), Times.Once());
}
public void UpdateCustomerWithErrors()
{
customer customer = new customer() { customerID = 1 };
var controller = new CustomerController(mockedRepositoryCustomer.Object, mockedCustomerRepository.Object, mockedRepositorySource.Object);
controller.ControllerContext = new ControllerContext();
var mockedHttpContext = new Mock<HttpContextBase>();
var mockedSessionState = new HttpSessionMock();
mockedHttpContext.SetupGet(ctx => ctx.Session).Returns(mockedSessionState);
controller.ControllerContext.HttpContext = mockedHttpContext.Object;
controller.ModelState.AddModelError("Error", "ErrorMessage"); ;
var returnObj = controller.Create(customer);
Assert.IsNotNull(returnObj);
Assert.IsInstanceOfType(returnObj, typeof(RedirectToRouteResult));
var result = (RedirectToRouteResult)returnObj;
Assert.IsNotNull(result);
mockedCustomerRepository.Verify(m => m.CheckForDuplicates(customer), Times.Never());
mockedCustomerRepository.Verify(m => m.UpdateCustomer(customer), Times.Never());
}
public void SaveCustomer()
{
customer customer = new customer() { customerID = -1 };
long newCustomerId = 0;
mockedRepositoryCustomer.Setup(item => item.InsertAndGetID(customer)).Returns(newCustomerId);
var controller = new CustomerController(mockedRepositoryCustomer.Object, mockedCustomerRepository.Object, mockedRepositorySource.Object);
controller.ControllerContext = new ControllerContext();
var mockedHttpContext = new Mock<HttpContextBase>();
var mockedSessionState = new HttpSessionMock();
mockedHttpContext.SetupGet(ctx => ctx.Session).Returns(mockedSessionState);
controller.ControllerContext.HttpContext = mockedHttpContext.Object;
var returnObj = controller.Create(customer);
Assert.IsNotNull(returnObj);
Assert.IsInstanceOfType(returnObj, typeof(RedirectToRouteResult));
var result = (RedirectToRouteResult)returnObj;
Assert.IsNotNull(result);
mockedRepositoryCustomer.Verify(m => m.InsertAndGetID(customer), Times.Once());
}
public void EditCustomerSaveFail()
{
customer customer = new customer();
var controller = new CustomerController(mockedRepositoryCustomer.Object, mockedCustomerRepository.Object, mockedRepositorySource.Object);
controller.ControllerContext = new ControllerContext();
var mockedHttpContext = new Mock<HttpContextBase>();
var mockedSessionState = new HttpSessionMock();
mockedHttpContext.SetupGet(ctx => ctx.Session).Returns(mockedSessionState);
controller.ControllerContext.HttpContext = mockedHttpContext.Object;
controller.ModelState.AddModelError("Error", "ErrorMessage"); ;
var returnObj = controller.Edit(customer);
Assert.IsNotNull(returnObj);
Assert.IsInstanceOfType(returnObj, typeof(ViewResult));
var result = (ViewResult)returnObj;
Assert.IsNotNull(result);
}
public void EditCustomerSave()
{
customer customer = new customer();
mockedCustomerRepository.Setup(item => item.UpdateCustomer(customer)).Verifiable();
var controller = new CustomerController(mockedRepositoryCustomer.Object, mockedCustomerRepository.Object, mockedRepositorySource.Object);
var returnObj = controller.Edit(customer);
Assert.IsNotNull(returnObj);
Assert.IsInstanceOfType(returnObj, typeof(RedirectToRouteResult));
var result = (RedirectToRouteResult)returnObj;
Assert.IsNotNull(result);
mockedCustomerRepository.Verify(m => m.UpdateCustomer(customer), Times.Once());
}
public void EditCustomer()
{
string customerId = "1";
List<customer> lstCustomer = new List<customer>();
customer customer = new customer() { CityList = new List<SelectListItem>(), customerList = new List<SelectListItem>() };
lstCustomer.Add(customer);
mockedCustomerRepository.Setup(item => item.FindById(customerId)).Returns(customer);
mockedRepositoryCustomer.Setup(item => item.GetAll()).Returns(lstCustomer.AsQueryable());
var controller = new CustomerController(mockedRepositoryCustomer.Object, mockedCustomerRepository.Object, mockedRepositorySource.Object);
var returnObj = controller.Edit(customerId);
Assert.IsNotNull(returnObj);
Assert.IsInstanceOfType(returnObj, typeof(ViewResult));
var result = (ViewResult)returnObj;
Assert.IsNotNull(result);
mockedCustomerRepository.Verify(m => m.FindById(customerId), Times.Once());
mockedRepositoryCustomer.Verify(m => m.GetAll(), Times.Once());
}
public void Deletevalid()
{
string customerId = "0";
customer customer = new customer();
mockedCustomerRepository.Setup(item => item.FindById(customerId)).Returns(customer);
var controller = new CustomerController(mockedRepositoryCustomer.Object, mockedCustomerRepository.Object, mockedRepositorySource.Object);
var returnObj = controller.Delete(customerId);
Assert.IsNotNull(returnObj);
Assert.IsInstanceOfType(returnObj, typeof(ViewResult));
var result = (ViewResult)returnObj;
Assert.IsNotNull(result);
mockedCustomerRepository.Verify(m => m.FindById(customerId), Times.Once());
}