public Person AddPersonContacts(params PersonContact[] items)
{
foreach (var item in items)
{
PersonContacts.Add(item);
}
return(this);
}
public int AddPersonContacts(PersonContacts data)
{
var checkNumber = _context.PersonContacts.Any(x => x.Email == data.Email || x.PhoneNumber == data.PhoneNumber);
if (checkNumber)
{
return(-1);
}
var res = _context.PersonContacts.Add(data);
_context.SaveChanges();
return(res.Entity.Id);
}
public bool UpdatePersonContacts(int id, PersonContacts data)
{
var res = _context.PersonContacts.FirstOrDefault(x => x.Id == id);
if (res == null)
{
return(false);
}
res.PhoneNumber = data.PhoneNumber;
res.HomePhoneNumber = data.HomePhoneNumber;
res.WorkPhoneNumber = data.WorkPhoneNumber;
res.Email = data.Email;
_context.SaveChanges();
return(true);
}
public void UpdatePersonContact(int id, PersonContactType personContactType, string value)
{
var contact = PersonContacts
.FirstOrDefault(
x => x.Id == id && !x.IsDeleted);
if (contact == null)
{
throw new NotFoundException(
StringResource.Contact,
StringResource.Id,
id);
}
contact.Update(personContactType, value);
}
public void DeletePersonContact(int id)
{
var contact = PersonContacts
.FirstOrDefault(
x => x.Id == id && !x.IsDeleted);
if (contact == null)
{
throw new NotFoundException(
StringResource.Contact,
StringResource.Id,
id);
}
else
{
contact.Delete();
}
}
public IActionResult PutPersonContacts(int id, [FromBody] PersonContacts data)
{
try
{
var res = _repository.UpdatePersonContacts(id, data);
if (!res)
{
return(Conflict(409));
}
return(Ok(res));
}
catch (Exception error)
{
return(BadRequest(error));
}
}
public IActionResult PostPersonContacts(PersonContacts data)
{
try
{
var res = _repository.AddPersonContacts(data);
if (res == -1)
{
return(Conflict(409));
}
return(Ok(res));
}
catch (Exception error)
{
return(BadRequest(error));
}
}
/// <summary>
/// </summary>
/// <param name="sectionID"></param>
/// <param name="showOldValues"></param>
public void LoadPeronInfoFromDoisser(int sectionID, bool showOldValues)
{
var contextList = new List <DossierContext>();
var sqlParams = new Dictionary <string, object>
{
{ "@КодЛица", Id.ToInt() }, { "@DateOld", showOldValues ? 1 : 0 }
};
if (sectionID != 0)
{
sqlParams.Add("@КодВкладки", sectionID);
}
using (var dbReader = new DBReader(SQLQueries.SP_Лица_Досье_Context_NEW, CommandType.StoredProcedure, CN,
sqlParams))
{
if (dbReader.HasRows)
{
//Unavailable = true;
//return;
Unavailable = false;
//Досье
while (dbReader.Read())
{
if (!dbReader.HasRows)
{
continue;
}
if (!dbReader.IsDBNull(dbReader.GetOrdinal("Надпись")) &&
dbReader.GetString(dbReader.GetOrdinal("Надпись")) == "ТипЛица")
{
IsNaturalPerson = dbReader.GetString(dbReader.GetOrdinal("Поле")) == "2";
}
else
{
var tempContext = new DossierContext();
tempContext.LoadFromDbReader(dbReader);
contextList.Add(tempContext);
}
}
}
//Атрибуты
if ((sectionID == 0 || sectionID == 41) && dbReader.NextResult())
{
PersonAttributes = new List <Attribute>();
while (dbReader.Read())
{
if (dbReader.HasRows)
{
var tempAttribute = new Attribute();
tempAttribute.FillDataFromDataRow(dbReader, true);
PersonAttributes.Add(tempAttribute);
}
}
}
//Темы и типы
if ((sectionID == 0 || sectionID == 42) && dbReader.NextResult())
{
PersonTypes = new List <PersonType>();
while (dbReader.Read())
{
if (dbReader.HasRows)
{
var tempType = new PersonType();
tempType.FillDataFromDataReader(dbReader, true);
PersonTypes.Add(tempType);
}
}
}
if (PersonTypes.Count == 0 && PersonAttributes.Count == 0 && contextList.Count == 0)
{
Unavailable = true;
return;
}
}
if (sectionID == 0)
{
PersonInfo = contextList.Where(t => t.КодВкладки == (IsNaturalPerson ? 2 : 1)).Select(t => t).ToList();
PersonContacts = contextList.Where(t => t.КодВкладки == 7 || t.КодВкладки == 8).Select(t => t).ToList();
ResponsibleEmployes =
contextList.Where(t => t.КодВкладки == 3 || t.КодВкладки == 4).Select(t => t).ToList();
PersonLinks =
contextList.Where(
t =>
t.КодВкладки == 11 || t.КодВкладки == 12 || t.КодВкладки == 13 || t.КодВкладки == 14 ||
t.КодВкладки == 15 || t.КодВкладки == 16 || t.КодВкладки == 17 || t.КодВкладки == 18)
.Select(
t => t).ToList();
PersonStores =
contextList.Where(
t =>
t.КодВкладки == 19 || t.КодВкладки == 20 || t.КодВкладки == 21 || t.КодВкладки == 23 ||
t.КодВкладки == 40 || t.КодВкладки == 24 || t.КодВкладки == 22 || t.КодВкладки == 25)
.Select(
t => t).ToList();
}
else
{
if (sectionID == 7 || sectionID == 8)
{
PersonContacts.RemoveAll(r => r.КодВкладки == sectionID);
PersonContacts.AddRange(contextList.Where(t => t.КодВкладки == sectionID).Select(t => t));
}
else if (sectionID == 3 || sectionID == 4)
{
ResponsibleEmployes.RemoveAll(r => r.КодВкладки == sectionID);
ResponsibleEmployes.AddRange(contextList.Where(t => t.КодВкладки == sectionID).Select(t => t));
}
else if (sectionID == 11 || sectionID == 12 || sectionID == 13 || sectionID == 14 || sectionID == 15 ||
sectionID == 16 || sectionID == 17 || sectionID == 18)
{
PersonLinks.RemoveAll(r => r.КодВкладки == sectionID);
PersonLinks.AddRange(contextList.Where(t => t.КодВкладки == sectionID).Select(t => t));
}
else if (sectionID == 19 || sectionID == 20 || sectionID == 21 || sectionID == 22 || sectionID == 23 ||
sectionID == 24 || sectionID == 25 || sectionID == 40)
{
PersonStores.RemoveAll(r => r.КодВкладки == sectionID);
PersonStores.AddRange(contextList.Where(t => t.КодВкладки == sectionID).Select(t => t));
}
else if (sectionID == 1 || sectionID == 2)
{
PersonInfo.RemoveAll(r => r.КодВкладки == (IsNaturalPerson ? 2 : 1));
PersonInfo.AddRange(
contextList.Where(t => t.КодВкладки == (IsNaturalPerson ? 2 : 1)).Select(t => t));
}
else
{
PersonInfo.RemoveAll(r => r.КодВкладки == sectionID);
PersonInfo.AddRange(contextList.Where(t => t.КодВкладки == sectionID).Select(t => t));
}
}
}
public int AddPersonData(PersonInfoDataModel data)
{
var checkNumber = _context.PersonData.Any(x =>
x.INN == data.INN ||
x.SNILS == data.SNILS ||
x.EmployeeId == data.EmployeeId);
if (checkNumber)
{
return(-1);
}
PersonContacts personContacts = new PersonContacts()
{
PhoneNumber = data.PersonContacts.PhoneNumber,
HomePhoneNumber = data.PersonContacts.HomePhoneNumber,
WorkPhoneNumber = data.PersonContacts.WorkPhoneNumber,
Email = data.PersonContacts.Email
};
PersonAddress personAddress = new PersonAddress()
{
RegistrationAddress = data.PersonAddress.RegistrationAddress,
RegistrationDate = data.PersonAddress.RegistrationDate,
ResidenceAddress = data.PersonAddress.ResidenceAddress,
OutsideAddress = data.PersonAddress.OutsideAddress,
InformationAddress = data.PersonAddress.InformationAddress
};
var personData = new DataModel.PersonData()
{
Birthplace = data.Birthplace,
INN = data.INN,
InformationСitizenshipDateStart = data.InformationСitizenshipDateStart,
DocumentTypeId = data.DocumentTypeId,
ValidityDocumentDateStart = data.ValidityDocumentDateStart,
PersonContacts = _context.PersonContacts.Add(personContacts).Entity,
PersonAddress = _context.PersonAddress.Add(personAddress).Entity,
EmployeeId = data.EmployeeId,
SNILS = data.SNILS,
DateBirth = data.DateBirth,
Gender = data.Gender
};
var res = _context.PersonData.Add(personData);
_context.SaveChanges();
DocumentPassportData documentPassportData = new DocumentPassportData()
{
Code = data.DocumentPassportData.Code,
CountryId = data.DocumentPassportData.CountryId,
Series = data.DocumentPassportData.Series,
Number = data.DocumentPassportData.Number,
IssuedDate = data.DocumentPassportData.IssuedDate,
Validity = data.DocumentPassportData.Validity,
DocumentIssued = data.DocumentPassportData.DocumentIssued,
personDataId = res.Entity.Id
};
_context.DocumentPassportData.Add(documentPassportData);
_context.SaveChanges();
return(res.Entity.Id);
}
