private async void showRecordBtn_Click(object sender, EventArgs e) { StorageSelector storage = new StorageSelector(); allEmpDataTable = await Task.FromResult<List<Employees>>(storage.getAllEmpDataTable()); //allEmpDataTable = storage.getAllEmpDataTable(); recordShowDataGridView.DataSource = allEmpDataTable; }
public List<EventNotifier> getAllNotifications(DateTime todaysDate,int days) { StorageSelector selectmethod =new StorageSelector(); List<Employees> allEmpDataTable = selectmethod.getAllEmpDataTable(); DateTime bdynextdays = todaysDate.AddDays(days); DateTime fiveyrs = todaysDate.AddYears(-5); DateTime fivenextyrs = todaysDate.AddYears(-5).AddDays(days); DateTime threeyrs = todaysDate.AddYears(-3); DateTime threenextyrs = todaysDate.AddYears(-3).AddDays(days); List<EventNotifier> listnotification = new List<EventNotifier>(); int total1; int total2; int total3; int noOfdays; DateTime threeyrsDate; foreach (Employees rows in allEmpDataTable) { total1 = rows.DateOfBirth.Day + rows.DateOfBirth.Month * 100; total2 = todaysDate.Day + todaysDate.Month * 100; total3= bdynextdays.Day + bdynextdays.Month * 100 ; if(total1 >= total2 && total1 <= total3) { noOfdays = rows.DateOfBirth.DayOfYear - todaysDate.DayOfYear; listnotification.Add(new EventNotifier(noOfdays, "BirthDay", rows.EmpName,rows.EmpLastName, rows.EmailId)); } threeyrsDate = rows.DateOfJoining; if (threeyrsDate >= threeyrs && threeyrsDate <= threenextyrs) { noOfdays = threeyrsDate.DayOfYear - todaysDate.DayOfYear; listnotification.Add(new EventNotifier(noOfdays, "Three Years", rows.EmpName, rows.EmpLastName, rows.EmailId)); } if (threeyrsDate >= fiveyrs && threeyrsDate <= fivenextyrs) { noOfdays = threeyrsDate.DayOfYear - todaysDate.DayOfYear; listnotification.Add(new EventNotifier(noOfdays, "Five Years", rows.EmpName, rows.EmpLastName, rows.EmailId)); } } return listnotification; }
private void submitTxt_Click(object sender, EventArgs e) { bool flag = true; Regex rx_name = new Regex("^[a-zA-Z ]+$"); Regex rx_ename = new Regex("([A-Za-z0-9])+@([A-Za-z0-9]{3,15})+.([A-Za-z]{2,4})$"); if (!rx_name.IsMatch(nameTxtBox.Text)) { errNameLabel.Text = "name must be entererd"; flag = false; } else { errNameLabel.Text = ""; flag = true; } if (!rx_name.IsMatch(middleNameTxtBox.Text)) { errMName.Text = "enter middle name"; flag = false; } else { errMName.Text = ""; flag = true; } if (!rx_name.IsMatch(lastNameTxtBox.Text)) { errLName.Text = "enter last name"; flag = false; } else { errLName.Text = ""; flag = true; } if(!rx_ename.IsMatch(emailTxtBox.Text)) { errEmailLabel.Text ="enter email"; flag = false; } else { errEmailLabel.Text = ""; flag = true; } if(!rx_name.IsMatch(designationTxtBox.Text)) { errDesignationLabel.Text ="enter designation"; flag = false; } else { errDesignationLabel.Text = ""; flag = true; } if(!rx_name.IsMatch(descriptionTxtBox.Text)) { errDescriptionLabel.Text = "enter hobbies"; flag = false; } else { errDescriptionLabel.Text = ""; flag = true; } StorageSelector addempObj = new StorageSelector(); string empname = nameTxtBox.Text.Trim(); string emplastname = lastNameTxtBox.Text.Trim(); string empmiddlename = middleNameTxtBox.Text.Trim(); string empprifix = prefixComboBox.SelectedItem.ToString(); DateTime dateofbirth = Convert.ToDateTime(DOBdateTimePicker.Text).Date; DateTime dateofjoining = Convert.ToDateTime(joiningDateDateTimePicker.Text).Date; string value = ""; if (maleRadioButton.Checked) value = maleRadioButton.Text; else if (femaleRadioButton.Checked) value = femaleRadioButton.Text; string empgender = value; string emailid = emailTxtBox.Text.Trim(); string designation = designationTxtBox.Text.Trim(); string empimagepath = imgName; string description = descriptionTxtBox.Text; Int32 teamId = (Int32)teamIdComboBox.SelectedValue; addempObj.AddEmployee(empname, emplastname, dateofbirth, dateofjoining, emailid, designation, empgender, empprifix, empmiddlename, empimagepath,description,teamId); MessageBox.Show("employee added successfully"); }