public ActionResult EditContributor(Contributor c)
{
AddToDB db = new AddToDB(Properties.Settings.Default.ConStr);
db.EditContributor(c);
return(Redirect("/Home/Contributors"));
}
public ActionResult AddSimcha(Simcha s)
{
AddToDB db = new AddToDB(Properties.Settings.Default.ConStr);
db.AddSimcha(s);
return(Redirect("/"));
}
public ActionResult AddDeposit(Deposit d)
{
AddToDB db = new AddToDB(Properties.Settings.Default.ConStr);
db.AddDeposit(d);
return(Redirect("/Home/Contributors"));
}
// Use this for initialization
void Start()
{
if (AddToDB.instance != null)
{
Destroy(this);
}
else
{
instance = this;
}
}
public ActionResult AddContributor(Contributor c, decimal amount)
{
AddToDB db = new AddToDB(Properties.Settings.Default.ConStr);
int contributorId = db.AddContributor(c);
Deposit d = new Deposit();
d.Amount = amount;
d.ContributorId = contributorId;
d.Date = DateTime.Now;
db.AddDeposit(d);
return(Redirect("/Home/Contributors"));
}
private void ExecuteReplace()
{
Task.Run(() =>
{
_randomDataGenerator.ProgressValue = 0;
_onworking = true;
ReplaceDB.RaiseCanExecuteChanged();
AddToDB.RaiseCanExecuteChanged();
_randomDataGenerator.DeleteAll();
ExecuteAdd();
_onworking = false;
ReplaceDB.RaiseCanExecuteChanged();
AddToDB.RaiseCanExecuteChanged();
});
}
public bool ChangeAttachmentStatus(RequestToAdd request, Status status)
{
request.Status = status;
try
{
if (status == Status.Approved)
{
AddToDB.UpdatePatient(request.Patient);
AddToDB.UpdateOrganization(request.Organization);
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult UpdateContributors(List <PotentialContribution> contributions)
{
AddToDB db = new AddToDB(Properties.Settings.Default.ConStr);
foreach (PotentialContribution pc in contributions)
{
if (pc.IsContributing)
{
db.AddContribution(new Contribution()
{
ContributorId = pc.ContributorId,
SimchaId = pc.SimchaId,
Amount = (pc.Amount)
});
}
else
{
db.DeleteContribution(pc.ContributorId, pc.SimchaId);
}
}
return(Redirect("/Home/Index"));
}
static void CreatePatientList()
{
Random random = new Random();
Generator generator = new Generator();
int rr = random.Next(1, 10);
for (int i = 0; i < rr; i++)
{
Patient patient = new Patient();
string name = generator.GenerateDefault(Gender.man);
name = name.Replace("<center><b><font size=7>", "");
name = name.Replace("</font></b></center>", "");
name = name.Replace("\n", "");
string[] fullname = name.Split(' ');
patient.FName = fullname[0];
patient.LName = fullname[1];
patient.DoB = DateTime.Now.AddYears((random.Next(20, 90) * -1));
AddToDB.CreatePatient(patient);
}
}
private void ExecuteAdd()
{
Task.Run(() =>
{
_randomDataGenerator.ProgressValue = 0;
SafeInvoke(OnWork);
_onworking = true;
AddToDB.RaiseCanExecuteChanged();
ReplaceDB.RaiseCanExecuteChanged();
_randomDataGenerator.AddCountriesFromApi(numberOfCountries);
Message = _randomDataGenerator.Message;
_randomDataGenerator.AddCustomerToDB(numberOfCustomers);
Message = _randomDataGenerator.Message;
_randomDataGenerator.AddRandomAirlines(numberOfAirlines);
Message = _randomDataGenerator.Message;
_randomDataGenerator.AddRandomFlights(numberOfFlights);
Message = _randomDataGenerator.Message;
_randomDataGenerator.AddRandomTickets(numberOfTickets);
Message = _randomDataGenerator.Message;
_onworking = false;
AddToDB.RaiseCanExecuteChanged();
ReplaceDB.RaiseCanExecuteChanged();
});
}
public void AddRequest(RequestToAdd request)
{
AddToDB.CreateRequest(request);
}
public void AddOrganization(Organization organization)
{
AddToDB.CreateOrganization(organization);
}
public void AddUser(User user)
{
AddToDB.CreateUser(user);
}
public void AddPatient(Patient patient)
{
AddToDB.CreatePatient(patient);
}
public static void Menu()
{
bool inProgress = true;
while (inProgress)
{
ConsoleColor color = Console.ForegroundColor;
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t\tКУРЬЕРСКАЯ НАКЛАДНАЯ");
Console.WriteLine(new string('-', 50));
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t\tВыберите пункт меню:");
Console.WriteLine(new string('-', 50));
Console.WriteLine("1. Создать КН");
Console.WriteLine("2. Получить список всех КН");
Console.WriteLine("3. Получить информацию о всех КН");
Console.WriteLine("4. Выход");
Console.ForegroundColor = color;
int option = Convert.ToInt32(Console.ReadLine());
switch (option)
{
case 1:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t1. Создать КН");
Console.WriteLine(new string('-', 50));
//exPhoneExt phoneExt = new exPhoneExt();
//ServiceDelivery serviceDelivery = new ServiceDelivery();
//phoneExt = serviceDelivery.CreatePhone();
//AddToDB.CreatePhone(phoneExt);
//foreach (var item in AddToDB.ReturnAllPhones())
//{
// serviceDelivery.ShowPhones(item);
//}
//exAddressExt exAddressExt = new exAddressExt();
//ServiceDelivery serviceDelivery = new ServiceDelivery();
//exAddressExt = serviceDelivery.CreateAddress();
//AddToDB.CreateAddress(exAddressExt);
//foreach (var item in AddToDB.ReturnAllAddresses())
//{
// serviceDelivery.ShowAddress(item);
//}
exDelivery exDeliveryBusines = new exDelivery();
ServiceDelivery serviceDelivery = new ServiceDelivery();
exDeliveryBusines = serviceDelivery.CreateDelivery();
AddToDB.CreateExDeliveryExt(exDeliveryBusines);
foreach (exDelivery item in AddToDB.ReturnAllExDeliveryExt())
{
//serviceDelivery.ShowDelivery(item);
Console.WriteLine($"Id: {item.exDeliveryId}\n" +
$"RecipientName: {item.RecipientName}\n" +
$"SenderName: {item.SenderName}\n" +
$"RecipientContact: {item.RecipientContact}\n" +
$"SenderContact: {item.SenderContact}");
}
}
break;
case 2:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t2. Получить список всех КН");
Console.WriteLine(new string('-', 50));
exDelivery exDeliveryBusines = new exDelivery();
ServiceDelivery serviceDelivery = new ServiceDelivery();
//exDeliveryBusines = serviceDelivery.CreateDelivery();
//AddToDB.CreateExDeliveryExt(exDeliveryBusines);
foreach (exDelivery item in AddToDB.ReturnAllExDeliveryExt())
{
Console.WriteLine(new string('-', 50));
//serviceDelivery.ShowDelivery(item);
Console.WriteLine($"Id Курьерских Накладных: {item.exDeliveryId}");
Console.WriteLine(new string('-', 50));
}
}
break;
case 3:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t3. Получить информацию о всех КН");
Console.WriteLine(new string('-', 50));
exDelivery exDeliveryBusines = new exDelivery();
ServiceDelivery serviceDelivery = new ServiceDelivery();
//exDeliveryBusines = serviceDelivery.CreateDelivery();
//AddToDB.CreateExDeliveryExt(exDeliveryBusines);
foreach (exDelivery item in AddToDB.ReturnAllExDeliveryExt())
{
Console.WriteLine(new string('-', 50));
//serviceDelivery.ShowDelivery(item);
Console.WriteLine($"Id: {item.exDeliveryId}\n" +
$"RecipientName: {item.RecipientName}\n" +
$"SenderName: {item.SenderName}\n" +
$"RecipientContact: {item.RecipientContact}\n" +
$"SenderContact: {item.SenderContact}");
Console.WriteLine(new string('-', 50));
}
}
break;
case 4:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t\t4. Выход");
Console.WriteLine(new string('-', 50));
Console.ForegroundColor = ConsoleColor.DarkYellow;
Console.WriteLine("Спасибо!");
Console.ForegroundColor = color;
inProgress = false;
Console.WriteLine(new string('-', 50));
}
break;
default:
{
Console.WriteLine("Выберите пункт меню");
}
break;
}
}
}
public void AddExDeliveryExt(exDeliveryExt exDeliveryExt)
{
AddToDB.CreateExDeliveryExt(exDeliveryExt);
}
/// <InsertFileAndFolder>
/// get class parameter
/// and returns void
/// send the stored procedures query to the db connction
/// </summary>
/// <param name="newfileAndFolder"></param>
public void InsertFileAndFolder(SearchResult newfileAndFolder)
{
AddToDB.ExecDb($"EXECUTE AddFileAndFolder N'{newfileAndFolder.Files}',N'{newfileAndFolder.Folder}',N'{newfileAndFolder.FolderAndFile}'");
}
public void AddExDeliveryBusines(exDeliveryBusines exDeliveryBusines)
{
AddToDB.CreateExDeliveryBusiness(exDeliveryBusines);
}
public void AddAddress(exAddressExt exAddressExt)
{
AddToDB.CreateAddress(exAddressExt);
}
public void AddPhone(exPhoneExt exPhoneExt)
{
AddToDB.CreatePhone(exPhoneExt);
}
public void Updata_ID_To_LinkedTables(int searchID, int UserInputID)
{
AddToDB.ExecDb($"EXECUTE AddFK_Ids_To_LinkedTables '{searchID}','{UserInputID}'");
}
public void InsertUserInput(InputStringToserch newInput)
{
AddToDB.ExecDb($"EXECUTE AddUserInput N'{newInput.StringToserch}',N'{newInput.FolderToserch}'");
}
public static void Menu()
{
bool inProgress = true;
while (inProgress)
{
ConsoleColor color = Console.ForegroundColor;
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t\tМЕДИЦИНСКАЯ ОРГАНИЗАЦИЯ");
Console.WriteLine(new string('-', 50));
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t\tВыберите пункт меню:");
Console.WriteLine(new string('-', 50));
Console.WriteLine("1. Добавить User");
Console.WriteLine("2. Добавить Organization");
Console.WriteLine("3. Добавить Patient");
Console.WriteLine("4. Получить все User");
Console.WriteLine("5. Получить все Organization");
Console.WriteLine("6. Получить все Patient");
Console.WriteLine("7. Выход");
Console.ForegroundColor = color;
int option = Convert.ToInt32(Console.ReadLine());
switch (option)
{
case 1:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t1. Добавить User");
Console.WriteLine(new string('-', 50));
ServiceUser serviceUser = new ServiceUser();
User user = new User();
Console.Write("Введите имя: ");
user.FName = Console.ReadLine();
Console.Write("Введите фамилию: ");
user.LName = Console.ReadLine();
Console.Write("Введите отчество (при наличии): ");
user.MName = Console.ReadLine();
user.DoB = CreateDoB();
Console.Write("Назначьте роль: ");
user.Role = CreateRole();
Console.Write("Введите логин: ");
user.Login = Console.ReadLine();
Console.Write("Введите пароль: ");
user.Password = Console.ReadLine();
AddToDB.CreateUser(user);
Console.WriteLine(new string('-', 50));
Console.ForegroundColor = ConsoleColor.DarkBlue;
Console.WriteLine("Создан новый User");
Console.ForegroundColor = color;
serviceUser.ShowUser(user);
}
break;
case 2:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t2. Добавить Organization");
Console.WriteLine(new string('-', 50));
ServiceUser serviceUser = new ServiceUser();
Organization organization = new Organization();
Console.Write("Введите название организации: ");
organization.Name = Console.ReadLine();
Console.Write("Введите адрес организации: ");
organization.Address = Console.ReadLine();
Console.Write("Введите телефон организации: ");
organization.Phone = Console.ReadLine();
AddToDB.CreateOrganization(organization);
Console.WriteLine(new string('-', 50));
Console.ForegroundColor = ConsoleColor.DarkBlue;
Console.WriteLine("Создана новая Organization");
Console.ForegroundColor = color;
serviceUser.ShowOrganization(organization);
}
break;
case 3:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t3. Добавить Patient");
Console.WriteLine(new string('-', 50));
ServiceUser serviceUser = new ServiceUser();
Patient patient = new Patient();
User user = new User();
Organization organization = new Organization();
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.WriteLine("Выберите User по Id: ");
Console.ForegroundColor = color;
foreach (var item in AddToDB.ReturnAllUsers())
{
serviceUser.ShowUser(item);
}
int id = Convert.ToInt32(Console.ReadLine());
foreach (User item in AddToDB.ReturnAllUsers())
{
if (item.UserId == id)
{
user = item;
break;
}
}
patient.FName = user.FName;
patient.LName = user.LName;
patient.MName = user.MName;
patient.IIN = CreateIIN();
patient.DoB = user.DoB;
Console.WriteLine(new string('-', 50));
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.WriteLine("Выберите Organization по Id: ");
Console.ForegroundColor = color;
Console.WriteLine(new string('-', 50));
foreach (var item in AddToDB.ReturnAllOrganization())
{
serviceUser.ShowOrganization(item);
}
int idOrg = Convert.ToInt32(Console.ReadLine());
foreach (Organization item in AddToDB.ReturnAllOrganization())
{
if (item.OrganizationId == idOrg)
{
organization = item;
break;
}
}
patient.Organization = organization;
AddToDB.CreatePatient(patient);
Console.WriteLine(new string('-', 50));
Console.ForegroundColor = ConsoleColor.DarkBlue;
Console.WriteLine("Создан новый Patient");
Console.ForegroundColor = color;
serviceUser.ShowPatient(patient);
}
break;
case 4:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t4. Получить все User");
Console.WriteLine(new string('-', 50));
ServiceUser serviceUser = new ServiceUser();
foreach (var user in AddToDB.ReturnAllUsers())
{
serviceUser.ShowUser(user);
}
}
break;
case 5:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t5. Получить все Organization");
Console.WriteLine(new string('-', 50));
ServiceUser serviceUser = new ServiceUser();
foreach (var org in AddToDB.ReturnAllOrganization())
{
serviceUser.ShowOrganization(org);
}
}
break;
case 6:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t6. Получить все Patient");
Console.WriteLine(new string('-', 50));
ServiceUser serviceUser = new ServiceUser();
foreach (Patient pat in AddToDB.ReturnAllPatient())
{
serviceUser.ShowPatient(pat);
}
}
break;
case 7:
{
Console.WriteLine(new string('-', 50));
Console.WriteLine("\t\t7. Выход");
Console.WriteLine(new string('-', 50));
Console.ForegroundColor = ConsoleColor.DarkYellow;
Console.WriteLine("Спасибо!");
Console.ForegroundColor = color;
inProgress = false;
Console.WriteLine(new string('-', 50));
}
break;
default:
{
Console.WriteLine("Выберите пункт меню");
}
break;
}
}
}
public void AddExDeliveryBlitz(ExDeliveryBlitz exDeliveryBlitz)
{
AddToDB.CreateExDeliveryBlitz(exDeliveryBlitz);
}
public exDelivery CreateDelivery()
{
exDelivery exDeliveryBusines = new exDelivery();
ServiceDelivery serviceDelivery = new ServiceDelivery();
exPhoneExt exPhoneExt = new exPhoneExt();
exAddressExt exAddressExt = new exAddressExt();
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.WriteLine("Введите RecipientName: ");
Console.ForegroundColor = color;
exDeliveryBusines.RecipientName = Console.ReadLine();
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.WriteLine("Введите SenderName: ");
Console.ForegroundColor = color;
exDeliveryBusines.SenderName = Console.ReadLine();
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.WriteLine("Введите exPhoneRecipient по Id: ");
Console.ForegroundColor = color;
foreach (var item in AddToDB.ReturnAllPhones())
{
serviceDelivery.ShowPhones(item);
}
int id = Convert.ToInt32(Console.ReadLine());
foreach (exPhoneExt item in AddToDB.ReturnAllPhones())
{
if (item.exPhoneExtId == id)
{
exPhoneExt = item;
break;
}
}
exDeliveryBusines.exPhoneRecipient = exPhoneExt;
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.WriteLine("Введите exPhoneSender по Id: ");
Console.ForegroundColor = color;
foreach (var item in AddToDB.ReturnAllPhones())
{
serviceDelivery.ShowPhones(item);
}
id = Convert.ToInt32(Console.ReadLine());
foreach (exPhoneExt item in AddToDB.ReturnAllPhones())
{
if (item.exPhoneExtId == id)
{
exPhoneExt = item;
break;
}
}
exDeliveryBusines.exPhoneRecipient = exPhoneExt;
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.WriteLine("Введите RecipientContact по Id: ");
Console.ForegroundColor = color;
foreach (var item in AddToDB.ReturnAllAddresses())
{
serviceDelivery.ShowAddress(item);
}
id = Convert.ToInt32(Console.ReadLine());
foreach (exAddressExt item in AddToDB.ReturnAllAddresses())
{
if (item.exAddressExtId == id)
{
exAddressExt = item;
break;
}
}
exDeliveryBusines.RecipientContact = exAddressExt;
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.WriteLine("Введите SenderContact по Id: ");
Console.ForegroundColor = color;
foreach (var item in AddToDB.ReturnAllAddresses())
{
serviceDelivery.ShowAddress(item);
}
id = Convert.ToInt32(Console.ReadLine());
foreach (exAddressExt item in AddToDB.ReturnAllAddresses())
{
if (item.exAddressExtId == id)
{
exAddressExt = item;
break;
}
}
exDeliveryBusines.SenderContact = exAddressExt;
//Console.WriteLine("Введите KindTariffId: ");
//exDeliveryBusines.KindTariffId = Convert.ToInt32(Console.ReadLine());
//Console.WriteLine("Введите WeightActual: ");
//exDeliveryBusines.WeightActual = Convert.ToInt32(Console.ReadLine());
//Console.WriteLine("Введите WeightVolume: ");
//exDeliveryBusines.WeightVolume = Convert.ToInt32(Console.ReadLine());
return(exDeliveryBusines);
}
public AdditionModele()
{
Patients.AddRange(AddToDB.ReturnAllPatient());
Organizations.AddRange(AddToDB.ReturnAllOrganization());
}
