public static Mem_SubDivision GetMem_SubDivisionByID(int id)
{
Mem_SubDivision mem_SubDivision = new Mem_SubDivision();
SqlMem_SubDivisionProvider sqlMem_SubDivisionProvider = new SqlMem_SubDivisionProvider();
mem_SubDivision = sqlMem_SubDivisionProvider.GetMem_SubDivisionByID(id);
return(mem_SubDivision);
}
public bool UpdateMem_SubDivision(Mem_SubDivision mem_SubDivision)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateMem_SubDivision", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Mem_SubDivisionID", SqlDbType.Int).Value = mem_SubDivision.Mem_SubDivisionID;
cmd.Parameters.Add("@Mem_SubDivisionName", SqlDbType.NVarChar).Value = mem_SubDivision.Mem_SubDivisionName;
cmd.Parameters.Add("@Mem_DivisionID", SqlDbType.Int).Value = mem_SubDivision.Mem_DivisionID;
cmd.Parameters.Add("@Website", SqlDbType.NVarChar).Value = mem_SubDivision.Website;
cmd.Parameters.Add("@FullName", SqlDbType.NVarChar).Value = mem_SubDivision.FullName;
cmd.Parameters.Add("@ContactInfo", SqlDbType.NText).Value = mem_SubDivision.ContactInfo;
cmd.Parameters.Add("@Details", SqlDbType.NText).Value = mem_SubDivision.Details;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public Mem_SubDivision GetMem_SubDivisionFromReader(IDataReader reader)
{
try
{
Mem_SubDivision mem_SubDivision = new Mem_SubDivision
(
(int)reader["Mem_SubDivisionID"],
reader["Mem_SubDivisionName"].ToString(),
(int)reader["Mem_DivisionID"],
reader["Website"].ToString(),
reader["FullName"].ToString(),
reader["ContactInfo"].ToString(),
reader["Details"].ToString()
);
return(mem_SubDivision);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateMem_SubDivision(Mem_SubDivision mem_SubDivision)
{
SqlMem_SubDivisionProvider sqlMem_SubDivisionProvider = new SqlMem_SubDivisionProvider();
return(sqlMem_SubDivisionProvider.UpdateMem_SubDivision(mem_SubDivision));
}
public static int InsertMem_SubDivision(Mem_SubDivision mem_SubDivision)
{
SqlMem_SubDivisionProvider sqlMem_SubDivisionProvider = new SqlMem_SubDivisionProvider();
return(sqlMem_SubDivisionProvider.InsertMem_SubDivision(mem_SubDivision));
}
