public static bool AddCustomerHearingAidOrder(string connectionString, CustomerHearingAidOrder customerHearingAidOrder)
{
try
{
using (var context = new CustomerDBContext(connectionString))
{
//_connectionString = connectionString;
var cloneObject = customerHearingAidOrder.CreateAClone <CustomerHearingAidOrder>();
context.CustomerHearingAidOrders.Add(cloneObject);
var result = context.SaveChanges();
#region Adding Reminder
var reminder = new Reminder()
{
ReminderName = "Warrenty Reminder for 1st Year " + customerHearingAidOrder.Customer.FormattedName, ReminderDate = customerHearingAidOrder.OrderDate.AddMonths(11), ReminderType = ReminderType.Information, ReminderMessage = "Warrenty Reminder for 1st Year " + Environment.NewLine + customerHearingAidOrder.Customer.FormattedName + Environment.NewLine + "Order Date " + customerHearingAidOrder.OrderDate
};
ReminderAction.AddReminder(connectionString, reminder);
var reminderConti = new Reminder()
{
ReminderName = "Warrenty Reminder for 2nd Year " + customerHearingAidOrder.Customer.FormattedName, ReminderDate = customerHearingAidOrder.OrderDate.AddMonths(23), ReminderType = ReminderType.Information, ReminderMessage = "Warrenty Reminder for 2nd Year " + Environment.NewLine + customerHearingAidOrder.Customer.FormattedName + Environment.NewLine + "Order Date " + customerHearingAidOrder.OrderDate
};
ReminderAction.AddReminder(connectionString, reminderConti);
#endregion
return(result > 0);
}
}
catch (Exception exception)
{
NLogLogger.LogError(exception, TitleResources.Error, ExceptionResources.ExceptionOccured,
ExceptionResources.ExceptionOccuredLogDetail);
return(false);
}
}
public static bool UpdateCustomerHearingAidOrder(string connectionString, CustomerHearingAidOrder customerHearingAidOrder)
{
try
{
_connectionString = connectionString;
var entry = DBContextInstance.Entry(customerHearingAidOrder);
entry.State = EntityState.Modified;
var result = DBContextInstance.SaveChanges();
return(result > 0);
}
catch (Exception exception)
{
NLogLogger.LogError(exception, TitleResources.Error, ExceptionResources.ExceptionOccured, ExceptionResources.ExceptionOccuredLogDetail);
return(false);
}
}
public static bool DeleteCustomerHearingAidOrder(string connectionString, CustomerHearingAidOrder customerHearingAidOrder)
{
try
{
//using (var context = new CustomerDBContext(connectionString))
{
_connectionString = connectionString;
DBContextInstance.CustomerHearingAidOrders.Attach(new CustomerHearingAidOrder()
{
ID = customerHearingAidOrder.ID
});
DBContextInstance.CustomerHearingAidOrders.Remove(customerHearingAidOrder);
var result = DBContextInstance.SaveChanges();
return(result > 0);
}
}
catch (Exception exception)
{
NLogLogger.LogError(exception, TitleResources.Error, ExceptionResources.ExceptionOccured,
ExceptionResources.ExceptionOccuredLogDetail);
return(false);
}
}
