public bool Register(string Email, string lastName)
{
bool result = true;
try
{
StudentDB database = new StudentDB("Student");
DataTable dt = new DataTable();
database.Command.Parameters.Clear();
database.Command.CommandType = System.Data.CommandType.StoredProcedure;
database.Command.CommandText = "tblStudent_REGISTER";
database.Command.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = Email;
database.Command.Parameters.Add("@LNAME", SqlDbType.VarChar).Value = lastName;
base.Initialize(database, Guid.Empty);
database.ExecuteEQuery();
base.Initialize(database.Command);
}
catch (Exception e)
{
result = false;
throw e;
}
return(result);
}
private bool Delete(StudentDB database)
{
//refactor to fit DELETE stored procedure
bool result = true;
try
{
database.Command.Parameters.Clear();
database.Command.CommandType = System.Data.CommandType.StoredProcedure;
database.Command.CommandText = "tblCustomer_DELETE";
base.Initialize(database, base.id);
database.ExecuteEQuery();
base.Initialize(database.Command);
}
catch (Exception e)
{
result = false;
throw e;
}
return(result);
}
private bool Insert(StudentDB database)
{
bool result = true;
try
{
database.Command.Parameters.Clear();
database.Command.CommandType = System.Data.CommandType.StoredProcedure;
database.Command.CommandText = "tblPhoneType_INSERT";
database.Command.Parameters.Add("@TYPE", SqlDbType.VarChar).Value = _TYPE;
base.Initialize(database, Guid.Empty);
database.ExecuteEQuery();
base.Initialize(database.Command);
}
catch (Exception e)
{
result = false;
throw;
}
return(result);
}
