public App()
{
InitializeComponent();
DependencyService.Register <MockDataStore>();
MainPage = new LoginPage();
clientDataController = new ClientDataController();
merchandiserDataController = new MerchandiserDataController();
merchandisingTicketDataController = new MerchandisingTicketDataController();
userDataController = new UserDataController();
}
public ActionResult UpdateClient(Client currentClient)
{
bool success;
ClientDataController dataController = new ClientDataController();
success = dataController.UpdateClient(currentClient);
Session["client"] = currentClient;
GetAllLists();
return(View("Client_Update", currentClient));
}
public Client InsertClient(Client newClient)
{
DbCommand ins_Client = db.GetStoredProcCommand("ins_Client");
db.AddInParameter(ins_Client, "@raceID", DbType.Int32, newClient.raceID);
db.AddInParameter(ins_Client, "@ethnicityID", DbType.Int32, newClient.ethnicityID);
db.AddInParameter(ins_Client, "@clientStatusID", DbType.Int32, newClient.clientStatusID);
db.AddInParameter(ins_Client, "@primaryLanguageID", DbType.Int32, newClient.primaryLanguageID);
db.AddInParameter(ins_Client, "@schoolInfoID", DbType.Int32, newClient.schoolInfoID);
db.AddInParameter(ins_Client, "@communicationPreferencesID", DbType.Int32, newClient.communicationPreferencesID);
db.AddInParameter(ins_Client, "@sexID", DbType.Int32, newClient.sexID);
db.AddInParameter(ins_Client, "@officeID", DbType.Int32, newClient.officeID);
db.AddInParameter(ins_Client, "@firstName", DbType.String, newClient.firstName);
db.AddInParameter(ins_Client, "@middleInitial", DbType.String, newClient.middleInitial);
db.AddInParameter(ins_Client, "@lastName", DbType.String, newClient.lastName);
db.AddInParameter(ins_Client, "@dob", DbType.Date, newClient.dob);
db.AddInParameter(ins_Client, "@ssn", DbType.Int32, newClient.ssn);
db.AddInParameter(ins_Client, "@referralSource", DbType.String, newClient.referralSource);
db.AddInParameter(ins_Client, "@intakeDate", DbType.Date, (DateTime)System.Data.SqlTypes.SqlDateTime.Parse(DateTime.Now.ToString()));
db.AddInParameter(ins_Client, "@ifspDate", DbType.Date, (DateTime)System.Data.SqlTypes.SqlDateTime.Parse(newClient.ifspDate.ToString()));
db.AddInParameter(ins_Client, "@compSvcDate", DbType.Date, (DateTime)System.Data.SqlTypes.SqlDateTime.Parse(newClient.compSvcDate.ToString()));
db.AddInParameter(ins_Client, "@serviceAreaException", DbType.Boolean, newClient.serviceAreaException);
db.AddInParameter(ins_Client, "@tkidsCaseNumber", DbType.Int32, newClient.TKIDcaseNumber);
db.AddInParameter(ins_Client, "@consentToRelease", DbType.Boolean, newClient.consentRelease);
db.AddInParameter(ins_Client, "@eci", DbType.String, newClient.ECI);
db.AddInParameter(ins_Client, "@accountingSystemID", DbType.String, newClient.accountingSystemID);
db.AddOutParameter(ins_Client, "@success", DbType.Boolean, 1);
db.AddOutParameter(ins_Client, "@clientID", DbType.Int32, sizeof(int));
try
{
db.ExecuteNonQuery(ins_Client);
newClient.clientID = Convert.ToInt32(db.GetParameterValue(ins_Client, "@clientID"));
newClient.altID = StringTool.Truncate(newClient.lastName, 4).ToUpper() + StringTool.Truncate(newClient.firstName, 4).ToUpper() + newClient.clientID.ToString();
ClientDataController clientDataController = new ClientDataController();
bool success = clientDataController.UpdateClient(newClient);
}
catch (Exception e)
{
Debug.WriteLine("InsertClient failed, exception: {0}", e);
throw;
}
return(newClient);
}
public ActionResult GetClient(string identifier)
{
if (Session["client"] != null)
{
int clientID;
int.TryParse(identifier, out clientID);
Client currentClient = new Client();
currentClient.clientID = clientID;
ClientDataController dataController = new ClientDataController();
currentClient = dataController.GetClient(currentClient.clientID);
Session["client"] = currentClient;
}
GetAllLists();
return(PartialView("Client_Partial"));
}
/************************************************************************** DELETE ********************************************************/
public ActionResult DeleteClient(Client deletingClient)
{
if (Session["client"] == null)
{
return(View());
}
else
{
deletingClient = (Client)Session["client"];
bool success;
ClientDataController dataController = new ClientDataController();
// Flags as deleted on the DB the client demographic information and the client Address.
success = dataController.DeleteClient(deletingClient);
success = dataController.DeleteClientAddress(deletingClient);
// Flags as deleted all family assigned to patient.
foreach (var family in deletingClient.clientFamily)
{
success = dataController.DeleteClientFamily(family);
}
// Flags as deleted all insurance assigned to patient.
foreach (var insurance in deletingClient.clientInsurance)
{
success = dataController.DeleteClientInsurance(insurance, deletingClient);
}
// Flags as deleted all staff assigned to patient.
foreach (var staff in deletingClient.clientStaff)
{
success = dataController.DeleteClientStaff(staff, deletingClient);
}
// Flags as deleted all diagnoses assigned to patient.
foreach (var diagnosis in deletingClient.clientDiagnosis)
{
success = dataController.DeleteClientDiagnosis(diagnosis, deletingClient);
}
// Flags as deleted all comments assigned to patient.
foreach (var comment in deletingClient.clientComments)
{
success = dataController.DeleteClientComment(comment, deletingClient);
}
// Flags as deleted all physician assigned to patient.
foreach (var physician in deletingClient.clientPhysicians)
{
success = dataController.DeleteClientPhysician(physician, deletingClient);
}
// Removes current client from session to assign a blank client.
Client newClient = new Client();
Session["client"] = newClient;
// Returns blank client to form.
return(View("Client_Update", newClient));
}
}
