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