public static Mem_Division GetMem_DivisionByID(int id) { Mem_Division mem_Division = new Mem_Division(); SqlMem_DivisionProvider sqlMem_DivisionProvider = new SqlMem_DivisionProvider(); mem_Division = sqlMem_DivisionProvider.GetMem_DivisionByID(id); return(mem_Division); }
public bool UpdateMem_Division(Mem_Division mem_Division) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("IEB_UpdateMem_Division", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Mem_DivisionID", SqlDbType.Int).Value = mem_Division.Mem_DivisionID; cmd.Parameters.Add("@Mem_DivisionName", SqlDbType.NVarChar).Value = mem_Division.Mem_DivisionName; cmd.Parameters.Add("@Website", SqlDbType.NVarChar).Value = mem_Division.Website; cmd.Parameters.Add("@FullName", SqlDbType.NVarChar).Value = mem_Division.FullName; cmd.Parameters.Add("@ContactInfo", SqlDbType.NText).Value = mem_Division.ContactInfo; cmd.Parameters.Add("@Details", SqlDbType.NText).Value = mem_Division.Details; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public Mem_Division GetMem_DivisionFromReader(IDataReader reader) { try { Mem_Division mem_Division = new Mem_Division ( (int)reader["Mem_DivisionID"], reader["Mem_DivisionName"].ToString(), reader["Website"].ToString(), reader["FullName"].ToString(), reader["ContactInfo"].ToString(), reader["Details"].ToString() ); return(mem_Division); } catch (Exception ex) { return(null); } }
public static bool UpdateMem_Division(Mem_Division mem_Division) { SqlMem_DivisionProvider sqlMem_DivisionProvider = new SqlMem_DivisionProvider(); return(sqlMem_DivisionProvider.UpdateMem_Division(mem_Division)); }
public static int InsertMem_Division(Mem_Division mem_Division) { SqlMem_DivisionProvider sqlMem_DivisionProvider = new SqlMem_DivisionProvider(); return(sqlMem_DivisionProvider.InsertMem_Division(mem_Division)); }