//INIT PIPELINE ACTIVITIES
/**
* not used currently
*/
public Activity create_Activity_Init_1()
{
Console.WriteLine("Creating " + DualLoadConfig.ACTIVITY_INIT_1);
Activity activity = new Activity();
List <ActivityInput> activityInputs = new List <ActivityInput>();
ActivityInput activityInput = new ActivityInput();
activityInput.Name = DualLoadConfig.DATASET_ETL_Control;
activityInputs.Add(activityInput);
SqlSource source = new SqlSource();
source.SqlReaderQuery = DualLoadConfig.QUERY_INIT_1;
List <ActivityOutput> activityOutputs = new List <ActivityOutput>();
ActivityOutput activityOutput = new ActivityOutput();
activityOutput.Name = DualLoadConfig.DATASET_LOAD_1_SQLDUMMY;
activityOutputs.Add(activityOutput);
SqlSink sink = new SqlSink();
CopyActivity copyActivity = new CopyActivity();
copyActivity.Source = source;
copyActivity.Sink = sink;
activity.Name = DualLoadConfig.ACTIVITY_INIT_1;
activity.Inputs = activityInputs;
activity.Outputs = activityOutputs;
activity.TypeProperties = copyActivity;
return(activity);
}
public ListResultDto <ActivityListDto> GetActivity(ActivityInput input)
{
var act = _activityRepository
.GetAll();
var query = act
.WhereIf(
!input.Filter.IsNullOrWhiteSpace(),
u =>
u.ActivityCode.Contains(input.Filter) ||
u.ActivityName.Contains(input.Filter) ||
u.ColorCode.Contains(input.Filter))
.ToList();
return(new ListResultDto <ActivityListDto>(query.MapTo <List <ActivityListDto> >()));
}
//ARCHIVE PIPELINE ACTIVITIES
/**
* CopyActivity from Blob source to Blob sink from ToBeProcessed Folder to Archived Folder
*/
public Activity create_Activity_Archive_2(String toBeProcessedCompleteFolderDataset, String archiveFolderDataset, int i)
{
Console.WriteLine("Creating " + DualLoadConfig.ACTIVITY_ARCHIVE_2 + "_" + i);
Activity activity = new Activity();
List <ActivityInput> activityInputs = new List <ActivityInput>();
ActivityInput activityInput = new ActivityInput();
activityInput.Name = toBeProcessedCompleteFolderDataset;
activityInputs.Add(activityInput);
List <ActivityOutput> activityOutputs = new List <ActivityOutput>();
ActivityOutput activityOutput = new ActivityOutput();
activityOutput.Name = archiveFolderDataset + "_" + i;
activityOutputs.Add(activityOutput);
CopyActivity copyActivity = new CopyActivity();
BlobSource blobSource = new BlobSource();
copyActivity.Source = blobSource;
//blobSource.Recursive = true;
BlobSink sink = new BlobSink();
sink.CopyBehavior = "PreserveHierarchy";
//sink.WriteBatchSize = 10000;
//sink.WriteBatchTimeout = TimeSpan.FromMinutes(10);
copyActivity.Sink = sink;
//Scheduler scheduler = new Scheduler();
//scheduler.Frequency = SchedulePeriod.Hour;
//scheduler.Interval = 1;
activity.Name = DualLoadConfig.ACTIVITY_ARCHIVE_2 + "_" + i;
activity.Inputs = activityInputs;
activity.Outputs = activityOutputs;
activity.TypeProperties = copyActivity;
//activity.Scheduler = scheduler;
return(activity);
}
public ActionResult Save(CodeTableViewModel.CodeCategory category, CodeTableViewModel ctvm)
{
if (ctvm == null)
{
return(RedirectToAction("Index"));
}
switch (category)
{
case CodeTableViewModel.CodeCategory.Medicine:
if (ctvm.Medicine != null)
{
Medicine medicine = DB.Medicines.FirstOrDefault(x => x.MedicineId == ctvm.Medicine.MedicineId);
if (medicine == null)
{
if (DB.Medicines.Count(x => x.Code == ctvm.Medicine.Code) > 0)
{
return(View("Edit", ctvm));
}
medicine = new Medicine();
DB.Medicines.Add(medicine);
}
medicine.Active = true;
medicine.Title = ctvm.Medicine.Title;
medicine.Code = ctvm.Medicine.Code;
medicine.Cost = ctvm.Medicine.Cost;
DB.SaveChanges();
}
break;
case CodeTableViewModel.CodeCategory.Contractor:
if (ctvm.Contractor != null)
{
Contractor contractor = DB.Contractors.FirstOrDefault(x => x.ContractorId == ctvm.Contractor.ContractorId);
if (contractor == null)
{
if (DB.Contractors.Count(x => x.Number == ctvm.Contractor.Number) > 0)
{
ctvm.PostOffices = DB.PostOffices.ToList();
return(View("Edit", ctvm));
}
contractor = new Contractor();
DB.Contractors.Add(contractor);
}
contractor.Active = true;
contractor.Number = ctvm.Contractor.Number;
contractor.Title = ctvm.Contractor.Title;
contractor.Address = ctvm.Contractor.Address;
contractor.PostOffice = DB.PostOffices.FirstOrDefault(x => x.PostOfficeId == ctvm.Contractor.PostOffice.PostOfficeId);
DB.SaveChanges();
}
break;
case CodeTableViewModel.CodeCategory.Disease:
if (ctvm.Disease != null)
{
Disease disease = DB.Diseases.FirstOrDefault(x => x.DiseaseId == ctvm.Disease.DiseaseId);
if (disease == null)
{
if (DB.Diseases.Count(x => x.Code == ctvm.Disease.Code) > 0)
{
return(View("Edit", ctvm));
}
disease = new Disease();
DB.Diseases.Add(disease);
}
disease.Active = true;
disease.Code = ctvm.Disease.Code;
disease.Description = ctvm.Disease.Description;
DB.SaveChanges();
}
break;
case CodeTableViewModel.CodeCategory.Relationship:
if (ctvm.Relationship != null)
{
Relationship relationship = DB.Relationships.FirstOrDefault(x => x.RelationshipId == ctvm.Relationship.RelationshipId);
if (relationship == null)
{
relationship = new Relationship();
DB.Relationships.Add(relationship);
}
relationship.Name = ctvm.Relationship.Name;
relationship.Active = true;
DB.SaveChanges();
}
break;
case CodeTableViewModel.CodeCategory.Service:
if (ctvm.Service != null)
{
Service service = DB.Services.FirstOrDefault(x => x.ServiceId == ctvm.Service.ServiceId);
if (service == null)
{
if (DB.Services.Count(x => x.ServiceCode == ctvm.Service.ServiceCode) > 0)
{
return(View("Edit", ctvm));
}
service = new Service();
DB.Services.Add(service);
}
service.Active = true;
service.ServiceCode = ctvm.Service.ServiceCode;
service.ServiceTitle = ctvm.Service.ServiceTitle;
service.PreventiveVisit = ctvm.Service.PreventiveVisit;
service.RequiresMedicine = ctvm.Service.RequiresMedicine;
service.RequiresBloodSample = ctvm.Service.RequiresBloodSample;
service.RequiresPatients = ctvm.Service.RequiresPatients;
service.Cost = ctvm.Service.Cost;
DB.SaveChanges();
}
break;
case CodeTableViewModel.CodeCategory.Activity:
Activity activity = DB.Activities.FirstOrDefault(x => x.ActivityId == ctvm.Activity.ActivityId);
if (activity == null)
{
if (DB.Activities.Count(x => x.ActivityCode == ctvm.Activity.ActivityCode) > 0)
{
return(View("Edit", ctvm));
}
activity = new Activity();
DB.Activities.Add(activity);
}
activity.Active = true;
activity.ActivityCode = ctvm.Activity.ActivityCode;
activity.ActivityTitle = ctvm.Activity.ActivityTitle;
//activity.ActivityInputFor = ctvm.Activity.ActivityInputFor;
DB.SaveChanges();
break;
case CodeTableViewModel.CodeCategory.ActivityInput:
ActivityInput activityInput = DB.ActivityInputs.FirstOrDefault(x => x.ActivityInputId == ctvm.ActivityInput.ActivityInputId);
if (activityInput == null)
{
activityInput = new ActivityInput();
DB.ActivityInputs.Add(activityInput);
}
activityInput.Active = true;
activityInput.Title = ctvm.ActivityInput.Title;
activityInput.InputType = ctvm.ActivityInput.InputType;
activityInput.PossibleValues = ctvm.ActivityInput.PossibleValues;
DB.SaveChanges();
break;
case CodeTableViewModel.CodeCategory.Role:
Role role = DB.Roles.FirstOrDefault(x => x.RoleId == ctvm.Role.RoleId);
if (role == null)
{
role = new Role();
DB.Roles.Add(role);
}
role.Title = ctvm.Role.Title;
DB.SaveChanges();
break;
case CodeTableViewModel.CodeCategory.JobTitle:
JobTitle jobTitle = DB.JobTitles.FirstOrDefault(x => x.JobTitleId == ctvm.JobTitle.JobTitleId);
if (jobTitle == null)
{
jobTitle = new JobTitle();
DB.JobTitles.Add(jobTitle);
}
jobTitle.Active = true;
jobTitle.Title = ctvm.JobTitle.Title;
DB.SaveChanges();
break;
default:
throw new ArgumentOutOfRangeException(nameof(category), category, null);
}
DB.SaveChanges();
ctvm = new CodeTableViewModel();
ctvm.Category = category;
return(RedirectToAction("Index", ctvm));
}
public ActionResult Delete(CodeTableViewModel.CodeCategory category, int id)
{
switch (category)
{
case CodeTableViewModel.CodeCategory.Medicine:
Medicine medicine = DB.Medicines.FirstOrDefault(x => x.MedicineId == id);
if (medicine != null)
{
medicine.Active = !medicine.Active;
}
//DB.Medicines.Remove(medicine);
break;
case CodeTableViewModel.CodeCategory.Contractor:
Contractor contractor = DB.Contractors.FirstOrDefault(x => x.ContractorId == id);
if (contractor != null)
{
contractor.Active = !contractor.Active;
}
//DB.Contractors.Remove(contractor);
break;
case CodeTableViewModel.CodeCategory.Disease:
Disease disease = DB.Diseases.FirstOrDefault(x => x.DiseaseId == id);
if (disease != null)
{
disease.Active = !disease.Active;
}
//DB.Diseases.Remove(disease);
break;
case CodeTableViewModel.CodeCategory.Relationship:
Relationship relationship = DB.Relationships.FirstOrDefault(x => x.RelationshipId == id);
if (relationship != null)
{
relationship.Active = !relationship.Active;
}
//DB.Relationships.Remove(relationship);
break;
case CodeTableViewModel.CodeCategory.Service:
Service service = DB.Services.FirstOrDefault(x => x.ServiceId == id);
if (service != null)
{
service.Active = !service.Active;
}
//DB.Services.Remove(service);
break;
case CodeTableViewModel.CodeCategory.Activity:
Activity activity = DB.Activities.FirstOrDefault(x => x.ActivityId == id);
if (activity != null)
{
activity.Active = !activity.Active;
}
//DB.Activities.Remove(activity);
break;
case CodeTableViewModel.CodeCategory.ActivityInput:
ActivityInput activityInput = DB.ActivityInputs.FirstOrDefault(x => x.ActivityInputId == id);
if (activityInput != null)
{
activityInput.Active = !activityInput.Active;
}
//DB.ActivityInputs.Remove(activityInput);
break;
case CodeTableViewModel.CodeCategory.Role:
Role role = DB.Roles.FirstOrDefault(x => x.RoleId == id);
if (role != null)
{
role.Active = !role.Active;
}
//DB.Roles.Remove(role);
break;
case CodeTableViewModel.CodeCategory.JobTitle:
JobTitle jobTitle = DB.JobTitles.FirstOrDefault(x => x.JobTitleId == id);
if (jobTitle != null)
{
jobTitle.Active = !jobTitle.Active;
}
//DB.JobTitles.Remove(jobTitle);
break;
default:
throw new ArgumentOutOfRangeException(nameof(category), category, null);
}
DB.SaveChanges();
CodeTableViewModel ctvm = new CodeTableViewModel();
ctvm.Category = category;
return(RedirectToAction("Index", ctvm));
}
