private void BtnCreate_Click(object sender, EventArgs e) { if (TxtFirstname.Text == string.Empty || TxtSurname.Text == string.Empty || CmbGender.Text == string.Empty || TxtAddress.Text == string.Empty || TxtMobileNo.Text == string.Empty || TxtPersonsName.Text == string.Empty || TxtPhoneNo.Text == string.Empty || TxtRelationship.Text == string.Empty) { MessageBox.Show("Some fields are empty", "Empty fields, you must fill them, I demand it!!!"); } else { string firstname = TxtFirstname.Text; string surname = TxtSurname.Text; string gender = CmbGender.Text; string address = TxtAddress.Text; string mobileno = TxtMobileNo.Text; string personsname = TxtPersonsName.Text; string phoneno = TxtPhoneNo.Text; string relationship = TxtRelationship.Text; RegisterDetails registerdetails = new RegisterDetails { FirstName = firstname, SurName = surname, Gender = gender, Address = address, DOB = dob, MobileNo = mobileno, PersonName = personsname, PhoneNo = phoneno, Relationship = relationship }; dao.RegisterLogin(registerdetails); } }
public bool RegisterLogin(RegisterDetails registerdetails) { string connectionString = "Data Source=SD-15;" + "Initial Catalog=HospitalMS;" + "Integrated Security=True"; try { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); string insertCommand = "INSERT INTO Patient (FirstName, SurName, Gender, Address, DOB, MobileNo, PersonName, PhoneNo, Relationship) " + "VALUES(@FirstName, @SurName, @Gender, @Address, @DOB, @MobileNo, @PersonName, @PhoneNo, @Relationship)"; SqlCommand command = new SqlCommand(); command.CommandText = insertCommand; command.Connection = connection; SqlParameter parameter = new SqlParameter { ParameterName = "@FirstName", Value = registerdetails.FirstName, SqlDbType = SqlDbType.VarChar, Size = 50 }; command.Parameters.Add(parameter); command.Parameters.Add(new SqlParameter { ParameterName = "@SurName", Value = registerdetails.SurName, SqlDbType = SqlDbType.VarChar, Size = 50 }); command.Parameters.Add(new SqlParameter { ParameterName = "@Gender", Value = registerdetails.Gender, SqlDbType = SqlDbType.VarChar, Size = 50 }); command.Parameters.Add(new SqlParameter { ParameterName = "@Address", Value = registerdetails.Address, SqlDbType = SqlDbType.VarChar, Size = 50 }); command.Parameters.Add(new SqlParameter { ParameterName = "@DOB", Value = registerdetails.DOB, SqlDbType = SqlDbType.DateTime, Size = 50 }); command.Parameters.Add(new SqlParameter { ParameterName = "@MobileNo", Value = registerdetails.MobileNo, SqlDbType = SqlDbType.VarChar, Size = 50 }); command.Parameters.Add(new SqlParameter { ParameterName = "@PersonName", Value = registerdetails.PersonName, SqlDbType = SqlDbType.VarChar, Size = 50 }); command.Parameters.Add(new SqlParameter { ParameterName = "@PhoneNo", Value = registerdetails.PhoneNo, SqlDbType = SqlDbType.VarChar, Size = 50 }); command.Parameters.Add(new SqlParameter { ParameterName = "@Relationship", Value = registerdetails.Relationship, SqlDbType = SqlDbType.VarChar, Size = 50 }); command.ExecuteNonQuery(); } } catch (SqlException ex) { Console.WriteLine("A database occured: " + ex); return(false); } catch (Exception ex) { Console.WriteLine("A database occured: " + ex); return(false); } return(true); }