protected void btnAdd_Click(object sender, EventArgs e)
{
CustDetail custDetail = new CustDetail();
//Model.CustomerDetail = new Model.CustomerDetail();
custDetail.CustomerID = txtCutomerID.Text;
custDetail.CustomerName = txtName.Text;
custDetail.DOB = txtDOB.Text;
custDetail.EmailAddress = txtEmail.Text;
custDetail.AccountNumber = txtAccNumber.Text;
if (chkMarried.Checked)
{
custDetail.MaritalStatus = "Married";
}
else
{
custDetail.MaritalStatus = "UnMarried";
}
BL.BusinessLogic busLogic = new BL.BusinessLogic();
//bool bSuccess = busLogic.InsertCustomerData(custDetail);
bool bSuccess = busLogic.AddCustomerDetails(custDetail);
if (!bSuccess)
{
lblMsg.Text = "Exception occured while adding Customer details...Sorry";
}
else
{
Response.Redirect("GetCustomers.aspx");
}
}
public bool InsertCustomerData(CustDetail customerDetail)
{
try
{
DataManagementService.IDataManagementService dbManager = new DataManagementService.DataManagementServiceClient();
bool bSuccessData = dbManager.InsertCustomerData(customerDetail);
return(bSuccessData);
}
catch (Exception ex)
{
throw ex;
}
}
public ResultSet GetCustomerDetails(out int NoOfRecords)
{
string connectionString = WebConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
CustDetail custDetials = new CustDetail();
int recordsCount = 0;
ResultSet resultSet = new ResultSet();
// Provide the query string with a parameter placeholder.
string queryString = "SELECT CustID, AccountNumber, CustType,Name,DOB from dbo.CustomerData ";
DataTable dtCust = new DataTable();
List <Record> listOfRecord = new List <Record>();
List <string> columnNames = null;
using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
recordsCount++;
Record row = new Record();
row.Columns = new Dictionary <string, string>();
if (columnNames == null || columnNames.Count == 0)
{
columnNames = new List <string>();
for (int i = 0; i < reader.FieldCount; i++)
{
columnNames.Add(reader.GetName(i));
}
}
foreach (string col in columnNames)
{
row.Columns.Add(col, reader[col].ToString());
}
listOfRecord.Add(row);
}
}
resultSet.Records = listOfRecord;
resultSet.IsSuccess = true;
NoOfRecords = recordsCount;
return(resultSet);
}
private void btnAddCustomer_Click(object sender, EventArgs e)
{
CustDetail custDetail = new CustDetail();
//Model.CustomerDetail = new Model.CustomerDetail();
custDetail.CustomerID = txtCustId.Text;
custDetail.CustomerName = txtCustName.Text;
custDetail.DOB = txtDOB.Text;
custDetail.EmailAddress = txtEmail.Text;
custDetail.AccountNumber = txtAccNumber.Text;
if (chkIsMarried.Checked)
{
custDetail.MaritalStatus = "Married";
}
else
{
custDetail.MaritalStatus = "UnMarried";
}
BL.BusinessLogic busLogic = new BL.BusinessLogic();
bool bSuccess = busLogic.InsertCustomerData(custDetail);
// bool bSuccess = busLogic.AddCustomerDetails(custDetail);
if (!bSuccess)
{
MessageBox.Show("Exception occured while adding Customer details");
}
else
{
lblValidationMessage.Visible = true;
lblValidationMessage.Text = "Customer " + txtCustName.Text + " added successfully.";
txtAccNumber.Text = "";
txtCustId.Text = "";
txtCustName.Text = "";
txtDOB.Text = "";
txtEmail.Text = "";
chkIsMarried.Checked = false;
if (RefeshCustomerGridEvent != null)
{
RefeshCustomerGridEvent(this, null);
}
}
}
// Get: Order/Create
public ActionResult Create(int custId, bool isCust)
{
var userId = User.Identity.GetUserId();
var custService = new CustomerService(userId);
var orderService = CreateOrderService();
CustDetail custDetail = custService.GetCustById(custId);
bool shortList = false;
OrderCreate model = new OrderCreate
{
CustName = $"{custDetail.FirstName} {custDetail.LastName}",
CustId = custId,
IsCust = isCust,
OrderDetailCategoryList = orderService.GetOrderDetailByOrderId(0, userId, shortList)
};
ViewBag.SlotId = BuildTimeSlotDropdown(false, model.SlotId);
return(View(model));
}
public void AddCustomerDataTest()
{
try
{
BusinessLogic blCustomerData = new BusinessLogic();
//check now
DataTable dt = new DataTable();
CustDetail custDetail = new CustDetail();
custDetail.AccountNumber = "3446422";
custDetail.CustomerID = "3456222";
custDetail.CustomerName = "UnitTestUser";
custDetail.DOB = DateTime.Now.ToString();
custDetail.EmailAddress = "*****@*****.**";
custDetail.MaritalStatus = "Married";
bool bSuccess = blCustomerData.InsertCustomerData(custDetail);
Assert.AreEqual(bSuccess.ToString().ToLower(), "true");
}
catch (Exception ex)
{
Assert.Fail("Exception has been thrown: Error Details : " + ex.Message);
}
}
public ActionResult GetCustBarCode(OrderGetCustBarCode model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
if (model.BarCodeNumber > 0)
{
var userId = User.Identity.GetUserId();
var BarCodeService = new BarCodeService(userId);
BarCodeDetail newBarCodeDetail = BarCodeService.GetBarCodeByBarCode(model.BarCodeNumber);
if (newBarCodeDetail == null)
{
ModelState.AddModelError("", $"'{model.BarCodeNumber}' is not a valid Bar Code Number. Please re-enter or contact a member of the Food Pantry team.");
return(View(model));
}
;
// Verify/Update Customer
var custService = new CustomerService(userId);
CustDetail custDetail = custService.GetCustByBarCodeId(newBarCodeDetail.BarCodeId);
if (custDetail.CustomerId == 0)
{
ModelState.AddModelError("", $"'{model.BarCodeNumber}' is not assigned to a Customer. Please re-enter or contact a member of the Food Pantry team.");
return(View(model));
}
return(RedirectToAction(actionName: "Edit", controllerName: "Customer", routeValues: new { isCust = model.IsCust, isOrder = true, id = custDetail.CustomerId }));
}
else
{
// Create Customer
return(RedirectToAction(actionName: "Create", controllerName: "Customer", routeValues: new { isOrder = true, barCodeId = 0 }));
}
}
public bool AddCustomerDetail(CustDetail customerDetail)
{
try
{
DBHandler dbHandler = new DBHandler();
string connectionString = WebConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
string proiderName = WebConfigurationManager.AppSettings["DBProvider"].ToString();
// Creating connection
// File.AppendAllText(@"D:\Charmi\Test.txt", "ConnectionString: " + connectionString + Environment.NewLine + "providerName: " + proiderName);
SqlConnection sqlConn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("INSERT INTO dbo.CustomerData ([CustID],[AccountNumber],[Name],[CustType],[DOB],[ApplicantMaritalStatus],[EmailAddress]) VALUES " +
"('" + customerDetail.CustomerID + "', '" + customerDetail.AccountNumber + "', '" + customerDetail.CustomerName + "', 'public' ,'" + customerDetail.DOB + "', '" + customerDetail.MaritalStatus + "', '" + customerDetail.EmailAddress + "' )", sqlConn);
sqlConn.Open();
cmd.ExecuteNonQuery();
sqlConn.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool InsertCustomerData(CustDetail customerDetail)
{
bool bSuceess;
string connectionString = WebConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
string commandText = "INSERT INTO CustomerData(CustID,AccountNumber, CustType,Name,DOB,EmailAddress,ApplicantMaritalStatus)Values(@CustID,@AccountNumber, @CustType,@Name,@DOB,@EmailAddress,@MaritalStatus)";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(commandText, connection);
customerDetail.DOB = DateTime.Now.ToString();
command.Parameters.AddWithValue("@CustID", customerDetail.CustomerID);
command.Parameters.AddWithValue("@AccountNumber", customerDetail.AccountNumber);
command.Parameters.AddWithValue("@CustType", "public");
command.Parameters.AddWithValue("@Name", customerDetail.CustomerName);
command.Parameters.AddWithValue("@DOB", customerDetail.DOB);
command.Parameters.AddWithValue("@EmailAddress", customerDetail.EmailAddress);
command.Parameters.AddWithValue("@MaritalStatus", customerDetail.MaritalStatus);
try
{
connection.Open();
Int32 rowsAffected = command.ExecuteNonQuery();
if (rowsAffected > 0)
{
bSuceess = true;
}
else
{
bSuceess = false;
}
}
catch (Exception ex)
{
bSuceess = false;
}
}
return(bSuceess);
}
public ActionResult CustInfo(CustDetail model)
{
_db.CustDetails.Add(model);
_db.SaveChanges();
return(RedirectToAction("Index", "ThankYou"));
}
public ActionResult Index()
{
CustDetail model = new CustDetail();
return(View(model));
}
public bool AddCustomerDetail(CustDetail customerDetail)
{
return(datamanger.AddCustomerDetail(customerDetail));
}
public ActionResult Create(CustCreate model)
{
int newCustId = 0;
if (!ModelState.IsValid)
{
ViewBag.BarCodeId = BuildBarCodeDropdown(model.BarCodeId);
return(View(model));
}
var service = CreateCustomerService();
if (model.BarCodeId == 0)
{
if (model.IsOrder)
{
// when creating an order, BarCode can be 0
newCustId = service.CreateCust(model);
if (newCustId > 0)
{
// Order cannot exist - must create it
return(RedirectToAction(actionName: "Create", controllerName: "Order", routeValues: new { CustId = newCustId, IsCust = true }));
}
;
}
else
{
// Creating a New Customer
ModelState.AddModelError("", $"BarCode cannot be 0.");
ViewBag.BarCodeId = BuildBarCodeDropdown(model.BarCodeId);
return(View(model));
}
}
CustDetail existingCustDetail = service.GetCustByBarCodeId(model.BarCodeId);
if (!model.IsOrder)
{
// This is NOT an order, must validate that Barcode does not exist
if (existingCustDetail.BarCodeId != null && existingCustDetail.BarCodeId != 0)
{
ModelState.AddModelError("", $"BarCode '{existingCustDetail.BarCodeNumber}' is already assigned to {existingCustDetail.FirstName} {existingCustDetail.LastName}.");
ViewBag.BarCodeId = BuildBarCodeDropdown(model.BarCodeId);
return(View(model));
}
}
newCustId = service.CreateCust(model);
if (newCustId > 0)
{
if (model.IsOrder)
{
return(RedirectToAction(actionName: "Create", controllerName: "Order", routeValues: new { CustId = newCustId }));
}
TempData["SaveResult"] = $"'{model.FirstName} {model.LastName}' was created";
return(RedirectToAction("Index"));
}
;
ModelState.AddModelError("", $"'{model.FirstName} {model.LastName}' could not be created.");
ViewBag.BarCodeId = BuildBarCodeDropdown(model.BarCodeId);
return(View(model));
}
public ActionResult Edit(int id, CustUpdate model)
{
if (!ModelState.IsValid)
{
ViewBag.BarCodeId = BuildBarCodeDropdown((int)model.BarCodeId);
return(View(model));
}
if (model.CustomerId != id)
{
ModelState.AddModelError("", "Id Mismatch");
ViewBag.BarCodeId = BuildBarCodeDropdown((int)model.BarCodeId);
return(View(model));
}
var service = CreateCustomerService();
int barCodeIdParm = 0;
if (model.BarCodeId != null)
{
barCodeIdParm = (int)model.BarCodeId;
}
CustDetail existingCustDetail = service.GetCustByBarCodeId(barCodeIdParm);
if (existingCustDetail.BarCodeNumber != 0 && existingCustDetail.CustomerId != id)
{
ModelState.AddModelError("", $"BarCode '{existingCustDetail.BarCodeNumber}' is already assigned to {existingCustDetail.FirstName} {existingCustDetail.LastName}.");
ViewBag.BarCodeId = BuildBarCodeDropdown((int)model.BarCodeId);
return(View(model));
}
if (service.UpdateCust(model))
{
if (model.IsOrder)
{
var userId = User.Identity.GetUserId();
var orderHeaderService = new OrderService(userId);
var existingOrderHeader = orderHeaderService.GetOrderHeaderByCustId(id, false);
if (existingOrderHeader.OrderId == 0)
{
// Order does not Exist
return(RedirectToAction(actionName: "Create", controllerName: "Order", routeValues: new { CustId = id, IsCust = model.IsCust }));
}
// Order Exists
if (existingOrderHeader.PullStartedAt != null)
{
TempData["SaveResult"] = "We are assembling your order now. Your order can no longer be changed.";
return(RedirectToAction("Index", "Home"));
}
return(RedirectToAction(actionName: "Edit", controllerName: "Order", routeValues: new { Id = existingOrderHeader.OrderId, IsCust = model.IsCust }));
}
TempData["SaveResult"] = $"'{model.FirstName} {model.LastName}' was updated.";
return(RedirectToAction("Index"));
}
ModelState.AddModelError("", $"'{model.FirstName} {model.LastName}' could not be updated.");
ViewBag.BarCodeId = BuildBarCodeDropdown((int)model.BarCodeId);
return(View(model));
}
