public BaseResponseDto RemoveContacts(int[] ids)
{
using (var database = new PhoneBookDatabaseEntities())
{
database.Contact.RemoveRange(database.Contact.Where(c => ids.Contains(c.Id)));
database.SaveChanges();
return(new BaseResponseDto
{
Success = true,
Message = ""
});
}
}
public TableDataDto GetContacts(RequestDataDto requestData)
{
using (var database = new PhoneBookDatabaseEntities())
{
var fullData = GetFullData(requestData.Filter, database.Contact, requestData.SortCommand, requestData.IsSortedDesc);
return(new TableDataDto
{
ContactsList = fullData
.Skip((requestData.NumberOfPage - 1) * requestData.SizeOfPage)
.Take(requestData.SizeOfPage)
.ToList(),
CountOfContacts = fullData.Count()
});
}
}
public Stream GetExcel(string filter, SortCommand sortCommand, bool isSortedDesc)
{
List <ContactDto> table;
using (var database = new PhoneBookDatabaseEntities())
{
table = GetFullData(filter, database.Contact, sortCommand, isSortedDesc).ToList();
}
using (var workbook = new XLWorkbook())
{
var worksheet = workbook.Worksheets.Add("Контакты");
worksheet.ColumnWidth = 20;
worksheet.Cell("A1").Value = "Фамилия";
worksheet.Cell("B1").Value = "Имя";
worksheet.Cell("C1").Value = "Телефон";
var i = 2;
foreach (var contact in table)
{
worksheet.Cell("A" + i).Value = contact.Surname;
worksheet.Cell("B" + i).Value = contact.Name;
worksheet.Cell("C" + i).Value = contact.Phone;
++i;
}
var range = worksheet.Range("A1", "C" + (i - 1));
worksheet.Range("C2", "C" + (i - 1)).DataType = XLCellValues.Text;
range.CreateTable();
var memoryStream = new MemoryStream();
workbook.SaveAs(memoryStream);
HttpContext.Current.Response.Headers["Content-Disposition"] = "attachment; filename=contacts.xlsx";
HttpContext.Current.Response.ContentType = "application/octet-stream";
memoryStream.Position = 0;
return(memoryStream);
}
}
public BaseResponseDto AddContact(ContactDto contact)
{
using (var database = new PhoneBookDatabaseEntities())
{
var isNotUniquePhone = database.Contact.Any(c => c.Phone == contact.Phone);
if (isNotUniquePhone)
{
return(new BaseResponseDto
{
Success = false,
Message = $"Контакт с номером {contact.Phone} уже существует"
});
}
if (string.IsNullOrEmpty(contact.Phone) || string.IsNullOrEmpty(contact.Name) ||
string.IsNullOrEmpty(contact.Surname))
{
return(new BaseResponseDto
{
Success = false,
Message = "Не все поля заполнены"
});
}
database.Contact.Add(new Contact
{
Name = contact.Name,
Surname = contact.Surname,
Phone = contact.Phone
});
database.SaveChanges();
return(new BaseResponseDto
{
Success = true,
Message = ""
});
}
}
