internal static void UpdateClientGeneralInfo(ClientGeneralInformation generalInfo, ClientGeneralInformation oldGeneralInfo)
{
try
{
// Client Master
string query = string.Format(Constants.UPDATE_CLIENT_MASTER_QUERY, generalInfo.FirstName, generalInfo.LastName, "true", generalInfo.ClientCreatedOn, oldGeneralInfo.FileNo);
int result = DBHelper.ExecuteNonQuery(query);
// Client File Master
string caseTypeID = DBHelper.GetScalarValue(string.Format(Constants.CASE_TYPE_ID_QUERY, generalInfo.CaseType)).ToString();
string oldCaseTypeID = DBHelper.GetScalarValue(string.Format(Constants.CASE_TYPE_ID_QUERY, oldGeneralInfo.CaseType)).ToString();
query = string.Format(Constants.UPDATE_CLIENT_FILE_MASTER_QUERY, caseTypeID, generalInfo.AccidentDate.ToString(), generalInfo.CaseStatus, oldCaseTypeID, oldGeneralInfo.AccidentDate, oldGeneralInfo.CaseStatus, oldGeneralInfo.FileNo);
result = DBHelper.ExecuteNonQuery(query);
// Client Basic details
query = string.Format(Constants.UPDATE_CLIENT_BASIC_DETAILS_QUERY, generalInfo.Address, generalInfo.City, generalInfo.State, generalInfo.HomePhone, generalInfo.CellPhone, generalInfo.DrivingLicense, generalInfo.DateOfBirth.ToString(), generalInfo.SSN,
oldGeneralInfo.Address, oldGeneralInfo.City, oldGeneralInfo.State, oldGeneralInfo.HomePhone, oldGeneralInfo.CellPhone, oldGeneralInfo.DrivingLicense, oldGeneralInfo.DateOfBirth,
oldGeneralInfo.SSN, oldGeneralInfo.FileNo, generalInfo.Email, generalInfo.SuiteAddress, generalInfo.WorkPhone);
result = DBHelper.ExecuteNonQuery(query);
// Client Basic details
query = string.Format(Constants.UPDATE_CLIENT_CASE_INFO_QUERY, generalInfo.InitialCaseInformation, generalInfo.DefendantName, generalInfo.OriginatingAttorney, generalInfo.AssignedAttorney, generalInfo.Referral,
oldGeneralInfo.InitialCaseInformation, oldGeneralInfo.DefendantName, oldGeneralInfo.OriginatingAttorney, oldGeneralInfo.AssignedAttorney, oldGeneralInfo.Referral, oldGeneralInfo.FileNo);
result = DBHelper.ExecuteNonQuery(query);
}
catch (Exception ex)
{
throw ex;
}
}
internal static void SaveClientGeneralInfo(ClientGeneralInformation generalInfo)
{
try
{
// Client Master
string query = string.Format(Constants.INSERT_CLIENT_MASTER_QUERY, generalInfo.FirstName, generalInfo.LastName, "true", generalInfo.ClientCreatedOn);
int result = DBHelper.ExecuteNonQuery(query);
// Client File Master
string clientID = DBHelper.GetScalarValue(Constants.NEW_CLIENT_ID_QUERY).ToString();
string caseTypeID = DBHelper.GetScalarValue(string.Format(Constants.CASE_TYPE_ID_QUERY, generalInfo.CaseType)).ToString();
string accDate = generalInfo.AccidentDate == DateTime.MinValue ? string.Empty : generalInfo.AccidentDate.ToString("yyyy-MM-dd");
query = string.Format(Constants.INSERT_CLIENT_FILE_MASTER_QUERY, clientID, caseTypeID, accDate, generalInfo.CaseStatus, generalInfo.FileNo);
result = DBHelper.ExecuteNonQuery(query);
// Client Basic details
string dateOfBirth = generalInfo.DateOfBirth == DateTime.MinValue ? string.Empty : generalInfo.DateOfBirth.ToString("yyyy-MM-dd");
query = string.Format(Constants.INSERT_CLIENT_BASIC_DETAILS_QUERY, generalInfo.FileNo, generalInfo.Address,
generalInfo.City, generalInfo.State, generalInfo.HomePhone, generalInfo.CellPhone, generalInfo.DrivingLicense, dateOfBirth, generalInfo.SSN
, generalInfo.Email, generalInfo.WorkPhone, generalInfo.SuiteAddress);
result = DBHelper.ExecuteNonQuery(query);
// Client Case details
query = string.Format(Constants.INSERT_CLIENT_CASE_INFO_QUERY, generalInfo.FileNo, generalInfo.InitialCaseInformation, generalInfo.DefendantName, generalInfo.OriginatingAttorney, generalInfo.AssignedAttorney, generalInfo.Referral);
result = DBHelper.ExecuteNonQuery(query);
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void btnSaveEditGeneralClient_Click(object sender, RoutedEventArgs e)
{
try
{
ClientGeneralInformation generalInfo = new ClientGeneralInformation();
generalInfo.LastName = txtLastName.Text;
generalInfo.FirstName = txtFirstName.Text;
if (cmbCaseType.Text == "Other")
{
generalInfo.CaseType = txtOtherCaseType.Text;
}
else
{
generalInfo.CaseType = cmbCaseType.Text;
}
generalInfo.CaseStatus = cmbCaseStatus.Text;
if (dtAccidentDate.SelectedDate.Value != null)
{
generalInfo.AccidentDate = DateTime.Parse(dtAccidentDate.SelectedDate.Value.ToShortDateString());
}
generalInfo.ClientCreatedOn = DateTime.Now.ToShortDateString();
generalInfo.Address = txtAddress.Text;
generalInfo.City = txtCity.Text;
generalInfo.State = txtState.Text;
generalInfo.HomePhone = txtHomePhone.Text;
generalInfo.CellPhone = txtCellPhone.Text;
generalInfo.DrivingLicense = txtDrivingLicense.Text;
if (dtDateOfBirth.SelectedDate != null)
{
generalInfo.DateOfBirth = DateTime.Parse(dtDateOfBirth.SelectedDate.Value.ToShortDateString());
}
generalInfo.SSN = txtSSN.Text;
generalInfo.WorkPhone= txtWorkPhone.Text;
generalInfo.SuiteAddress= txtSuiteAddress.Text;
generalInfo.Email = txtEmail.Text;
generalInfo.InitialCaseInformation = txtInitialCaseInformation.Text;
generalInfo.DefendantName = txtDefendantName.Text;
generalInfo.OriginatingAttorney = txtOriginatingAttorney.Text;
generalInfo.AssignedAttorney = txtAssignedAttorney.Text;
generalInfo.Referral = txtRefferal.Text;
BusinessLogic.UpdateClientGeneralInfo(generalInfo, selectedGeneralInfo);
Helper.ShowInformationMessageBox("Client General Information Saved.");
btnCancelEditGeneralClient.IsEnabled = false;
btnSaveEditGeneralClient.IsEnabled = false;
btnEditGeneralClient.IsEnabled = true;
UpdateStatusGeneralSection(true);
ResetClientFileGridSelection();
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private void UpdateClientGeneralDetails()
{
try
{
selectedGeneralInfo = new ClientGeneralInformation();
selectedGeneralInfo.FileNo = txtFileNo.Text;
selectedGeneralInfo.LastName = txtLastName.Text;
selectedGeneralInfo.FirstName = txtFirstName.Text;
//TODO: check what is actual value for Other
if (cmbCaseType.Text == "Other")
{
selectedGeneralInfo.CaseType = txtOtherCaseType.Text;
}
else
{
selectedGeneralInfo.CaseType = cmbCaseType.Text;
}
selectedGeneralInfo.CaseStatus = cmbCaseStatus.Text;
if (dtAccidentDate.SelectedDate.Value != null)
{
selectedGeneralInfo.AccidentDate = DateTime.Parse(dtAccidentDate.SelectedDate.Value.ToShortDateString());
}
selectedGeneralInfo.Address = txtAddress.Text;
selectedGeneralInfo.City = txtCity.Text;
selectedGeneralInfo.State = txtState.Text;
selectedGeneralInfo.HomePhone = txtHomePhone.Text;
selectedGeneralInfo.CellPhone = txtCellPhone.Text;
selectedGeneralInfo.DrivingLicense = txtDrivingLicense.Text;
selectedGeneralInfo.DateOfBirth = DateTime.Parse(dtDateOfBirth.SelectedDate.Value.ToShortDateString());
selectedGeneralInfo.SSN = txtSSN.Text;
selectedGeneralInfo.SSN = txtSSN.Text;
selectedGeneralInfo.InitialCaseInformation = txtInitialCaseInformation.Text;
selectedGeneralInfo.DefendantName = txtDefendantName.Text;
selectedGeneralInfo.OriginatingAttorney = txtOriginatingAttorney.Text;
selectedGeneralInfo.AssignedAttorney = txtAssignedAttorney.Text;
selectedGeneralInfo.Referral = txtRefferal.Text;
selectedGeneralInfo.SuiteAddress = txtSuiteAddress.Text;
selectedGeneralInfo.WorkPhone = txtWorkPhone.Text;
selectedGeneralInfo.Email = txtEmail.Text;
}
catch (Exception ex)
{
Helper.LogException(ex);
}
}
private bool SaveClientGeneralDetails()
{
bool result = true;
try
{
ClientGeneralInformation generalInfo = new ClientGeneralInformation();
generalInfo.FileNo = txtFileNo.Text;
generalInfo.LastName = txtLastName.Text;
generalInfo.FirstName = txtFirstName.Text;
//TODO: check what is actual value for Other
if (cmbCaseType.Text == "Other")
{
generalInfo.CaseType = txtOtherCaseType.Text;
}
else
{
generalInfo.CaseType = cmbCaseType.Text;
}
generalInfo.CaseStatus = cmbCaseStatus.Text;
if (dtAccidentDate.SelectedDate != null && dtAccidentDate.SelectedDate.Value != null)
{
generalInfo.AccidentDate = DateTime.Parse(dtAccidentDate.SelectedDate.Value.ToShortDateString());
}
generalInfo.ClientCreatedOn = DateTime.Now.ToShortDateString();
generalInfo.Address = txtAddress.Text;
generalInfo.City = txtCity.Text;
generalInfo.State = txtState.Text;
generalInfo.HomePhone = txtHomePhone.Text;
generalInfo.CellPhone = txtCellPhone.Text;
generalInfo.DrivingLicense = txtDrivingLicense.Text;
if (dtDateOfBirth.SelectedDate != null && dtDateOfBirth.SelectedDate.Value != null)
{
generalInfo.DateOfBirth = DateTime.Parse(dtDateOfBirth.SelectedDate.Value.ToShortDateString());
}
generalInfo.SSN = txtSSN.Text;
generalInfo.WorkPhone= txtWorkPhone.Text;
generalInfo.Email= txtEmail.Text;
generalInfo.SuiteAddress = txtSuiteAddress.Text;
generalInfo.InitialCaseInformation = txtInitialCaseInformation.Text;
generalInfo.DefendantName = txtDefendantName.Text;
generalInfo.OriginatingAttorney = txtOriginatingAttorney.Text;
generalInfo.AssignedAttorney = txtAssignedAttorney.Text;
generalInfo.Referral = txtRefferal.Text;
result = BusinessLogic.SaveClientGeneralInfo(generalInfo);
}
catch (Exception ex)
{
Helper.LogException(ex);
}
return result;
}
internal static bool SaveClientGeneralInfo(ClientGeneralInformation generalInfo)
{
bool operationResult = true;
try
{
// Client Master
bool isClientIDExists = DBHelper.GetScalarValue(Constants.EXISTS_CLIENT_ID_QUERY).ToString() == "0";
string query = string.Empty;
string newclientID = string.Empty;
if (false == isClientIDExists)
{
newclientID = DBHelper.GetScalarValue(Constants.NEXT_CLIENT_ID_FROM_CLIENTFILEMASTER_QUERY).ToString();
query = string.Format(Constants.INSERT_CLIENT_MASTER_QUERY, generalInfo.FirstName, generalInfo.LastName, "true", generalInfo.ClientCreatedOn, newclientID);
//Helper.LogMessage("ClientID is already present. Using new from ClientFileMaster:" + newclientID);
//Helper.LogMessage("Save new client Query: " + query);
}
else
{
newclientID = DBHelper.GetScalarValue(Constants.NEXT_CLIENT_ID_FROM_CLIENTMASTER_QUERY).ToString();
query = string.Format(Constants.INSERT_CLIENT_MASTER_QUERY, generalInfo.FirstName, generalInfo.LastName, "true", generalInfo.ClientCreatedOn, newclientID);
//Helper.LogMessage("ClientID is not present. Using new from ClientMaster:" + newclientID);
//Helper.LogMessage("Save new client Query: " + query);
}
int result = DBHelper.ExecuteNonQuery(query);
// Client File Master
string clientID = DBHelper.GetScalarValue(Constants.NEW_CLIENT_ID_QUERY).ToString();
string caseTypeID = DBHelper.GetScalarValue(string.Format(Constants.CASE_TYPE_ID_QUERY, generalInfo.CaseType)).ToString();
string accDate = generalInfo.AccidentDate == DateTime.MinValue ? string.Empty : generalInfo.AccidentDate.ToString("yyyy-MM-dd");
query = string.Format(Constants.INSERT_CLIENT_FILE_MASTER_QUERY, clientID, caseTypeID, accDate, generalInfo.CaseStatus, generalInfo.FileNo);
result = DBHelper.ExecuteNonQuery(query);
// Client Basic details
string dateOfBirth = generalInfo.DateOfBirth == DateTime.MinValue ? string.Empty : generalInfo.DateOfBirth.ToString("yyyy-MM-dd");
query = string.Format(Constants.INSERT_CLIENT_BASIC_DETAILS_QUERY, generalInfo.FileNo, generalInfo.Address,
generalInfo.City, generalInfo.State, generalInfo.HomePhone, generalInfo.CellPhone, generalInfo.DrivingLicense, dateOfBirth, generalInfo.SSN
, generalInfo.Email, generalInfo.WorkPhone, generalInfo.SuiteAddress);
result = DBHelper.ExecuteNonQuery(query);
// Client Case details
query = string.Format(Constants.INSERT_CLIENT_CASE_INFO_QUERY, generalInfo.FileNo, generalInfo.InitialCaseInformation, generalInfo.DefendantName, generalInfo.OriginatingAttorney, generalInfo.AssignedAttorney, generalInfo.Referral);
result = DBHelper.ExecuteNonQuery(query);
}
catch (Exception ex)
{
Helper.LogException(ex);
operationResult = false;
}
return operationResult;
}
