private void FrmAddUser_Load(object sender, EventArgs e)
{
using (SPEntities db = new SPEntities())
{
accessLevelBindingSource1.DataSource = db.Access_Level.ToList();
}
}
private void frmPunblblishSms_Load(object sender, EventArgs e)
{
using (SPEntities db = new SPEntities())
{
clientBindingSource.DataSource = db.Clients.ToList();
}
var quary = db.Email_Notice_Template.Where(co => co.Template_Id == val).FirstOrDefault();
textBox1.Text = quary.Template_Text;
}
private void FrmPublish_Load(object sender, EventArgs e)
{
dataGridView1.ReadOnly = false;
dataGridView1.MultiSelect = true;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView2.ReadOnly = false;
dataGridView2.MultiSelect = true;
dataGridView2.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
using (SPEntities db = new SPEntities())
{
clientBindingSource8.DataSource = db.Clients.ToList();
}
txtFrom.Text = db.Company_Information.Select(co => co.Company_Name).FirstOrDefault();
var comp = db.Company_Information.FirstOrDefault();
var quary = db.Email_Notice_Template.Where(co => co.Template_Id == val).FirstOrDefault();
txtSubjectLine.Text = quary.Template_Description;
listBox1.Items.Add("");
listBox1.Items.Add(Environment.NewLine);
listBox1.Items.Add(Environment.NewLine);
listBox1.Items.Add(quary.Template_Text);
listBox1.Items.Add(Environment.NewLine);
listBox1.Items.Add(Environment.NewLine);
listBox2.Items.Add("Kind Regards");
listBox2.Items.Add(Environment.NewLine);
listBox2.Items.Add(Environment.NewLine);
listBox2.Items.Add("Lopac Tissues");
listBox2.Items.Add(Environment.NewLine);
listBox2.Items.Add("Contact Number: " + comp.Telephone_Number);
listBox2.Items.Add("Email: " + comp.Email_Address);
}
private void frmPublishSms_Load(object sender, EventArgs e)
{
dataGridView1.ReadOnly = false;
dataGridView1.MultiSelect = true;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView2.ReadOnly = false;
dataGridView2.MultiSelect = true;
dataGridView2.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
using (SPEntities db = new SPEntities())
{
clientBindingSource.DataSource = db.Clients.ToList();
}
var quary = db.Email_Notice_Template.Where(co => co.Template_Id == val).FirstOrDefault();
txt_message.Text = quary.Template_Text;
}
private void FrmMaintainUser_Load(object sender, EventArgs e)
{
using (SPEntities db = new SPEntities())
{
accessLevelBindingSource1.DataSource = db.Access_Level.ToList();
}
cbAccessLevelName.DataSource = db.Access_Level.ToList();
var query = db.Active_User.Where(co => co.Active_User_Id == AccessIds).FirstOrDefault();
txtUsername.Text = query.Username;
txtPassword.Text = query.pass;
txtConfirmPassword.Text = query.pass;
var query1 = db.Access_Level.Where(co => co.Access_Level_Id == query.Access).FirstOrDefault();
cbAccessLevelName.Text = query1.Access_Level_Name;
//cbAccessLevelName.ValueMember = "Access_Level_Name";
//var query = db.Access_Level.Where(co => co.Access_Level_Id == AccessIds).FirstOrDefault();
//var mark = db.User_Role.Where(co => co.User_Role_Id == query.Access_Level_Id).FirstOrDefault();
}
