private int getRoleCode(string Rolename) { int RoleCode; using (var DBContext = new bmfsEntities()) { RoleCode = DBContext.codesuserroles.Where(e => e.UserRoleName == Rolename).First().UserRoleCode; }; return(RoleCode); }
private void YearListBox_SelectedIndexChanged(object sender, EventArgs e) { int yearFn = Convert.ToInt32(YearListBox.SelectedValue.ToString()); using (var DBContext = new bmfsEntities()) { var PIname = (from u in DBContext.primaryinvestigatoryears where u.Year == yearFn select u.FirstName + " " + u.LastName).Distinct(); PIListBox.DataSource = PIname.ToList(); } }
private void AddUser_Load(object sender, EventArgs e) { using (var DBContext = new bmfsEntities()) { var role = from u in DBContext.codesuserroles select u.UserRoleName; comboBox1.DisplayMember = "UserRoleName"; comboBox1.ValueMember = "UserRoleCode"; comboBox1.DataSource = role.ToList(); } }
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 Addfiles_Load(object sender, EventArgs e) { // getting the PI name fro database var source = new AutoCompleteStringCollection(); using (var DBContext = new bmfsEntities()) { PIdatabseList = DBContext.primaryinvestigatoryears.ToList(); }; // Create the list to use as the custom source. source.AddRange(GettheNameOfPI(PIdatabseList)); PIName.AutoCompleteCustomSource = source; PIName.AutoCompleteMode = AutoCompleteMode.SuggestAppend; PIName.AutoCompleteSource = AutoCompleteSource.CustomSource; }
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(); } }
private void Sign_Click(object sender, EventArgs e) { using (var DBContext = new bmfsEntities()) { if (DBContext.users.Where(u => u.UserName == LoginTxtBox.Text && u.Password == PwdTxtBox.Text).Count() > 0) { LoggedInUser.UserName = LoginTxtBox.Text; this.Hide(); FileTable fileTable = new FileTable(); fileTable.Show(); } else { string message = "Please Check the Username/Password"; string caption = "Login Error"; MessageBoxButtons buttons = MessageBoxButtons.YesNo; DialogResult result; // Displays the MessageBox. result = MessageBox.Show(message, caption, buttons); } } }
private void FileTable_Load(object sender, EventArgs e) { int yearFn; using (var DBContext = new bmfsEntities()) { var role = DBContext.primaryinvestigatoryears.Select(s => s.Year).Distinct(); YearListBox.DataSource = role.ToList(); role.ToList().Sort(); role.Reverse(); yearFn = role.First(); } try { using (var DBContext = new bmfsEntities()) { var PIname = (from u in DBContext.primaryinvestigatoryears where u.Year == yearFn select u.FirstName + " " + u.LastName).Distinct(); PIListBox.DataSource = PIname.ToList(); } } catch { } }