public void TransferData(int year, string byUser)
{
Database db = AppEnvironment.CreateDatabase();
try
{
db.BeginTrans();
StoreProcedure.sp_ACS340_TransferData(db, year, byUser);
db.CommitTrans();
}
catch (Exception ex)
{
if (db.HasTransaction)
{
db.RollbackTrans();
}
throw;
}
finally
{
db.Close();
}
}
public tb_NewStandardMOH ProcessData(int year, string byUser)
{
Database db = AppEnvironment.CreateDatabase();
try
{
db.BeginTrans();
tb_NewStandardMOH result = StoreProcedure.sp_ACS340_Process_CalculateStandardMOH(db, year, byUser);
db.CommitTrans();
return(result);
}
catch (Exception ex)
{
if (db.HasTransaction)
{
db.RollbackTrans();
}
throw;
}
finally
{
db.Close();
}
}
public bool TestDatabaseConnection()
{
try
{
Database db = AppEnvironment.CreateDatabase();
return(SystemDAO.TestConnection(db));
}
catch
{
return(false);
}
}
private static bool TestConnection()
{
CommonBIZ biz = new CommonBIZ();
if (biz.TestDatabaseConnection())
{
AppEnvironment.Database = AppEnvironment.CreateDatabase();
AppEnvironment.Database.KeepConnection = true;
return(true);
}
return(false);
}
