public Customer GetByID(Guid id)
{
//refactor to fit DELETE stored procedure
StudentDB database = new StudentDB("Student");
DataTable dt = new DataTable();
//may not need try|catch here
//try
//{
database.Command.Parameters.Clear();
database.Command.CommandType = CommandType.StoredProcedure;
database.Command.CommandText = "tblCustomer_GETBYID";
database.Command.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = id;
dt = database.ExecuteQuery();
if (dt != null && dt.Rows.Count == 1)
{
DataRow dr = dt.Rows[0];
base.Initialize(dr);
InitializeBusinessData(dr);
base.isNew = false;
base.isDirty = false;
}
return(this);
//}
//catch (Exception e)
//{
// result = false;
// throw;
//}
}
public Student Login(string firstName, string lastName)
{
StudentDB database = new StudentDB("Student");
DataTable dt = new DataTable();
database.Command.Parameters.Clear();
database.Command.CommandType = CommandType.StoredProcedure;
database.Command.CommandText = "tblStudent_Login";
database.Command.Parameters.Add("@FNAME", SqlDbType.VarChar).Value = firstName;
database.Command.Parameters.Add("@LNAME", SqlDbType.VarChar).Value = lastName;
dt = database.ExecuteQuery();
if (dt != null && dt.Rows.Count == 1)
{
{
DataRow dr = dt.Rows[0];
base.Initialize(dr);
InitializeBusinessData(dr);
base.isNew = false;
base.isDirty = false;
}
return(this);
}
else
{
return(null);
}
}
public AddressTypeList GetAll()
{
StudentDB database = new StudentDB("Student");
database.Command.Parameters.Clear();
database.Command.CommandType = System.Data.CommandType.StoredProcedure;
database.Command.CommandText = "tblAddressType_GETALL";
DataTable dt = database.ExecuteQuery();
foreach (DataRow dr in dt.Rows)
{
AddressType addresstype = new AddressType();
addresstype.Initialize(dr);
addresstype.InitializeBusinessData(dr);
addresstype.isNew = false;
addresstype.isDirty = false;
_List.Add(addresstype);
}
return(this);
}
public CustomerList GetAll()
{
StudentDB database = new StudentDB("Student");
database.Command.Parameters.Clear();
database.Command.CommandType = System.Data.CommandType.StoredProcedure;
database.Command.CommandText = "tblCustomer_GETALL";
DataTable dt = database.ExecuteQuery();
foreach (DataRow dr in dt.Rows)
{
Customer customer = new Customer();
customer.Initialize(dr);
customer.InitializeBusinessData(dr);
customer.isNew = false;
customer.isDirty = false;
_List.Add(customer);
}
return(this);
}
public StudentList Search()
{
StudentDB database = new StudentDB("Student");
database.Command.Parameters.Clear();
database.Command.CommandType = System.Data.CommandType.Text;
_Criteria.TableName = "tblStudent";
database.Command.CommandText = SQLHelper.Builder.Build(_Criteria);
DataTable dt = database.ExecuteQuery();
foreach (DataRow dr in dt.Rows)
{
Student student = new Student();
student.Initialize(dr);
student.InitializeBusinessData(dr);
student.isNew = false;
student.isDirty = false;
_List.Add(student);
}
return(this);
}
public StudentEmailList GetByStudentID(Guid id)
{
StudentDB database = new StudentDB("Student");
database.Command.Parameters.Clear();
database.Command.Parameters.Add("@STUDENTID", SqlDbType.UniqueIdentifier).Value = id;
database.Command.CommandType = System.Data.CommandType.StoredProcedure;
database.Command.CommandText = "tblStudentEmail_GETBYSTUDENTID";
DataTable dt = database.ExecuteQuery();
foreach (DataRow dr in dt.Rows)
{
StudentEmail studentemail = new StudentEmail();
studentemail.Initialize(dr);
studentemail.InitializeBusinessData(dr);
studentemail.isNew = false;
studentemail.isDirty = false;
_List.Add(studentemail);
}
return(this);
}
