//add method private void add() { clsStaff staffModel = new clsStaff(); string ErrorMessage; //test the data on the web form ErrorMessage = staffModel.StaffValid(TextBox2.Text, TextBox3.Text, TextBox4.Text, TextBox6.Text, TextBox8.Text); if (ErrorMessage == "") { staffModel.Staffname = TextBox2.Text; staffModel.Age = Convert.ToInt32(TextBox3.Text); staffModel.Brief = TextBox4.Text; staffModel.Gender = "man"; staffModel.Mobilesphone = TextBox6.Text; staffModel.Workage = Convert.ToInt32(TextBox8.Text); staffModel.Position = DropDownList1.Text; clsStaffCollection staffcollection = new clsStaffCollection(); int a = staffcollection.AddStaff(staffModel); Response.Redirect("Staffs.aspx"); } else { Response.Write("<script type='text/javascript'>alert('" + ErrorMessage + "');</script>"); } }
public void StaffDeleteMethodOk() { //create an instance of the class we want to create clsStaffCollection clsstaffcollection = new clsStaffCollection(); //create some test data to assign to the property // add an item of test data clsStaff TestItem = new clsStaff(); Boolean Found = false; //var to store the primary key Int32 PrimaryKey = 0; //set its properties TestItem.Staffid = 1; TestItem.Staffname = "jefferson"; TestItem.Age = 20; TestItem.Brief = "i am jefferson"; TestItem.Gender = "man"; TestItem.Mobilesphone = "083128312321"; TestItem.Workage = 2; TestItem.Position = "staff"; //set ThisStaffto the test data clsstaffcollection.ThisStaff = TestItem; //delete the record //PrimaryKey = clsstaffcollection.Delete(TestItem); //set the primary key of the test data TestItem.Staffid = PrimaryKey; //find the record //Found=clsstaffcollection.ThisStaff.Find(PrimaryKey); //test to see that the two values are the same Assert.IsFalse(Found); }
public void StaffInstanceOk() { //create an instance clsStaff clsstaff = new clsStaff(); //test to see that exists Assert.IsNotNull(clsstaff); }
//update method private void update() { clsStaff clstaffs = new clsStaff(); clstaffs = clstaffs.Find(staffid); TextBox2.Text = clstaffs.Staffname.ToString(); TextBox3.Text = clstaffs.Age.ToString(); TextBox4.Text = clstaffs.Brief.ToString(); TextBox6.Text = clstaffs.Mobilesphone.ToString(); TextBox8.Text = clstaffs.Workage.ToString(); DropDownList1.Text = clstaffs.Position.ToString(); }
public void StaffNamePropertyOK() { //create an instance of the class we want to create clsStaff AStaff = new clsStaff(); //Create test data string AName = "ShiRan"; //assign the data to the property AStaff.Staffname = AName; //two values are the same Assert.AreEqual(AStaff.Staffname, AName); }
public void StaffstaffidPropertyOK() { //create an instance of the class we want to create clsStaff AStaff = new clsStaff(); //Create test data int Number = 1; //assign the data to the property AStaff.Staffid = Number; //two values are the same Assert.AreEqual(AStaff.Staffid, Number); }
//Add Stafff Information public int AddStaff(clsStaff staffModel) { dBConnection = new clsDataConnection(); //execute dBConnection.AddParameter("@Name", staffModel.Staffname); dBConnection.AddParameter("@Age", staffModel.Age); dBConnection.AddParameter("@Brief", staffModel.Brief); dBConnection.AddParameter("@Gender", staffModel.Gender); dBConnection.AddParameter("@Mobilesphone", staffModel.Mobilesphone); dBConnection.AddParameter("@workage", staffModel.Workage); dBConnection.AddParameter("@positiob", staffModel.Position); return dBConnection.Execute("sproc_Staff_Insert"); }
public void StaffNameLessOne() { //create an instance of the staffname clsStaff AStaff = new clsStaff(); //boolean variable to store the results of the validation Boolean Ok = false; //some string test data to assign the property string StaffNameValid = ""; string BriefValid = "i am jefferson"; string GenderValid = "man"; string MobilesphoneValid = "07833324651"; string PositionValid = "manager"; //invoke the method Ok = AStaff.Valid(StaffNameValid, BriefValid, GenderValid, MobilesphoneValid, PositionValid); //test to see that results is correct Assert.IsFalse(Ok); }
public void StaffAddressListOk() { //create an instance of the class we want to create clsStaffCollection clsstaffcollection = new clsStaffCollection(); //create some test data to assign to the property //in this case the data needs to be a list of objects List<clsStaff> TestStaffList = new List<clsStaff>(); // add an item of test data clsStaff TestItem = new clsStaff(); //set its properties TestItem.Staffid = 1; TestItem.Staffname = "jefferson"; TestItem.Age = 20; TestItem.Brief = "i am jefferson"; TestItem.Gender = "man"; TestItem.Mobilesphone = "083128312321"; TestItem.Workage = 2; TestItem.Position = "staff"; //add the item to the test list TestStaffList.Add(TestItem); clsstaffcollection.staffList = TestStaffList; Assert.AreEqual(clsstaffcollection.staffList, TestStaffList); }
public List<clsStaff> clsStaffListCollection() { //var for the index Int32 Index = 0; //var to store the record count Int32 RecordCount = 0; //object for the data connection List<clsStaff> StaffList = new List<clsStaff>(); clsDataConnection DB = new clsDataConnection(); //execute the stored procedure DB.Execute("sproc_tblStaff_SelectAll"); //get the count of records RecordCount = DB.Count; //while there are records to proccess while (Index < RecordCount) { clsStaff StaffOne = new clsStaff(); StaffOne.Staffid = Convert.ToInt32(DB.DataTable.Rows[Index]["staffid"]); StaffOne.Staffname = Convert.ToString(DB.DataTable.Rows[Index]["Name"]); StaffOne.Age = Convert.ToInt32(DB.DataTable.Rows[Index]["age"]); StaffOne.Brief = Convert.ToString(DB.DataTable.Rows[Index]["brief"]); StaffOne.Gender = Convert.ToString(DB.DataTable.Rows[Index]["gender"]); StaffOne.Mobilesphone = Convert.ToString(DB.DataTable.Rows[Index]["mobilesphone"]); StaffOne.Workage = Convert.ToInt32(DB.DataTable.Rows[Index]["workage"]); StaffOne.Position = Convert.ToString(DB.DataTable.Rows[Index]["position"]); StaffList.Add(StaffOne); // //point at the next record Index++; } return StaffList; }
public void StaffpositionPropertyOK() { //create an instance of the class we want to create clsStaff AStaff = new clsStaff(); //Create test data string Aposition = "manager"; //assign the data to the property AStaff.Position = Aposition; //two values are the same Assert.AreEqual(AStaff.Position, Aposition); }
public void StaffworkagePropertyOK() { //create an instance of the class we want to create clsStaff AStaff = new clsStaff(); //Create test data int Aworkage = 2; //assign the data to the property AStaff.Workage = Aworkage; //two values are the same Assert.AreEqual(AStaff.Workage, Aworkage); }
public void StaffmobilesphonePropertyOK() { //create an instance of the class we want to create clsStaff AStaff = new clsStaff(); //Create test data string Amobilesphone = "07832223456"; //assign the data to the property AStaff.Mobilesphone = Amobilesphone; //two values are the same Assert.AreEqual(AStaff.Mobilesphone, Amobilesphone); }
public void StaffgenderPropertyOK() { //create an instance of the class we want to create clsStaff AStaff = new clsStaff(); //Create test data string Agender = "gentleman"; //assign the data to the property AStaff.Gender = Agender; //two values are the same Assert.AreEqual(AStaff.Gender, Agender); }
public void StaffbriefPropertyOK() { //create an instance of the class we want to create clsStaff AStaff = new clsStaff(); //Create test data string Abrief = "i am shiran lin..."; //assign the data to the property AStaff.Brief = Abrief; //two values are the same Assert.AreEqual(AStaff.Brief, Abrief); }
public void StaffmobilesphoneExtremeMax() { //create an instance of the Staffmobilesphone clsStaff AStaff = new clsStaff(); //boolean variable to store the results of the validation Boolean Ok = false; //some string test data to assign the property string StaffNameValid = "Jefferson"; string BriefValid = "i am jefferson"; string GenderValid = "man"; string MobilesphoneValid = ""; //pad the string with a characters MobilesphoneValid = MobilesphoneValid.PadRight(12, '0'); string PositionValid = "manager"; //invoke the method Ok = AStaff.Valid(StaffNameValid, BriefValid, GenderValid, MobilesphoneValid, PositionValid); //test to see that results is correct Assert.IsFalse(Ok); }
public clsStaff Find(Int32 Staffid) { //initialise the DBConnection clsDataConnection dBConnection = new clsDataConnection(); //add the Product No parameter dBConnection.AddParameter("@Staffid", Staffid); //execute the query dBConnection.Execute("sproc_tblStaff_FilterByStaffid"); //if the record was found clsStaff clstaffs = new clsStaff(); if (dBConnection.Count == 1) { //get the Product No clstaffs.Staffid = Convert.ToInt32(dBConnection.DataTable.Rows[0]["Staffid"]); clstaffs.Staffname = Convert.ToString(dBConnection.DataTable.Rows[0]["Staffname"]); clstaffs.Age = Convert.ToInt32(dBConnection.DataTable.Rows[0]["Age"]); clstaffs.Brief = Convert.ToString(dBConnection.DataTable.Rows[0]["Brief"]); clstaffs.Gender = Convert.ToString(dBConnection.DataTable.Rows[0]["Gender"]); clstaffs.Mobilesphone = Convert.ToString(dBConnection.DataTable.Rows[0]["Mobilesphone"]); clstaffs.Workage = Convert.ToInt32(dBConnection.DataTable.Rows[0]["Workage"]); clstaffs.Position = Convert.ToString(dBConnection.DataTable.Rows[0]["Position"]); } //return success return clstaffs; }