public static STD_BoardUniversity GetSTD_BoardUniversityByBoardUniversityID(int BoardUniversityID)
{
STD_BoardUniversity sTD_BoardUniversity = new STD_BoardUniversity();
SqlSTD_BoardUniversityProvider sqlSTD_BoardUniversityProvider = new SqlSTD_BoardUniversityProvider();
sTD_BoardUniversity = sqlSTD_BoardUniversityProvider.GetSTD_BoardUniversityByBoardUniversityID(BoardUniversityID);
return sTD_BoardUniversity;
}
public static bool UpdateSTD_BoardUniversity(STD_BoardUniversity sTD_BoardUniversity)
{
SqlSTD_BoardUniversityProvider sqlSTD_BoardUniversityProvider = new SqlSTD_BoardUniversityProvider();
return sqlSTD_BoardUniversityProvider.UpdateSTD_BoardUniversity(sTD_BoardUniversity);
}
public static int InsertSTD_BoardUniversity(STD_BoardUniversity sTD_BoardUniversity)
{
SqlSTD_BoardUniversityProvider sqlSTD_BoardUniversityProvider = new SqlSTD_BoardUniversityProvider();
return sqlSTD_BoardUniversityProvider.InsertSTD_BoardUniversity(sTD_BoardUniversity);
}
public bool UpdateSTD_BoardUniversity(STD_BoardUniversity sTD_BoardUniversity)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_BoardUniversity", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@BoardUniversityID", SqlDbType.Int).Value = sTD_BoardUniversity.BoardUniversityID;
cmd.Parameters.Add("@BoardUniversityName", SqlDbType.NVarChar).Value = sTD_BoardUniversity.BoardUniversityName;
//cmd.Parameters.Add("@BoardUniversityName", SqlDbType.NVarChar).Value = sTD_BoardUniversity.BoardUniversityName;
//cmd.Parameters.Add("@BoardUniversityName", SqlDbType.NVarChar).Value = sTD_BoardUniversity.BoardUniversityName;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = sTD_BoardUniversity.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = sTD_BoardUniversity.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertSTD_BoardUniversity(STD_BoardUniversity sTD_BoardUniversity)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("InsertSTD_BoardUniversity", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@BoardUniversityID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@BoardUniversityName", SqlDbType.NVarChar).Value = sTD_BoardUniversity.BoardUniversityName;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = sTD_BoardUniversity.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = sTD_BoardUniversity.AddedDate;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = sTD_BoardUniversity.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = sTD_BoardUniversity.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@BoardUniversityID"].Value;
}
}
public STD_BoardUniversity GetSTD_BoardUniversityFromReader(IDataReader reader)
{
try
{
STD_BoardUniversity sTD_BoardUniversity = new STD_BoardUniversity
(
DataAccessObject.IsNULL<int>(reader["BoardUniversityID"]),
DataAccessObject.IsNULL<string>(reader["BoardUniversityName"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return sTD_BoardUniversity;
}
catch(Exception ex)
{
return null;
}
}
