private void button1_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(Email.Text))
{
Regex reg = new Regex(@"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*");
if (!reg.IsMatch(Email.Text))
{
string message = "Please Check the Email";
string caption = "Error Detected in Input";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
}
else
{
BMFS.primaryinvestigatoryear users = new BMFS.primaryinvestigatoryear();
users.FirstName = FstName.Text;
users.LastName = LstName.Text;
users.MiddleName = MidName.Text;
users.Email = Email.Text;
users.IsDeleted = Convert.ToBoolean(IsDeleted.Checked);
users.CreatedBy = LoggedInUser.UserName;
users.CreatedAt = DateTime.Now;
users.UpdatedBy = LoggedInUser.UserName;
users.Year = Convert.ToInt32(dateTimePicker1.Text);
users.LastUpdated = DateTime.Now;
using (var DBContext = new bmfsEntities())
{
DBContext.primaryinvestigatoryears.Add(users);
DBContext.SaveChanges();
string message = "Primary Investigator is Added";
string caption = "Primary Investigator";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
if (result == DialogResult.Yes)
{
FstName.Text = "";
LstName.Text = "";
MidName.Text = "";
Email.Text = "";
}
}
}
}
}
private void SaveBtn_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(Email.Text))
{
Regex reg = new Regex(@"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*");
if (!reg.IsMatch(Email.Text))
{
string message = "Please Check the Email";
string caption = "Error Detected in Input";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
}
else
{
BMFS.user users = new BMFS.user();
users.UserName = UserName.Text;
users.Password = Password.Text;
users.Email = Email.Text;
users.Role = getRoleCode(comboBox1.SelectedValue.ToString());
users.IsActive = Convert.ToBoolean(IsActive.Checked);
users.CreatedBy = LoggedInUser.UserName;
users.CreatedAt = DateTime.Now;
using (var DBContext = new bmfsEntities())
{
DBContext.users.Add(users);
DBContext.SaveChanges();
string message = "User is Added";
string caption = "User Info";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
if (result == DialogResult.Yes)
{
UserName.Text = "";
Password.Text = "";
Email.Text = "";
}
}
}
}
}
private void UploadFileToDatabase(string description, byte[] barray, string FileName)
{
//adding file to database
BMFS.file addFiles = new BMFS.file();
string[] PiFirstname = PIName.Text.Split(',');
int PrimryID = PIdatabseList.Where(s => s.FirstName == PiFirstname[0] && s.LastName == PiFirstname[1]).Select(s => s.PrimaryInvestigatorID).First();
addFiles.PrimaryInvestigatorID = PrimryID;
addFiles.FileShortDescription = description;
addFiles.FileDescription = description;
addFiles.CreatedAt = DateTime.Now;
addFiles.CreatedBy = LoggedInUser.UserName;
addFiles.FileData = barray;
addFiles.UpdatedBy = LoggedInUser.UserName;
addFiles.LastUpdated = DateTime.Now;
addFiles.FileName = FileName;
using (var DBContext = new bmfsEntities())
{
DBContext.files.Add(addFiles);
DBContext.SaveChanges();
}
}
