public ActionResult Post([FromBody] Administer administer)
{
if (__AdministerDataProvider.RegisterAdmin(administer))
{
return(Ok("register sucessfully"));
}
return(BadRequest("user already exists"));
}
public bool ModifyInfromation(Administer administer, string id)
{
using (var db = new dimsContext())
{
var query = db.Administer
.FirstOrDefault(q => q.Ano == id);
query = administer;
return(true);
}
}
/// <summary>
/// 根据楼栋号查询楼管
/// </summary>
/// <param name="bno">楼栋号</param>
/// <returns>宿管号</returns>
public Administer CheckRaThoughBno(string bno)
{
#region
using (var dbcontext = new dimsContext())
{
var building = dbcontext.Studentbuilding
.FirstOrDefault(b => b.Bno == bno);
string ano = building.Ano;
Administer administer = CheckRaThoughID(ano);
return(administer);
}
#endregion
}
public static List <List <Person> > Sammelband = new List <List <Person> >(); //Сборник
static void Main(string[] args)
{
//Выборка: 1. Имена рабочих заданной профессии /// 2. Имена рабочих заданного цеха
//Счётчик: 1. Кол-во инженеров на работе
//Использование операций над множествами: Пересечение, объединение, разность
//Агрегирование: 1. Средний возраст людей какой-либо профессии
#region add
Abteilung.Add(new Administer("First", "Last", 22, "Enemy"));
Abteilung.Add(new Engineer("List", "T", 29, "Ice", "Effect"));
Abteilung.Add(new Worker("FName", "LName", 34, "Friend"));
Abteilung.Add(new Engineer("John", "Junior", 49, "Cold", "Visual"));
Abteilung.Add(new Worker("Sub", "Zero", 18, "Counter"));
Abteilung.Add(new Engineer("Linked", "T", 29, "Ice", "Effect"));
Abteilung.Add(new Engineer("Roman", "Triumpf", 39, "Rezus", "Factor"));
Administer adm = new Administer("Slesh", "Gta", 52, "Coldest");
Abteilung.Add(adm);
Unternehmen.Add(new Administer("Scorpion", "Sheet", 28, "Strike"));
Unternehmen.Add(new Worker("First", "Of", 28, "All"));
Unternehmen.Add(adm);
Sammelband.Add(Abteilung);
Sammelband.Add(Unternehmen);
#endregion
CollectionShow();
Console.WriteLine();
PrintColor("Выборка: 1. Имена рабочих заданной профессии (Администратор).", ConsoleColor.Red);
NameWorkersLinq();
Sammelband.NameWorkersExpansion("Administer");
Console.WriteLine();
PrintColor("Выборка: 2. Имена рабочих заданного цеха.", ConsoleColor.Red);
Console.Write("Введите название цеха: ");
string nameWorkShop = Console.ReadLine();
NameWorkersWorkShopLinq(nameWorkShop);
Sammelband.NameWorkersWorkShop(nameWorkShop);
Console.WriteLine();
PrintColor("Счётчик 1: Кол-во инженеров на работе", ConsoleColor.Red);
CountEngineerLinq();
Sammelband.CounterEngineerExpansion();
Console.WriteLine();
PrintColor("Операции над множествами", ConsoleColor.Red);
IntersectionUnionDifferenceLinq();
Sammelband.IntersectionUnionDifferenceExpansion();
Console.WriteLine();
PrintColor("1. Агрегирование: Средний возраст людей какой-либо профессии", ConsoleColor.Red);
Console.Write("Введите профессию: ");
string nameWork = Console.ReadLine();
AgregateAverageAgeLinq(nameWork);
Sammelband.AgregateAverageAgeExpansion(nameWork);
}
/// <summary>
/// 增加宿管
/// </summary>
/// <param name="ra">代表宿管</param>
/// <returns>成功返回true</returns>
public bool AddRa(Administer ra)
{
#region
try
{
using (var dbcontext = new dimsContext())
{
dbcontext.Administer.Add(ra);
dbcontext.SaveChanges();
return(true);
}
}
catch (Exception e)
{
return(false);
}
#endregion
}
static void Main(string[] args)
{
MyNewCollection myFirstCollection = new MyNewCollection("First");
MyNewCollection mySecondCollection = new MyNewCollection("Second");
Journal jounFirst = new Journal();
Journal jounSecond = new Journal();
//Подписки
myFirstCollection.CollectionCountChanged += jounFirst.CollectionCountChanged;
myFirstCollection.CollectionReferenceChanged += jounFirst.CollectionReferenceChanged;
myFirstCollection.CollectionReferenceChanged += jounSecond.CollectionReferenceChanged;
mySecondCollection.CollectionReferenceChanged += jounSecond.CollectionReferenceChanged;
//Добавление в 1
Administer adm = new Administer("For", "The", 31, "Republic");
myFirstCollection.Add(adm);
myFirstCollection.Add(new Administer("q", "ad", 22, "frin"));
myFirstCollection.Add(new Administer("Press", "F", 22, "To"));
myFirstCollection.Add(new Administer("Pay", "Respect", 22, "Yeah"));
myFirstCollection.Add(new Administer("America", "Fk", 22, "Yeah"));
myFirstCollection.Add(new Worker("Pusk", "Analiz", 90, "Task"));
myFirstCollection.Add(new Administer("Sborka", "Otladka", 22, "Test"));
Console.WriteLine("First Collection");
myFirstCollection.Remove(1);
myFirstCollection.Remove(3);
Engineer Eng = new Engineer("Jenni", "Stronger", 29, "Federation", "Fast");
myFirstCollection[0] = Eng;
myFirstCollection[1] = new Worker("Done", "Fstrin", 29, "Key");
Console.WriteLine(jounFirst.ToString());
Console.WriteLine("\nВторая коллекция \n ");
//Добавление во 2
mySecondCollection.Add(new Worker("Rammstein", "Deutschland", 23, "Austrong"));
mySecondCollection.Add(new Worker("Diamant", "Frau", 31, "Das"));
mySecondCollection.Add(new Administer("Auf", "Wieldersahen", 39, "Der"));
mySecondCollection.Add(new Engineer("Und", "Katze", 32, "Hug", "Apfel"));
mySecondCollection.Add(new Engineer("Jerry", "Dimka", 20, "Open", "Tuberkulez"));
mySecondCollection.Remove(2);
mySecondCollection[3] = new Administer("Done", "Frau", 29, "Ice");
Console.WriteLine(jounSecond.ToString());
Console.ReadLine();
}
/// <summary>
//更改宿管信息
/// </summary>
/// <param name="id">宿管id</param>
/// <param name="ra">宿管对象</param>
/// <returns>成功返回true</returns>
public bool ModifyRa(string id, Administer ra)
{
#region
using (var dbcontext = new dimsContext())
{
var admin = dbcontext.Administer
.Single(r => r.Ano == id);
if (admin != null)
{
admin = ra;
dbcontext.SaveChanges();
return(true);
}
else
{
return(false);
}
}
#endregion
}
public bool RegisterAdmin(Administer administer)
{
var email = administer.Email;
administer.Pass_word = HashAndSalt.HashSalt(administer.Pass_word);
using (IDbConnection dbConnection = Connection)
{
string sQuery0 = "SELECT FirstName FROM Administer WHERE Email = @email";
dbConnection.Open();
String result = dbConnection.QueryFirstOrDefault <String>(sQuery0, new { @Email = email });
dbConnection.Close();
if (string.IsNullOrEmpty(result))
{
string sQuery = "INSERT INTO Administer(FirstName,LastName,Pass_word,Email,MobileNo)" +
"VALUES(@FirstName,@LastName,@Pass_word,@Email,@MobileNo)";
dbConnection.Open();
dbConnection.Execute(sQuery, administer);
return(true);
}
}
return(false);
}
static void Main(string[] args)
{
Console.WriteLine("Лаб. 12. Решетняк");
//Task12.1
//===================================================================================================================================================
Console.WriteLine("\nTask12.1\n");
Console.WriteLine("Удалить из списка первый элемент с четным информационным полем. \n");
int counter = 1;
LinkedList <Person> list = new LinkedList <Person>();
list.Add(new Worker("Fedor", "Solyanov", 22, "Fire"));
list.Add(new Administer("Fire", "Loading", 29, "Legolas"));
list.Add(new Engineer("Leonid", "Pirogov", 28, "Fire", "Lego"));
list.Add(new Worker("People", "Stronger", 34, "Fire"));
Administer ADM = new Administer("Fire", "Anakin", 30, "Lego");
list.Add(ADM);
foreach (Person WRK in list)
{
Console.WriteLine(counter + " " + WRK.Show());
counter++;
}
Console.WriteLine();
Console.WriteLine("Удаление первого чётного элемента");
Console.WriteLine("Удаленный элемент - " + list.FindEven(2).Data.Show() + "\n");
list.Delete(list.FindEven(2).Data);
// list.Delete(ADM);
counter = 1;
foreach (Person item in list)
{
Console.WriteLine(counter + " " + item.Show());
counter++;
}
Console.WriteLine();
list.Clear();
if (list.Count == 0)
{
Console.WriteLine("Однонаправленный список удалён");
}
Console.WriteLine("Нажмите, чтобы продолжить");
Console.ReadLine();
//Task12.2
//===================================================================================================================================================
Console.WriteLine("Task12.2\n");
Console.WriteLine("Добавить в список элементы с номерами 1, 3, 5 и т. д.\n");
int counterDva = 1;
DoubleList <Person> doubleList = new DoubleList <Person>();
doubleList.Add(new Worker("AMD", "loser", 12, "Fire"));
doubleList.Add(new Administer("fire", "lol", 24, "Loading"));
Worker workWalk = new Worker("Anime", "LoL", 22, "TEST");
doubleList.Add(workWalk);
foreach (Person item in doubleList)
{
Console.WriteLine(counterDva + " " + item.Show());
counterDva++;
}
counterDva = 1;
Console.WriteLine();
Console.WriteLine("Добавить в список элементы с номерами 1, 3, 5 и т. д.");
foreach (Person item in doubleList.FindUnEven())
{
Console.WriteLine(counterDva + " " + item.Show());
counterDva++;
}
doubleList.Clear();
if (doubleList.count == 0)
{
Console.WriteLine("Двунаправленный список удалён");
}
Console.WriteLine("Нажмите, чтобы продолжить");
Console.ReadLine();
//Task12.2
//===================================================================================================================================================
Console.WriteLine("\nTask 12.3\n");
Console.WriteLine("Оригинальное дерево:");
Console.WriteLine(" 5 ");
Console.WriteLine(" / \\ ");
Console.WriteLine(" 3 8 ");
Console.WriteLine(" / \\ / \\ ");
Console.WriteLine(" 1 4 7 9 ");
Console.WriteLine(" \\ / ");
Console.WriteLine(" 2 6 ");
Tree <Worker> intTree = new Tree <Worker>();
intTree.Add(new Worker("Da", "Net", 5, "Fire"));
intTree.Add(new Worker("Da", "Net", 3, "Fire"));
intTree.Add(new Worker("Da", "Net", 8, "Fire"));
intTree.Add(new Worker("Da", "Net", 7, "Fire"));
intTree.Add(new Worker("Da", "Net", 4, "Fire"));
intTree.Add(new Worker("Da", "Net", 1, "Fire"));
intTree.Add(new Worker("Da", "Net", 2, "Fire"));
intTree.Add(new Worker("Da", "Net", 6, "Fire"));
intTree.Add(new Worker("Da", "Net", 9, "Fire"));
Console.WriteLine("Префиксный");
foreach (Worker IntTree in intTree.Preorder())
{
Console.WriteLine(IntTree.Show() + " / ");
}
Console.WriteLine("\nПостфиксный\n");
foreach (Worker IntTree in intTree.Postorder())
{
Console.WriteLine(IntTree.Show() + " / ");
}
Console.WriteLine("\nИнфиксный\n");
foreach (Worker IntTree in intTree.Inorder())
{
Console.WriteLine(IntTree.Show() + " / ");
}
Console.WriteLine("Длина дерева: " + Convert.ToString(intTree.MaxHeight(intTree.Root)));
Console.WriteLine("Общее количество элементов: " + Convert.ToString(intTree.Count()));
intTree.Clear();
if (intTree.Count() == 0)
{
Console.WriteLine("Дерево удалено");
}
Console.ReadLine();
}
