public static Comn_University GetComn_UniversityByID(int id)
{
Comn_University comn_University = new Comn_University();
SqlComn_UniversityProvider sqlComn_UniversityProvider = new SqlComn_UniversityProvider();
comn_University = sqlComn_UniversityProvider.GetComn_UniversityByID(id);
return(comn_University);
}
public bool UpdateComn_University(Comn_University comn_University)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateComn_University", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Comn_UniversityID", SqlDbType.Int).Value = comn_University.Comn_UniversityID;
cmd.Parameters.Add("@Comn_UniversityName", SqlDbType.NVarChar).Value = comn_University.Comn_UniversityName;
cmd.Parameters.Add("@Website", SqlDbType.NVarChar).Value = comn_University.Website;
cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = comn_University.Phone;
cmd.Parameters.Add("@Fax", SqlDbType.NVarChar).Value = comn_University.Fax;
cmd.Parameters.Add("@Type", SqlDbType.Int).Value = comn_University.Type;
cmd.Parameters.Add("@Details", SqlDbType.NText).Value = comn_University.Details;
cmd.Parameters.Add("@OldName", SqlDbType.NText).Value = comn_University.OldName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public Comn_University GetComn_UniversityFromReader(IDataReader reader)
{
try
{
Comn_University comn_University = new Comn_University
(
(int)reader["Comn_UniversityID"],
reader["Comn_UniversityName"].ToString(),
reader["Website"].ToString(),
reader["Phone"].ToString(),
reader["Fax"].ToString(),
(int)reader["Type"],
reader["Details"].ToString(),
reader["OldName"].ToString()
);
return(comn_University);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateComn_University(Comn_University comn_University)
{
SqlComn_UniversityProvider sqlComn_UniversityProvider = new SqlComn_UniversityProvider();
return(sqlComn_UniversityProvider.UpdateComn_University(comn_University));
}
public static int InsertComn_University(Comn_University comn_University)
{
SqlComn_UniversityProvider sqlComn_UniversityProvider = new SqlComn_UniversityProvider();
return(sqlComn_UniversityProvider.InsertComn_University(comn_University));
}
