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
{
}
}
