/// <summary>
/// update single entity of a table
/// </summary>
/// <typeparam name="BookingDJDataContext"></typeparam>
/// <param name="obj"></param>
public static void Update <T>(OMSDataContext Database, T obj) where T : class
{
//finally submit an add/updated entity object to database
try
{
Database.SubmitChanges(ConflictMode.ContinueOnConflict);
}
catch (ChangeConflictException e)
{
foreach (ObjectChangeConflict cc in Database.ChangeConflicts)
{
//No database values are automerged into current
cc.Resolve(RefreshMode.KeepCurrentValues);
}
}
}
public static void Delete <T>(OMSDataContext Database, T entity) where T : class, new()
{
//var Database = DatabaseHelper.GetBookingDJData();
//Database.GetTable<T>().Attach(entity);
Database.GetTable <T>().DeleteOnSubmit(entity);
try
{
Database.SubmitChanges();
}
catch (ChangeConflictException e)
{
foreach (ObjectChangeConflict cc in Database.ChangeConflicts)
{
//No database values are automerged into current
cc.Resolve(RefreshMode.OverwriteCurrentValues);
}
}
}
public AccountsFacade(OMSDataContext database) : base(database)
{
}
public static OMSDataContext GetData()
{
var db = new OMSDataContext(ConfigurationManager.ConnectionStrings[ConnectionStringName].ConnectionString);
return(db);
}
public InsentiveFacade(OMSDataContext database)
: base(database)
{
}
public AdminFacade(OMSDataContext database)
: base(database)
{
}
public ChannelFacade(OMSDataContext database)
: base(database)
{
}
public CommonFacade(OMSDataContext database)
: base(database)
{
}
public AssetFacade(OMSDataContext database)
: base(database)
{
}
public MemberFacade(OMSDataContext database)
: base(database)
{
}
public CustomerFacade(OMSDataContext database)
: base(database)
{
}
public BaseFacade(OMSDataContext database)
{
_Database = database;
}
public SupplierFacade(OMSDataContext database)
: base(database)
{
}
public ItemFacade(OMSDataContext database)
: base(database)
{
}
public InvoiceFacade(OMSDataContext database)
: base(database)
{
}
public OrderFacade(OMSDataContext database)
: base(database)
{
}
public SecurityFacade(OMSDataContext database)
: base(database)
{
}
public StockFacade(OMSDataContext database)
: base(database)
{
}
public InventoryGeneralFacade(OMSDataContext database)
: base(database)
{
}
public EmployeeFacade(OMSDataContext database)
: base(database)
{
}
public TicketSaleFacade(OMSDataContext database)
: base(database)
{
}