protected void btnAdd_Click(object sender, EventArgs e)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
Petient petient = new Petient();
petient.Id = Guid.NewGuid();
petient.First_Name = txtFirstName.Text;
petient.Last_Name = txtLastName.Text;
petient.Sex = ddlSex.Text;
petient.Age = short.Parse(txtAge.Text);
petient.Job = txtJob.Text;
petient.Country = txtCountry.Text;
petient.City = txtCity.Text;
petient.City_Location = txtCityLocation.Text;
petient.Address = txtAddress.Text;
petient.Mobile = txtMobile.Text;
petient.Phone = txtPhone.Text;
petient.Email = txtEmail.Text;
if (ddlIntro.Text != SharedClass.GetIntroducer(SharedClass.IntroType.Others))
{
petient.Introducer = ddlIntro.Text;
}
else
{
petient.Introducer = txtIntro.Text;
}
mc.Petients.Add(petient);
mc.SaveChanges();
grvPetient.EditIndex = -1;
}
}
protected void btnSet_Click(object sender, EventArgs e)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var petientId = Guid.Parse(Request["ID"]);
var selectedService = (ucServicesControl.SelectedService != ucServicesControl.OthersValue) ? ucServicesControl.SelectedService : null;
var selectedParts = ucServicesControl.SelectedParts;
var dateToVisit = cal.Date.Value;
var timeToVisit = TimePickerControl.Time.TimeOfDay;
var visitingTimeDate = new DateTime(dateToVisit.Year, dateToVisit.Month, dateToVisit.Day, timeToVisit.Hours, timeToVisit.Minutes, 0);
var allocatedTime = allocateTimeForPetient(visitingTimeDate, ddlDoctor.SelectedValue, ddlTech.SelectedValue, selectedService);
if (allocatedTime == null)
{
//TODO: Error on allocating time
return;
}
Petient_Visiting_Financial visitingFile = new Petient_Visiting_Financial();
visitingFile.TimeVisitStarts = allocatedTime[0]; //Start
visitingFile.TimeVisitEnds = allocatedTime[1]; //End
visitingFile.Is_Petient_Returned = false;
visitingFile.Is_Money_Paid = false;
visitingFile.Is_Petient_Visited = false;
visitingFile.Is_Petient_Canceled = false;
if (ucServicesControl.SelectedService != ucServicesControl.OthersValue)
{
visitingFile.Money_To_Pay = costOfService(ucServicesControl.SelectedService);
visitingFile.Reason = null;
}
else
{
visitingFile.Money_To_Pay = 0;
visitingFile.Reason = ucServicesControl.ReasonValue;
}
visitingFile.Money_Changed = 0;
visitingFile.Money_Paid_Cash = 0;
visitingFile.Money_Paid_Card = 0;
visitingFile.POS_Name = null;
int lastBalance = 0;
var petientVisitingFiles = mc.Connectors.Where(o => o.PetientId == petientId && o.FinancialId != null
&& o.Petient_Visiting_Financials.TimeVisitStarts < visitingFile.TimeVisitStarts)
.OrderByDescending(o => o.Petient_Visiting_Financials.TimeVisitStarts).ToList();
if (petientVisitingFiles.Count() != 0)
{
lastBalance = petientVisitingFiles.First().Petient_Visiting_Financials.Balance;
}
visitingFile.Balance = lastBalance + visitingFile.Money_To_Pay;
mc.Petient_Visiting_Financials.Add(visitingFile);
createConnections(mc, selectedService, petientId, visitingFile.Id, selectedParts);
mc.SaveChanges();
}
}
protected void Page_Load(object sender, EventArgs e)
{
makeTree();
using(Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
rptService.DataSource = services;
rptService.DataBind();
}
}
protected void btnDeleteFile_Click(object sender, EventArgs e)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var btnDelete = (Button)sender;
long fileId = long.Parse(btnDelete.CommandArgument);
mc.Petient_Files.Remove(mc.Petient_Files.Where(o => o.Id == fileId).First());
mc.SaveChanges();
}
}
public static void EditConnectorObjectsFileByFinancialId(
Medical_Clinic_Entities mc,
long? Financial,
long? File
)
{
var connectors = mc.Connectors.Where(o => o.FinancialId == Financial).ToList();
foreach (var connector in connectors)
{
connector.FileId = File;
}
}
private void makeTree()
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
foreach (var service in mc.BSI__Clinic_Services.Where(o => o.Parent_Id == null).ToList())
{
services.Add(service);
aligmentString.Add(service.Id, "  ");
findChild(service, "  ");
}
}
}
protected bool isProvidingService(object obj)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var id = Request["ID"];
var employeeServices = mc.BSI__Clinic_Employees.Where(o => o.Id == id).First().BSI__Employee_Service_Set.ToList();
if (employeeServices.Where(o => o.Service_Id == (int)obj).Count() != 0)
{
return true;
}
}
return false;
}
public static List<BSI__Clinic_Employee> GetAllEmployees()
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
if (SharedClass.IsUserAdminOrOperator(SharedClass.CurrentUser) == true)
{
return mc.BSI__Clinic_Employees.Where( o => o.Is_Active == true).ToList();
}
else
{
return mc.BSI__Clinic_Employees.Where(o => o.Id == SharedClass.CurrentUser).ToList();
}
}
}
protected string getPersonToVisit(object id, SharedClass.RelationType relation)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var visitingFile = mc.Petient_Visiting_Financials.Where(o => o.Id == (long)id).First();
var persons = visitingFile.Connectors.Where(o => o.RelationType == SharedClass.GetRelationType(relation)).ToList();
if (persons.Count() != 0)
{
return persons.First().BSI__Clinic_Employees.First_Name + " " + persons.First().BSI__Clinic_Employees.Last_Name;
}
else
{
return nobody;
}
}
}
private void findChild(BSI__Clinic_Service currentService, string alignment)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
foreach (var service in mc.BSI__Clinic_Services.Where(o => o.Parent_Id == currentService.Id).ToList())
{
services.Add(service);
string currentAlignment = "     " + alignment;
aligmentString.Add(service.Id, currentAlignment);
if (service.BSI__Clinic_Services_Child.Count() != 0)
{
findChild(service, currentAlignment);
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
foreach (RepeaterItem item in rptService.Items)
{
var chkService = ((CheckBox)item.FindControl("chkService"));
int serviceId = int.Parse(((Label)item.FindControl("lblId")).Text);
short minsForService = short.Parse(((TextBox)item.FindControl("txtMinsForService")).Text);
var txtPortion = ((TextBox)item.FindControl("txtPortion"));
var employeeId = Request["ID"];
var currentEmployeeService = mc.BSI__Employee_Service_Set.Where(o => o.Employee_Id == employeeId && o.Service_Id == serviceId).ToList();
if (chkService.Checked == true && chkService.Enabled == true)
{
if (currentEmployeeService.Count() == 0)
{
BSI__Employee_Service employeeService = new BSI__Employee_Service();
employeeService.Service_Id = serviceId;
employeeService.Employee_Id = employeeId;
employeeService.Mins_For_Service = minsForService;
mc.BSI__Employee_Service_Set.Add(employeeService);
addPart(employeeService.Service_Id, employeeId);
}
else
{
currentEmployeeService.First().Mins_For_Service = minsForService;
editPart(currentEmployeeService.First().Service_Id, employeeId);
}
}
else if(chkService.Enabled == true)
{
if (currentEmployeeService.Count() != 0)
{
mc.BSI__Employee_Service_Set.Remove(currentEmployeeService.First());
deletePart(currentEmployeeService.First().Service_Id, employeeId);
}
}
}
mc.SaveChanges();
}
}
protected void btnSignUp_Click(object sender, EventArgs e)
{
if (txtPassword.Text != txtVerifyPassword.Text)
{
lblErrorSignup.Text = passNotTheSame;
return;
}
else
{
lblErrorSignup.Text = "";
}
var userStore = new UserStore<IdentityUser>();
var userManager = new UserManager<IdentityUser>(userStore);
var user = new IdentityUser() { UserName = txtUsername.Text, Email = txtEmail.Text, EmailConfirmed = true };
IdentityResult result = userManager.Create(user, txtPassword.Text);
if (result.Succeeded == true)
{
result = userManager.AddToRole(user.Id, ddlRole.Text);
if (result.Succeeded == true)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
BSI__Clinic_Employee employee = new BSI__Clinic_Employee();
employee.Id = user.Id;
employee.First_Name = txtFirstName.Text;
employee.Last_Name = txtLastName.Text;
employee.Created_Date = DateTime.Now;
employee.Last_Login = DateTime.Now;
employee.Job_Clinic = ddlJobClinic.Text;
mc.BSI__Clinic_Employees.Add(employee);
mc.SaveChanges();
}
}
lblErrorSignup.Text = "";
}
else
{
lblErrorSignup.Text = result.Errors.First();
}
}
protected void btnEditFile_Click(object sender, EventArgs e)
{
var fileId = long.Parse(((Button)sender).CommandArgument);
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var financial = mc.Connectors.Where(o => o.FileId == fileId && o.FinancialId != null).FirstOrDefault();
if (financial == null)
{
Response.Redirect("~/Operator/File_Petient_Edit.aspx?ID=" + fileId);
}
else
{
Response.Redirect("~/Operator/File_Petient_Edit.aspx?ID=" + fileId + "&FinancialID=" + financial.FinancialId);
}
}
}
protected void btnCancel_Click(object sender, EventArgs e)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var financialId = (Request["FinancialID"] != null) ? long.Parse(Request["FinancialID"]) : (long?)null;
long fileId = long.Parse(Request["ID"]);
var fileToEdit = mc.Petient_Files.Where(o => o.Id == fileId).First();
if (financialId == null)
{
Response.Redirect("~/File_Petient.aspx?ID=" + fileToEdit.Connectors.First().Petient.Id);
}
else
{
Response.Redirect("~/File_Petient.aspx?ID=" + fileToEdit.Connectors.First().Petient.Id + "&FinancialID=" + financialId);
}
}
}
public void getServicesOfFile(long? financialId, out string reason, out int? service, out List<int> parts)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
if (financialId != null)
{
var financial = mc.Petient_Visiting_Financials.Where(o => o.Id == financialId).First();
parts = new List<int>();
if (financial.Reason != null)
{
reason = financial.Reason;
service = null;
parts = null;
}
else
{
reason = null;
service = mc.Connectors.Where(o => o.FinancialId == financialId && o.BSI__Clinic_Services.Is_Part != true).First().BSI__Clinic_Services.Id;
parts = mc.Connectors.Where(o => o.FinancialId == financialId && o.BSI__Clinic_Services.Is_Part == true)
.GroupBy(o => o.ServiceId).Select(o => o.FirstOrDefault().ServiceId.Value).ToList();
}
}
else
{
service = (ucServicesControl.SelectedService != ucServicesControl.OthersValue) ? ucServicesControl.SelectedService : null;
parts = ucServicesControl.SelectedParts;
if (service != null)
{
reason = null;
}
else
{
reason = ucServicesControl.ReasonValue;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var currentEmployee = mc.BSI__Clinic_Employees.Where(o => o.Id == SharedClass.CurrentUser).First();
lblWelcomeUser.Text = currentEmployee.First_Name + " " + currentEmployee.Last_Name + welcome;
}
lblCurrentTime.Text = today + FarsiLibrary.Utils.PersianDate.Now.ToString("d");
//Links Visibility :
lnkDefault.Visible = SharedClass.HasUserProperAccess(SharedClass.CurrentUser, SharedClass.AccessType.Default);
lnkPetientManagement.Visible = SharedClass.HasUserProperAccess(SharedClass.CurrentUser, SharedClass.AccessType.Petient_Management);
lnkUserManagement.Visible = SharedClass.HasUserProperAccess(SharedClass.CurrentUser, SharedClass.AccessType.User_Management);
lnkServiceManagement.Visible = SharedClass.HasUserProperAccess(SharedClass.CurrentUser, SharedClass.AccessType.Service_Management);
lnkTimeManagement.Visible = SharedClass.HasUserProperAccess(SharedClass.CurrentUser, SharedClass.AccessType.Time_Management);
lnkTimeManagement.Visible = SharedClass.HasUserProperAccess(SharedClass.CurrentUser, SharedClass.AccessType.CostList);
lnkReports.Visible = SharedClass.HasUserProperAccess(SharedClass.CurrentUser, SharedClass.AccessType.Reports);
lnkStatistics.Visible = SharedClass.HasUserProperAccess(SharedClass.CurrentUser, SharedClass.AccessType.Statistics);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
petientsToShow = mc.Petients.ToList();
if (txtFirstNameSearch.Text != "")
{
petientsToShow = petientsToShow.Where(o => o.First_Name.Contains(txtFirstNameSearch.Text)).ToList();
}
if (txtLastNameSearch.Text != "")
{
petientsToShow = petientsToShow.Where(o => o.Last_Name.Contains(txtLastNameSearch.Text)).ToList();
}
if (txtMobileSearch.Text != "")
{
petientsToShow = petientsToShow.Where(o => o.Mobile.Contains(txtMobileSearch.Text)).ToList();
}
}
grvPetient.EditIndex = -1;
}
protected void btnEdit_Click(object sender, EventArgs e)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var financialId = (Request["FinancialID"] != null) ? long.Parse(Request["FinancialID"]) : (long?)null;
long fileId = long.Parse(Request["ID"]);
var fileToEdit = mc.Petient_Files.Where(o => o.Id == fileId).First();
if (fileToEdit.Connectors.Where(o => o.FinancialId != null).Count() != 0)
{
fileToEdit.Details = txtDetailsFinancial.Text;
}
else
{
string reason = null;
int? selectedService = null;
List<int> selectedParts = null;
getServicesOfFile(financialId, out reason, out selectedService, out selectedParts);
fileToEdit.Details = txtDetails.Text;
fileToEdit.Reason = reason;
createRemoveConnections(mc, selectedService, fileToEdit.Connectors.First().Petient.Id, fileId, selectedParts);
}
mc.SaveChanges();
if (financialId == null)
{
Response.Redirect("~/File_Petient.aspx?ID=" + fileToEdit.Connectors.First().Petient.Id);
}
else
{
Response.Redirect("~/File_Petient.aspx?ID=" + fileToEdit.Connectors.First().Petient.Id + "&FinancialID=" + financialId);
}
}
}
public static void CreateConnectorObject(
Medical_Clinic_Entities mc,
string Employee,
int? Service,
int? EmployeeService,
Guid Petient,
long? File,
long? Financial,
SharedClass.RelationType RelationType
)
{
var connector = new Connector();
connector.EmployeeId = Employee;
connector.ServiceId = Service;
connector.EmployeeServiceId = EmployeeService;
connector.PetientId = Petient;
connector.FileId = File;
connector.FinancialId = Financial;
connector.RelationType = SharedClass.GetRelationType(RelationType);
connector.CreatedDate = DateTime.Now;
mc.Connectors.Add(connector);
}
protected void login_Authenticate(object sender, AuthenticateEventArgs e)
{
var userStore = new UserStore<IdentityUser>();
var manager = new UserManager<IdentityUser>(userStore);
var user = manager.Find(login.UserName, login.Password);
if (user != null)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var employee = mc.BSI__Clinic_Employees.Where(o => o.Id == user.Id).First();
if(employee.Is_Active != true)
{
return;
}
employee.Last_Login = DateTime.Now;
mc.SaveChanges();
}
FormsAuthentication.RedirectFromLoginPage(user.Id, false);
}
}
public static void CreateConnectorObject(
Medical_Clinic_Entities mc,
string Employee,
List<int> Parts,
Guid Petient,
long? File,
long? Financial,
SharedClass.RelationType RelationType
)
{
foreach (var part in Parts)
{
ModelClass.CreateConnectorObject(
mc,
Employee,
part,
mc.BSI__Employee_Service_Set.Where(o => o.Employee_Id == Employee && o.Service_Id == part).First().Id,
Petient,
File,
Financial,
RelationType
);
}
}
public static List<BSI__Employee_Service> GetEmployeesOfSelectedService(int? selectedServiceId, string specifiedEmployee = null)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
if (selectedServiceId == null)
{
return null;
}
if (SharedClass.IsUserAdminOrOperator(SharedClass.CurrentUser) == true)
{
if (specifiedEmployee == null)
{
return mc.BSI__Employee_Service_Set.Include("BSI__Clinic_Employees").Where(o => o.Service_Id == selectedServiceId && o.BSI__Clinic_Employees.Is_Active == true).ToList();
}
else
{
return mc.BSI__Employee_Service_Set.Include("BSI__Clinic_Employees").Where(o => o.Service_Id == selectedServiceId && o.Employee_Id == specifiedEmployee && o.BSI__Clinic_Employees.Is_Active == true).ToList();
}
}
else
{
if (specifiedEmployee == null)
{
return mc.BSI__Employee_Service_Set.Include("BSI__Clinic_Employees").Where(o => o.Service_Id == selectedServiceId && o.Employee_Id == SharedClass.CurrentUser).ToList();
}
else
{
return mc.BSI__Employee_Service_Set.Include("BSI__Clinic_Employees").Where(o => o.Service_Id == selectedServiceId && o.Employee_Id == SharedClass.CurrentUser && o.Employee_Id == specifiedEmployee).ToList();
}
}
}
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var grvUsersDataSource = mc.AspNetUsers.Join(mc.BSI__Clinic_Employees, oOutter => oOutter.Id, oInner => oInner.Id, (user, employee) => new
{
Id = user.Id,
User_Name = user.UserName,
First_Name = employee.First_Name,
Last_Name = employee.Last_Name,
Email = user.Email,
Created_Date = employee.Created_Date,
Last_Login = employee.Last_Login,
Job_Clinic = employee.Job_Clinic,
Is_Active = employee.Is_Active
}).OrderBy(o => o.Last_Name).ToList();
grvUsers.DataSource = grvUsersDataSource;
grvUsers.DataBind();
}
ddlJobClinic.DataSource = SharedClass.JobClinic;
ddlJobClinic.DataBind();
}
public static short? GetParentServiceStandardValue(long? FinancialId)
{
//We only calculate parent services values as a unit for "cost per unit" not parts !
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var financial = mc.Petient_Visiting_Financials.Where(o => o.Id == FinancialId).First();
if (financial.Reason == null)
{
var service = financial.Connectors.Where(o => o.BSI__Clinic_Services.Is_Part != true).First().BSI__Clinic_Services;
return service.Unit_Standard_Value;
}
else
{
return null;
}
}
}
public static void RemoveConnectorObjectUsingFinancialId(
long? Financial,
SharedClass.RelationType RelationType
)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
string relation = SharedClass.GetRelationType(RelationType);
var connectorToRemove = mc.Connectors.Where(o => o.FinancialId == Financial && o.RelationType == relation).ToList();
if (connectorToRemove.Count() != 0)
{
mc.Connectors.RemoveRange(connectorToRemove);
mc.SaveChanges();
}
}
}
public static string GetUnitName(long? FinancialId)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var financial = mc.Petient_Visiting_Financials.Where(o => o.Id == FinancialId).First();
if (financial.Reason == null)
{
var service = financial.Connectors.Where(o => o.BSI__Clinic_Services.Is_Part != true).First().BSI__Clinic_Services;
return service.Unit_Name;
}
else
{
return null;
}
}
}
public static string GetTitleOfFile(
long? FileId,
long? FinancialId
)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
if (FinancialId != null)
{
var financial = mc.Petient_Visiting_Financials.Where(o => o.Id == FinancialId).First();
if (financial.Reason == null)
{
var service = financial.Connectors.Where(o => o.BSI__Clinic_Services.Is_Part != true).First();
var parts = financial.Connectors.Where(o => o.BSI__Clinic_Services != null && o.BSI__Clinic_Services.Is_Part == true)
.GroupBy(o => o.BSI__Clinic_Services.Service_Name).Select(o => o.First()).ToList();
var serviceName = service.BSI__Clinic_Services.Service_Name;
if (parts.Count() != 0)
{
serviceName += " : ";
foreach (var part in parts)
{
serviceName += part.BSI__Clinic_Services.Service_Name;
serviceName += "، ";
}
}
return serviceName;
}
else
{
return financial.Reason;
}
}
else if (FileId != null)
{
var file = mc.Petient_Files.Where(o => o.Id == FileId).First();
if (file.Reason == null)
{
var service = file.Connectors.Where(o => o.BSI__Clinic_Services != null && o.BSI__Clinic_Services.Is_Part != true).FirstOrDefault();
var parts = file.Connectors.Where(o => o.BSI__Clinic_Services != null && o.BSI__Clinic_Services.Is_Part == true)
.GroupBy(o => o.BSI__Clinic_Services.Service_Name).Select(o => o.First()).ToList();
var serviceName = service.BSI__Clinic_Services.Service_Name;
if (parts.Count() != 0)
{
serviceName += " : ";
foreach (var part in parts)
{
serviceName += part.BSI__Clinic_Services.Service_Name;
serviceName += "، ";
}
}
return serviceName;
}
else
{
return file.Reason;
}
}
}
return "";
}
public static List<BSI__Clinic_Service> GetServicesOfFinancial(long? FinancialId)
{
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
var services = new List<BSI__Clinic_Service>();
var financial = mc.Petient_Visiting_Financials.Where(o => o.Id == FinancialId).First();
if (financial.Reason == null)
{
var service = financial.Connectors.Where(o => o.BSI__Clinic_Services.Is_Part != true).First().BSI__Clinic_Services;
var parts = financial.Connectors.Where(o => o.BSI__Clinic_Services != null && o.BSI__Clinic_Services.Is_Part == true)
.GroupBy(o => o.BSI__Clinic_Services.Service_Name).Select(o => o.First().BSI__Clinic_Services).ToList();
services.Add(service);
services.AddRange(parts);
return services;
}
else
{
return null;
}
}
}
public static int? GetSelectedServiceEmployee(int? serviceId, string employeeId)
{
int othersValue = -1;
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
if (serviceId == null || serviceId == othersValue)
{
return null;
}
else
{
var employee = mc.BSI__Employee_Service_Set.Where(o => o.Service_Id == serviceId && o.Employee_Id == employeeId && o.BSI__Clinic_Employees.Is_Active == true);
if (employee.Count() != 0)
{
return employee.First().Id;
}
else
{
return null;
}
}
}
}
public static List<Petient_File> GetPetientFiles(
Guid PetientId,
long? FinancialId,
out bool HasFinancialOneFile
)
{
HasFinancialOneFile = false;
using (Medical_Clinic_Entities mc = new Medical_Clinic_Entities())
{
List<Connector> connectors = mc.Petients.Where(o => o.Id == PetientId).First().Connectors.ToList(); ;
if (FinancialId != null)
{
if (connectors.Where(o => o.FinancialId == FinancialId && o.PetientId == PetientId && o.FileId != null).Count() != 0)
{
HasFinancialOneFile = true;
}
var currentFinancialFile = mc.Petient_Visiting_Financials.Where(o => o.Id == FinancialId).First();
connectors = connectors.Where(o => o.Petient_Visiting_Financials != null)
.Where(o => o.Petient_Visiting_Financials.TimeVisitStarts <= currentFinancialFile.TimeVisitStarts).ToList();
}
return connectors.Where(o => o.PetientId == PetientId && o.FileId != null).Select(o => o.Petient_Files).Distinct().ToList();
}
}