private void Add_Click(object sender, EventArgs e)
{
int flag = 0;
try
{
AdvisorClass stu = new AdvisorClass();
stu.Gender = null;
stu.LastName = null;
stu.Contact = null;
stu.DateOfBirth = null;
stu.Salary = null;
if (Regexp("^[a-zA-Z]{1,100}", FirstNameTextBox, FNError, "Only alphabets are allowed.", 100))
{
stu.FirstName = FirstNameTextBox.Text;
flag++;
}
if ((string.IsNullOrEmpty(LastNameTextBox.Text)))
{
flag++;
}
else if (Regexp("^[a-zA-Z]{1,100}", LastNameTextBox, LNError, "Only alphabets are allowed.", 100))
{
stu.LastName = LastNameTextBox.Text;
flag++;
}
if ((string.IsNullOrEmpty(ContactTextBox.Text)))
{
flag++;
}
else if (Regexp("^[0-9]{1,20}", ContactTextBox, ConError, "Only valid numbers are allowed.", 20))
{
stu.Contact = ContactTextBox.Text;
flag++;
}
if (Regexp("^([\\w\\.\\-]+)@([\\w\\-]+)((\\.(\\w){2,3})+)$", EmailTextBox, EmailError, "Format not correct eg. [email protected]", 30))
{
stu.Email = EmailTextBox.Text;
String cmd1 = "Select Id from Person Where Email = '" + EmailTextBox.Text + "'";
var reader1 = DatabaseConnection.getInstance().getData(cmd1);
while (reader1.Read())
{
flag--;
EmailError.Text = "Already exists";
EmailError.ForeColor = System.Drawing.Color.Red;
}
flag++;
}
stu.DateOfBirth = DateOfBirthPick.Value;
flag++;
if ((string.IsNullOrEmpty(SalaryTextBox.Text)))
{
flag++;
}
else if (Regexp("[0-9]{1,18}", SalaryTextBox, SalaryError, "Only valid numbers are allowed.", 18))
{
stu.Salary = Convert.ToDecimal(SalaryTextBox.Text);
flag++;
}
String cmd = "Select Id from Lookup Where Category = 'GENDER' AND Value = '" + GenderComboBox.Text + "'";
var reader = DatabaseConnection.getInstance().getData(cmd);
while (reader.Read())
{
stu.Gender = (int)reader.GetValue(0);
}
flag++;
cmd = "Select Id from Lookup Where Category = 'DESIGNATION' AND Value = '" + DesComboBox.Text + "'";
reader = DatabaseConnection.getInstance().getData(cmd);
while (reader.Read())
{
stu.Designation = (int)reader.GetValue(0);
}
flag++;
if (flag == 8)
{
cmd = String.Format("INSERT INTO Person(FirstName, LastName, Contact, Email, DateOfBirth, Gender) values('{0}','{1}','{2}','{3}','{4}','{5}')", stu.FirstName, stu.LastName, stu.Contact, stu.Email, stu.DateOfBirth, stu.Gender);
DatabaseConnection.getInstance().exectuteQuery(cmd);
cmd = "Select Id from Person Where Email = '" + stu.Email + "'";
reader = DatabaseConnection.getInstance().getData(cmd);
int?id = null;
while (reader.Read())
{
id = (int)reader.GetValue(0);
}
if (id != null)
{
cmd = String.Format("Insert INTO Advisor(Id, Designation, Salary) values('{0}', '{1}', '{2}')", id, stu.Designation, stu.Salary);
DatabaseConnection.getInstance().exectuteQuery(cmd);
}
par.Refresh();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Project()
{
InitializeComponent();
this.MinimumSize = new Size(this.Width, this.Height);
try
{
String cmd = "Select Id, Title, Description from Project";
var reader = DatabaseConnection.getInstance().getData(cmd);
List <ProjectClass> students = new List <ProjectClass>();
while (reader.Read())
{
ProjectClass stu = new ProjectClass();
stu.Id = (int)reader.GetValue(0);
stu.Titlle = reader.GetString(1);
stu.Description = reader.GetString(2);
students.Add(stu);
}
ProjectDataGrid.DataSource = students;
ProjectDataGrid.Columns[0].Visible = false;
ProjectDataGrid.Columns[2].Visible = false;
DataGridViewButtonColumn bcol3 = new DataGridViewButtonColumn();
bcol3.HeaderText = "";
bcol3.Text = "Details";
bcol3.Name = "btnDetails";
bcol3.UseColumnTextForButtonValue = true;
ProjectDataGrid.Columns.Add(bcol3);
DataGridViewButtonColumn bcol = new DataGridViewButtonColumn();
bcol.HeaderText = "";
bcol.Text = "Edit";
bcol.Name = "btnEdit";
bcol.UseColumnTextForButtonValue = true;
ProjectDataGrid.Columns.Add(bcol);
DataGridViewButtonColumn bcol1 = new DataGridViewButtonColumn();
bcol1.HeaderText = "";
bcol1.Text = "Delete";
bcol1.Name = "btnDelete";
bcol1.UseColumnTextForButtonValue = true;
ProjectDataGrid.Columns.Add(bcol1);
DataGridViewButtonColumn bcol2 = new DataGridViewButtonColumn();
bcol2.HeaderText = "";
bcol2.Text = "Group";
bcol2.Name = "btnGroup";
bcol2.UseColumnTextForButtonValue = true;
ProjectDataGrid.Columns.Add(bcol2);
cmd = "Select Title from Project";
reader = DatabaseConnection.getInstance().getData(cmd);
int i = 0;
while (reader.FieldCount > i)
{
if (!SearchCategory.Items.Contains(reader.GetName(i)))
{
SearchCategory.Items.Add(reader.GetName(i));
}
i++;
}
SearchCategory.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}