public int InsertTrainingEvent(TRNTrainingEvent objEvent)
{
objEvent.EventID = 1;
BeginTransaction();
try
{
objEvent.EventID = Insert(objEvent);
CommitTransaction();
}
catch (Exception ex)
{
RollBackTransaction();
objEvent.EventID = -1;
}
return objEvent.EventID;
}
public int DeleteTrainingEvent(TRNTrainingEvent objEvent)
{
objEvent.ModifiedDate = DateTime.Now;
return new TRNTrainingEventDAO().DeleteTrainingEvent(objEvent);
}
public int InsertTrainingEvent(TRNTrainingEvent objEvent)
{
objEvent.CreatedDate = DateTime.Now;
return new TRNTrainingEventDAO().InsertTrainingEvent(objEvent);
}
public int UpdateTrainingEvent(TRNTrainingEvent objEvent)
{
int rowsaffected = -1;
BeginTransaction();
try
{
String[] UpdateProperties = new String[] { "Event", "Batch", "TradeNameID", "StartDate", "EndDate", "ModifiedBy", "ModifiedDate", "Status", "CostSharing", "Regular" };
rowsaffected = Update(objEvent, UpdateProperties);
CommitTransaction();
}
catch (Exception e)
{
RollBackTransaction();
rowsaffected = -1;
}
return rowsaffected;
}
public int DeleteTrainingEvent(TRNTrainingEvent objEvent)
{
int rowsaffected = -1;
BeginTransaction();
try
{
String[] UpdateProperties = new String[] { "UpdatedBy", "UpdateDate", "Status" };
rowsaffected = Update(objEvent, UpdateProperties);
CommitTransaction();
}
catch (Exception e)
{
RollBackTransaction();
rowsaffected = -1;
}
return rowsaffected;
}