public long AddDprUser(PersonObject user)
{
try
{
if (user == null)
{
return(-2);
}
var userEntity = ModelMapper.Map <PersonObject, Person>(user);
if (userEntity == null || userEntity.ImporterId < 1)
{
return(0);
}
using (var db = new ImportPermitEntities())
{
var existings = db.People.Where(b => b.FirstName.Trim().ToLower().Replace(" ", "") == user.FirstName.Trim().ToLower().Replace(" ", "") && b.LastName.Trim().ToLower().Replace(" ", "") == user.LastName.Trim().ToLower().Replace(" ", "")).ToList();
if (existings.Any())
{
return(0);
}
var res = db.People.Add(userEntity);
db.SaveChanges();
return(res.Id);
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public PersonDetailsViewModel()
{
try
{
if (DesignerProperties.GetIsInDesignMode(new DependencyObject()))
{
return;
}
PersonObject = ObjectMessenger.FindObject("PersonObject");
LinkedAddresses = new ObservableCollection <skAddresses>(PersonObject.LinkedAddresses);
_SubmitChangesCommand = new Command(PersonObject.Update);
_RemoveAddressCommand = new Command(() => { PersonObject.RemoveLinkedAddress(SelectedObject.AddressID); });
_LinkAddressCommand = new Command(LinkAddressMethod);
_SubmitAddressLinkCommand = new Command(SubmitAddressLinkMethod);
_AddNewAddressCommand = new Command(AddNewAddressMethod);
ObjectSourceList = new ObservableCollection <skAddresses>(skAddresses.GetAddressList());
}
catch (Exception e)
{
ExepionLogger.Logger.LogException(e);
ExepionLogger.Logger.Show(e);
}
}
public long AddPersonInfo(PersonObject user)
{
try
{
if (user == null)
{
return(-2);
}
var userEntity = ModelMapper.Map <PersonObject, Person>(user);
if (userEntity == null || userEntity.ImporterId < 1)
{
return(0);
}
using (var db = new ImportPermitEntities())
{
var banks = db.Banks.Where(b => b.ImporterId == user.ImporterId).ToList();
if (!banks.Any())
{
return(0);
}
var res = db.People.Add(userEntity);
db.SaveChanges();
return(res.Id);
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public void UpdateDB(PersonObject person, COMMAND command, object value, SQLConnectionSettings s)
{
try
{
MySqlConnection con = Connect(s);
string QuerySelect = "select * from " + s.Database + "." + s.TableName + " where " + command.ToString() + "=" + value + ";";
ExecuteSQLCommand(QuerySelect, con);
con = Connect(s);
string QueryUpdate = "update " + s.Database + "." + s.TableName + " SET " +
"Grad='" + person.Grad + "'," +
"Name='" + person.Name + "'," +
"Vorname='" + person.Vorname + "'," +
"PicturePath='" + person.PhotoPath + "'," +
"IsChecked='" + Convert.ToInt32(person.IsCheckedIn) + "'," +
"CardID='" + person.CardID + "'," +
"CheckInTime='" + person.CheckInTime.ToString() + "'," +
"CheckOutTime='" + person.CheckOutTime.ToString() + "'" +
"where " + command.ToString() + " = " + value + ";";
ExecuteSQLCommand(QueryUpdate, con);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static PersonViewModel Create(PersonObject o)
{
var v = new PersonViewModel()
{
ID = o?.DbRecord.ID,
IDCode = o?.DbRecord.IDCode,
FirstName = o?.DbRecord.FirstName,
LastName = o?.DbRecord.LastName,
Address = o?.DbRecord.Address,
Email = o?.DbRecord.Email,
PhoneNumber = o?.DbRecord.PhoneNumber,
GetMedicineInfo = o?.DbRecord.GetMedicineInfo ?? GetMedicineInfo.Teadmata
};
if (o is null)
{
return(v);
}
v.ValidFrom = setNullIfExtremum(o.DbRecord.ValidFrom);
v.ValidTo = setNullIfExtremum(o.DbRecord.ValidTo);
foreach (var c in o.MedicinesInUse)
{
var product = MedicineViewModelFactory.Create(c);
v.MedicinesInUse.Add(product);
}
return(v);
}
public ClientForm(string keyName, IPresenterProperty presenter)
{
InitializeComponent();
_person = PersonObject.GetLink(keyName) ?? new Person();
_logic = Logic.GetInstance();
_presenter = presenter;
}
public PersonObject isSearch(List <PersonObject> _personList)
{
string Barcode = getBarCode();
var personObject = new PersonObject();
bool isExist = false;
foreach (var person in _personList)
{
if (person.PersonBarcode == Barcode)
{
personObject.Name = person.Name;
personObject.Address = person.Address;
isExist = true;
}
}
if (isExist)
{
return(personObject);
}
else
{
return(null);
}
}
static void Main(string[] args)
{
Console.WriteLine(new HelloWorldProxy().GetMessage());
PersonObject myPer = new PersonObject();
new PersonObject().CreateObjects();
new PersonObject().CreateStructs();
Console.WriteLine("Press any key to exit.");
Console.ReadKey();
}
/// <summary>
/// Возвращает DialogResult.OK Если успешно всё выбрали
/// </summary>
public static DialogResult RunWorkoutOptionsForm(ref WorkoutOptions optionsWorkout, string personName)
{
// Если нет Персональных или Аэробных тренировок - не выводить окно выбора тренировок. По умолчанию отмечается Тренажерный зал
var abon = PersonObject.GetLink(personName)?.AbonementCurent;
if (abon == null)
{
return(DialogResult.Cancel);
}
optionsWorkout.TypeWorkout = abon.TypeWorkout; // Значение по умолчанию
// установка праметров и выход в свитче
switch (abon)
{
case ClubCardA clubCardA:
{
if (clubCardA.NumPersonalTr == 0 && clubCardA.NumAerobicTr == 0 && clubCardA.NumMiniGroup == 0)
{
optionsWorkout.TypeWorkout = TypeWorkout.Тренажерный_Зал;
return(DialogResult.OK);
}
break;
}
case AbonementByDays byDays:
{
if (byDays.TypeWorkout == TypeWorkout.Тренажерный_Зал)
{
// Возвращаем текущий тип тренировки
//optionsWorkout.TypeWorkout = abon.TypeWorkout;
return(DialogResult.OK);
}
break;
}
case SingleVisit singleVisit:
{
if (singleVisit.TypeWorkout == TypeWorkout.Тренажерный_Зал)
{
return(DialogResult.OK);
}
break;
}
}
// если не вышли , то запуск формы опций
var workoutForm = new WorkoutForm(personName);
var dlgReult = workoutForm.ShowDialog();
if (dlgReult == DialogResult.OK)
{
optionsWorkout = workoutForm.SelectedOptions;
}
return(dlgReult);
}
static void Main(string[] args)
{
var services = new ServiceCollection();
services.AddEventLogging();
// var provider = services.BuildServiceProvider();
// IMPORTANT! Register our application entry point
//services.AddTransient<PersonObject>();
Console.WriteLine("Hello World!");
PersonObject person = new PersonObject(null);
}
private void checkedListBox_Tren_Name_SelectedIndexChanged(object sender, EventArgs e)
{
var checkedIndexes = checkedListBox_Tren_Name.CheckedIndices;
var pList = new List <Person>();
_reqTrenName = _personsAll.Values;
if (checkedIndexes.Count != 0)
{
foreach (var item in checkedIndexes)
{
var checkedItemString = checkedListBox_Tren_Name.Items[(int)item].ToString();
var indexOfBrace = checkedItemString.IndexOf('(');
string trimmedCheckedItemString;
if (indexOfBrace > 0)
{
trimmedCheckedItemString = checkedItemString.Substring(0, checkedItemString.IndexOf('(')).Trim();
}
else
{
trimmedCheckedItemString = checkedItemString;
}
var r2 = _aerobVisits.Where(x =>
{
string groupTrName = x.GroupTimeName;
if (groupTrName.Contains("("))
{
groupTrName = groupTrName.Substring(0, x.GroupTimeName.IndexOf('(')).Trim();
}
return(groupTrName == trimmedCheckedItemString);
}).Select(y => y.NamePerson).Distinct().ToList();
foreach (var name in r2)
{
pList.Add(PersonObject.GetLink(name));
}
_reqTrenName = _reqTrenName.Intersect(pList).Distinct();
}
}
else
{
_reqTrenName = _personsAll.Values; // Если не нужна выборка по этому признаку
}
MyCheckedListBox.ClearSelection(checkedListBox_Tren_Name);
var result = GetUpdatedRequestsAsync();
ShowPersons(result.Result);
}
public long AddImporterAndPerson(ImporterObject importer, PersonObject person, out long importerId)
{
try
{
return(_importerManager.AddImporterAndPerson(importer, person, out importerId));
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
importerId = 0;
return(0);
}
}
static void usingDynamicObject()
{
dynamic person = new PersonObject();
person.Name = "Tom";
person.Age = 23;
Func <int, int> Incr = delegate(int x) { person.Age += x; return(person.Age); };
person.IncrementAge = Incr;
Console.WriteLine("{0} - {1}", person.Name, person.Age); // Tom - 23
person.IncrementAge(4);
Console.WriteLine("{0} - {1}", person.Name, person.Age); // Tom - 27
}
public static DialogResult RunFreezeForm(string personName)
{// Cохраняет напрямую в Абонемент
Person person = PersonObject.GetLink(personName);
if (!(person.AbonementCurent is ClubCardA))
{
return(DialogResult.Cancel);
}
ClubCardA clubCard = ((ClubCardA)person.AbonementCurent);
var freezeForm = new FreezeForm(clubCard);
return(freezeForm.ShowDialog());
}
// Optional, can retrive the name directly from face API
// for simplicity, the comparision / retrieve name is hard coded
public static async Task <string> getName(string personID)
{
var client = new HttpClient();
client.DefaultRequestHeaders.Add("Ocp-Apim-Subscription-Key", "apiKey");
var uri = "https://westus.api.cognitive.microsoft.com/face/v1.0/persongroups/" + groupId + "/persons/" + personID;
var response = await client.GetAsync(uri);
var result = await response.Content.ReadAsStringAsync();
PersonObject personJSON = JsonConvert.DeserializeObject <PersonObject>(result);
return(personJSON.name);
}
public async Task LoadMedicines(PersonObject person)
{
if (person is null)
{
return;
}
var id = person.DbRecord?.ID ?? string.Empty;
var medicines = await dbSet.Include(x => x.Medicine).Where(x => x.PersonID == id)
.AsNoTracking().ToListAsync();
foreach (var c in medicines)
{
person.MedicineInUse(new MedicineObject(c.Medicine));
}
}
private void AbonementForm_Load(object sender, EventArgs e)
{
SetInitialValues();
LoadDefaultValues();
// Не выключено ли в настройках разрешение на корректировку абонементов при создании их
groupBox_Correctable.Enabled = Options.AbonIsCorrectable;
// Гостевой визит Радиобатон показывается если не были посещения
var lastVisits = PersonObject.GetVisitsList(_person.Name);
var isAbonementsExists = (AbonementController.GetInstance()?.GetList(_person.Name)?.Count != 0);
radioButton_guest.Visible = (lastVisits == null || lastVisits.Count == 0) && !isAbonementsExists;
pictureBox_Guest.Visible = (lastVisits == null || lastVisits.Count == 0) && !isAbonementsExists;
}
/// <summary>
/// Открывает карточку клиента namePerson
/// </summary>
/// <param name="namePerson"></param>
public static void OpenPersonCard(string namePerson)
{
if (string.IsNullOrEmpty(namePerson))
{
return;
}
if (!DataBaseLevel.ContainsNameKey(namePerson))
{
MessageBox.Show(@"Ошибка. Неправильное имя клиента");
return;
}
var presenterClientForm = new ClientFormPresenter(PersonObject.GetLink(namePerson));
presenterClientForm.Run();
}
static void Main(string[] args)
{
// ZR programming Concepts . Make your root strong through ZR programming concepts else you fall down in Industry...!
//OLD Traditions Approch
List <PersonObject> personObjectList = new List <PersonObject>(); //List of PersonObject type.
//First declare Array then create Object of class to access properties then intialize the array through object
PersonObject obj1 = new PersonObject();
obj1.First_Name = "Old Tradition";
obj1.Last_Name = "First create Object and then access object properties";
personObjectList.Add(obj1);
Console.WriteLine("\nApproch: " + obj1.First_Name + "\nProcedure: " + obj1.Last_Name);
//New Trending Approch
List <PersonObject> personObjectListTrendingList = new List <PersonObject>()
{
new PersonObject {
First_Name = "Trending Approch",
Last_Name = "After Declaration , Intialize the list through block. Complex to see But helpful in code cleaness." +
"But to iterate these elements Loop is required."
}
};
foreach (PersonObject element in personObjectListTrendingList)
{
Console.WriteLine("\nApproch: " + element.First_Name + "\nProcedure: " + element.Last_Name);
}
//Traditional Approch of Object Array
List <PersonObject> personObjectTraditionalList = new List <PersonObject>();
personObjectTraditionalList.Add(new PersonObject()
{
First_Name = "Traditional Approch",
Last_Name = "Here we directly insert the object reference in List, " +
"rather then storing object reference in seprate varible and then add to list"
});
foreach (PersonObject element in personObjectTraditionalList)
{
Console.WriteLine("\nApproch: " + element.First_Name + "\nProcedure: " + element.Last_Name);
}
}
public CompanyObject GetCompany(int companyId)
{
try
{
using (var db = new DPRDataMigrationEngineDBEntities())
{
var myObj = db.Companies.Where(s => s.CompanyId == companyId).Include("People").ToList();
if (!myObj.Any())
{
return(new CompanyObject());
}
var ttd = myObj[0];
var personObject = new PersonObject();
if (ttd.People != null && ttd.People.Any())
{
var person = ttd.People.ToList()[0];
personObject = new PersonObject
{
PersonId = person.PersonId,
LastName = person.LastName,
FirstName = person.FirstName,
CompanyId = person.CompanyId,
Designation = person.Designation,
PhoneNumber = person.PhoneNumber,
Email = person.Email,
};
}
var compObject = new CompanyObject
{
CompanyId = ttd.CompanyId,
Name = ttd.Name,
Address = ttd.Address,
RCNumber = ttd.RCNumber,
PersonObj = personObject
};
return(compObject);
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(new CompanyObject());
}
}
/// <summary>
/// Метод пытается изменить Имя Клиента. Если Успешно, переименовывает файл с фотографией и перезаписывает Путь до фотки
/// </summary>
/// <param name="curentName"></param>
/// <param name="newName"></param>
/// <returns></returns>
public static bool ChangePersonName(string curentName, string newName)
{
if (String.IsNullOrEmpty(curentName) || String.IsNullOrEmpty(newName))
{
return(false);
}
var oldName = String.Copy(curentName);
// Получаем обьекты для работы
var person = PersonObject.GetLink(oldName);
// Если текущее имя совпадает с новым
if (person.Name == newName)
{
return(false);
}
// Пытаемся переименовать старое имя в новое
var isSuccess = DataBaseLevel.PersonEditName(person.Name, newName);
// Переименование коллекции с Посещениями
if (isSuccess)
{
DataBaseLevel.GetPersonsVisitDict().RenameKey(oldName, PrepareName(newName));
DataBaseLevel.GetPersonsAbonHistDict().RenameKey(oldName, PrepareName(newName));
}
// Переименование файлов и Пути к фотке
if (isSuccess)
{
var isRenamedOk = MyFile.TryRenameFile(person.PathToPhoto, newName);
if (isRenamedOk)
{
DataBaseM.EditPathToPhoto(newName, newName);
}
}
// Переименование в контроллере абонементов
if (isSuccess)
{
AbonementController.GetInstance().GetPersonsDictn().RenameKey(oldName, PrepareName(newName));
}
//
return(isSuccess);
}
public void CreateTest()
{
var r = GetRandom.Object <PersonMedicineDbRecord>();
var person = new PersonObject(r.Person);
var medicine = new MedicineObject(r.Medicine);
var o = PersonMedicineObjectFactory.Create(person, medicine, r.Suitability, r.ValidFrom,
r.ValidTo);
Assert.AreEqual(o.DbRecord.ValidFrom, r.ValidFrom);
Assert.AreEqual(o.DbRecord.ValidTo, r.ValidTo);
Assert.AreEqual(o.DbRecord.Suitability, r.Suitability);
Assert.AreEqual(o.Person.DbRecord, r.Person);
Assert.AreEqual(o.Medicine.DbRecord, r.Medicine);
Assert.AreEqual(o.DbRecord.PersonID, r.Person.ID);
Assert.AreEqual(o.DbRecord.MedicineID, r.Medicine.ID);
Assert.AreEqual(o.DbRecord.Person, r.Person);
Assert.AreEqual(o.DbRecord.Medicine, r.Medicine);
}
public void Write2DB(PersonObject person, SQLConnectionSettings s)
{
try
{
string Query = "insert into " + s.Database + "." + s.TableName + "(Grad,Name,Vorname,PicturePath,IsChecked,CardID) values('" +
person.Grad + "','" +
person.Name + "','" +
person.Vorname + "','" +
person.PhotoPath + "','" +
Convert.ToByte(person.IsCheckedIn) + "','" +
person.CardID + "');";
MySqlConnection con = Connect(s);
ExecuteSQLCommand(Query, con);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static bool AddAbonement(string personName)
{
// Для справки. В архив абонементов новый добавляемый абонемент добавляется в форме абонементов AbonementForm
// именно там он создается. Поэтому сразу и добавляем там
var person = PersonObject.GetLink(personName);
if (person == null)
{
return(false);
}
var dialogResult = FormsRunner.CreateAbonementForm(person.Name);
//if (dialogResult == DialogResult.OK)
//{
// AbonementController.GetInstance().Save();
// return true;
//}
return(false);
}
public void Submit()
{
try
{
if (NewAddress)
{
PersonObject.AddNew(AddressObject);
}
else
{
PersonObject.AddNew(AddressObject.AddressID);
}
OnTabClosed();
}
catch (Exception E)
{
ExepionLogger.Logger.LogException(E);
ExepionLogger.Logger.Show(E);
}
}
private void SubmitAddressLinkMethod()
{
try
{
PersonObject.LinkAddress(SelectedObject.AddressID);
LinkVisibility = Visibility.Hidden;
PersonObject.UpdateLinkedAddresses();
LinkedAddresses.Clear();
foreach (var item in PersonObject.LinkedAddresses)
{
LinkedAddresses.Add(item);
}
}
catch (Exception e)
{
ExepionLogger.Logger.LogException(e);
ExepionLogger.Logger.Show(e);
}
}
public PersonObject ReadFromDB(COMMAND command, object value, SQLConnectionSettings s)
{
PersonObject person = new PersonObject();
try
{
string QuerySelect = "select * from " + s.Database + "." + s.TableName + " where " + command.ToString() + "='" + value + "';";
MySqlConnection con = Connect(s);
MySqlCommand sqlCommand = new MySqlCommand(QuerySelect, con);
//For offline connection we weill use MySqlDataAdapter class.
MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
MyAdapter.SelectCommand = sqlCommand;
DataTable dTable = new DataTable();
MyAdapter.Fill(dTable);
DataRow row = dTable.Rows[0];
person.ID = (int)row[0];
person.Grad = (string)row[1];
person.Name = (string)row[2];
person.Vorname = (string)row[3];
person.PhotoPath = (string)row[4];
person.IsCheckedIn = Convert.ToBoolean(row[5]);
person.CardID = (string)row[6];
person.CheckInTime = (string)row[7];
person.CheckOutTime = (string)row[8];
sqlCommand.Connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
return(person);
}
public List <PersonObject> ReadFromDB(SQLConnectionSettings s)
{
List <PersonObject> persons = new List <PersonObject>();
try
{
string Query = "select * from " + s.Database + "." + s.TableName + ";";
MySqlConnection con = Connect(s);
MySqlCommand command = new MySqlCommand(Query, con);
//For offline connection we weill use MySqlDataAdapter class.
MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
MyAdapter.SelectCommand = command;
DataTable dTable = new DataTable();
MyAdapter.Fill(dTable);
foreach (DataRow row in dTable.Rows)
{
PersonObject person = new PersonObject();
person.ID = (int)row[0];
person.Grad = (string)row[1];
person.Name = (string)row[2];
person.Vorname = (string)row[3];
person.PhotoPath = (string)row[4];
person.IsCheckedIn = Convert.ToBoolean(row[5]);
person.CardID = (string)row[6];
person.CheckInTime = (string)row[7];
person.CheckOutTime = (string)row[8];
persons.Add(person);
}
command.Connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "DB Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(null);
}
return(persons);
}
/// <summary>
/// Обновляет все элементы на форме при любом выборе нового Клиента.
/// </summary>
private void UpdatePersonalControls()
{
// Получили Персону
var person = PersonObject.GetLink(SelectedName);
// Телефон
maskedTextBox_PhoneNumber.Text = person.Phone;
// Пол
MyComboBox.SetSelectedValue(comboBox_Gender, person.GenderType.ToString());
// ДР
try
{
dateTimePicker_birthDate.Value = person.BirthDate.Date;
}
catch (Exception)
{
dateTimePicker_birthDate.Value = DateTime.Now;
}
// Пасспорт
maskedTextBox_Passport.Text = person.Passport ?? "";
// Права
maskedTextBox_DriverID.Text = person.DriverIdNum ?? "";
// ID
maskedTextBox_number.Text = person.IdString;
// Фото
var isSuccess = Logic.TryLoadPhoto(pictureBox_Client, person.PathToPhoto, person.GenderType);
if (!isSuccess && !string.IsNullOrEmpty(person.PathToPhoto))
{
person.PathToPhoto = "";
}
// Краткая инфа об абонементе
Logic.LoadShortInfo(groupBox_AbonInfo, person.Status, person.AbonementCurent);
}
public long AddDprUser(PersonObject user)
{
return(_aspNetUserManager.AddDprUser(user));
}
