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); }