/// <summary>
/// Create new account
/// </summary>
/// <param name="accounts"></param>
public void CreateAccount(Accounts1 accounts)
{
if (!ChecksAndBalances(accounts))
{
Console.WriteLine($"An Error occured trying to add a new account information.");
return;
}
// Add the account records.
ADC.Accounts.Add(Mappings.MapAccount.Map(accounts));
ADC.SaveChanges();
}
/// <summary>
/// Create new Department
/// </summary>
/// <param name="Departments"></param>
public void CreateDepartment(Departments1 Departments)
{
if (ADC.Departments.Any(d => d.DEPT_NAME == Departments.DEPT_NAME))
{
Console.WriteLine($"This Department {Departments.DEPT_NAME} already exists and cannot be added");
return;
}
else
{
ADC.Departments.Add(MapDepartments.Map(Departments)); // this will generate insertMapper.Map(Departments)
}
ADC.SaveChanges(); // this will execute the above generate insert query
}
/// <summary>
/// Delete Message
/// </summary>
/// <param name="id"></param>
public void DeleteMessage(int id)
{
var Cus = ADC.Messages.FirstOrDefault(Cx => Cx.ID == id);
if (Cus.ID == id)
{
ADC.Remove(Cus);
ADC.SaveChanges();
}
else
{
Console.WriteLine($"Cx with id {id} doesn't exist");
return;
}
}
public void CreateConversation(Conversations1 Conversation)
{
ADC.Conversations.Add(MapConversations.Map(Conversation)); // this will generate insertMapper.Map(Conversations)
ADC.SaveChanges(); // this will execute the above generate insert query
}
