public int NewClient(ClientsData client)
{
FirmDBEntities ContextDB;
using (ContextDB = new FirmDBEntities())
{
Client cli = new Client
{
FullName = client.FullName,
FirstName = client.FirstName,
LastName = client.LastName,
ClientTypeId = client.ClientTypeId,
Email = client.Email,
PhoneNumber = client.PhoneNumber,
MobileNumber = client.MobileNumber,
BirthDate = client.BirthDate,
LawyerId = client.LawyerId,
CreatedDate = DateTime.Today,
ModifyDate = null
};
try
{
ContextDB.Clients.Add(cli);
ContextDB.SaveChanges();
} catch
{
return(0);
}
return(cli.Id);
}
}
public List <ClientsData> GetClients()
{
FirmDBEntities ContextDB;
using (ContextDB = new FirmDBEntities())
{
List <ClientsData> myClients = new List <ClientsData>();
foreach (var c in ContextDB.Clients)
{
ClientsData cData = new ClientsData();
cData.Id = c.Id;
cData.FullName = c.FullName;
cData.FirstName = c.FirstName;
cData.LastName = c.LastName;
cData.ClientTypeId = c.ClientTypeId;
cData.ClientType = c.ClientType.Name;
cData.Email = c.Email;
cData.PhoneNumber = c.PhoneNumber;
cData.MobileNumber = c.MobileNumber;
cData.BirthDate = c.BirthDate;
cData.LawyerId = c.LawyerId;
cData.LawyerName = c.Lawyer.Name;
cData.CreatedDate = c.CreatedDate;
cData.ModifyDate = c.ModifyDate;
myClients.Add(cData);
}
return(myClients);
}
}
