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