public bool add_StudentData()
{
//Creating variable and objects
bool status = false;
SqlConnection sqlConn = null;
SqlTransaction sqlTrn = null;
dbConnection dbConn = null;
studentDB stDB = null;
try
{
//Inizing objects
stDB = new studentDB();
dbConn = new dbConnection();
sqlConn = new SqlConnection();
//Inizing Sql Connection
sqlConn = dbConn.getConnection();
//Connection Open
sqlConn.Open();
//Transaction Beging
sqlTrn = sqlConn.BeginTransaction();
//Assing the return valeu
status = stDB.add_StudentData(sqlConn, sqlTrn);
}
catch (SqlException ex)
{
//throw exception to next layer
throw ex;
}
finally
{
//disposing creating objects
if (sqlConn != null)
{
sqlConn.Close();
}
sqlTrn.Dispose();
}
//returning tha value
return status;
}
public int getTemCount()
{
//Creating variable and objects
int data_Count = 0;
SqlConnection sqlConn = null;
SqlTransaction sqlTrn = null;
dbConnection dbConn = null;
studentDB stDB = null;
try
{
//Inizing objects
stDB = new studentDB();
dbConn = new dbConnection();
sqlConn = new SqlConnection();
//Inizing Sql Connection
sqlConn = dbConn.getConnection();
//Connection Open
sqlConn.Open();
//Transaction Beging
sqlTrn = sqlConn.BeginTransaction();
//Assing the return valeu
data_Count = stDB.getTemCount(sqlConn, sqlTrn);
}
catch (SqlException ex)
{
//throw exception to next layer
throw ex;
}
finally
{
//disposing creating objects
if (sqlConn != null)
{
sqlConn.Close();
}
sqlTrn.Dispose();
}
//returning the count
return data_Count;
}
public int getLastStID()
{
//Creating variable and objects
int stId = 0;
SqlConnection sqlConn = null;
SqlTransaction sqlTrn = null;
dbConnection dbConn = null;
studentDB stDB = null;
try
{
//Inizing objects
stDB = new studentDB ();
dbConn = new dbConnection();
sqlConn = new SqlConnection();
//Inizing Sql Connection
sqlConn = dbConn.getConnection();
//Connection Open
sqlConn.Open();
//Transaction Beging
sqlTrn = sqlConn.BeginTransaction();
stId = stDB.getLastStID(sqlConn, sqlTrn);
}
catch (SqlException ex)
{
//throw exception to next layer
throw ex;
}
finally
{
//disposing creating objects
if (sqlConn != null)
{
sqlConn.Close();
}
sqlTrn.Dispose();
}
//returning tha value
return stId;
}
public DataSet getAllTepDataDorDataGride()
{
//Creating variable and objects
DataSet ds = null;
SqlConnection sqlConn = null;
SqlTransaction sqlTrn = null;
dbConnection dbConn = null;
studentDB stDB = null;
try
{
//Inizing objects
stDB = new studentDB();
dbConn = new dbConnection();
sqlConn = new SqlConnection();
ds = new DataSet();
//Inizing Sql Connection
sqlConn = dbConn.getConnection();
//Connection Open
sqlConn.Open();
//Transaction Beging
sqlTrn = sqlConn.BeginTransaction();
//Assing the return valeu
ds = stDB.getAllTepDataDorDataGride(sqlConn, sqlTrn);
}
catch (SqlException ex)
{
//throw exception to next layer
throw ex;
}
finally
{
//disposing creating objects
if (sqlConn != null)
{
sqlConn.Close();
}
sqlTrn.Dispose();
}
//returning tha dataset
return ds;
}