public static Comn_Department GetComn_DepartmentByID(int id) { Comn_Department comn_Department = new Comn_Department(); SqlComn_DepartmentProvider sqlComn_DepartmentProvider = new SqlComn_DepartmentProvider(); comn_Department = sqlComn_DepartmentProvider.GetComn_DepartmentByID(id); return(comn_Department); }
public bool UpdateComn_Department(Comn_Department comn_Department) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("IEB_UpdateComn_Department", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Comn_DepartmentID", SqlDbType.Int).Value = comn_Department.Comn_DepartmentID; cmd.Parameters.Add("@Comn_DepartmentName", SqlDbType.NVarChar).Value = comn_Department.Comn_DepartmentName; cmd.Parameters.Add("@Website", SqlDbType.NVarChar).Value = comn_Department.Website; cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = comn_Department.Phone; cmd.Parameters.Add("@Fax", SqlDbType.NVarChar).Value = comn_Department.Fax; cmd.Parameters.Add("@Type", SqlDbType.Int).Value = comn_Department.Type; cmd.Parameters.Add("@Details", SqlDbType.NText).Value = comn_Department.Details; cmd.Parameters.Add("@OldName", SqlDbType.NText).Value = comn_Department.OldName; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public Comn_Department GetComn_DepartmentFromReader(IDataReader reader) { try { Comn_Department comn_Department = new Comn_Department ( (int)reader["Comn_DepartmentID"], reader["Comn_DepartmentName"].ToString(), reader["Website"].ToString(), reader["Phone"].ToString(), reader["Fax"].ToString(), (int)reader["Type"], reader["Details"].ToString(), reader["OldName"].ToString() ); return(comn_Department); } catch (Exception ex) { return(null); } }
public static bool UpdateComn_Department(Comn_Department comn_Department) { SqlComn_DepartmentProvider sqlComn_DepartmentProvider = new SqlComn_DepartmentProvider(); return(sqlComn_DepartmentProvider.UpdateComn_Department(comn_Department)); }
public static int InsertComn_Department(Comn_Department comn_Department) { SqlComn_DepartmentProvider sqlComn_DepartmentProvider = new SqlComn_DepartmentProvider(); return(sqlComn_DepartmentProvider.InsertComn_Department(comn_Department)); }