private void OkBtn_Click(object sender, EventArgs e)
{
_00_Databases._01_LIFSAcademyDataContext LFAD = new _00_Databases._01_LIFSAcademyDataContext();
if (ComboSubject.Text == "" && TextTitle.text == "" && TextUserNo.text == "" && TextQCNum.text == "" && DatePickerFirst.Value.ToShortDateString() == "1.01.1975" && DatePickerLast.Value.ToShortDateString() == "1.01.1975" && DatePickerRev1.Value.ToShortDateString() == "1.01.1975" && DatePickerRev2.Value.ToShortDateString() == "1.01.1975")
{
DataGridContent.DataSource = LFAD.LIFSCONTENT;
}
else if (ComboSubject.Text == "" && TextTitle.text == "" && TextUserNo.text != "" && TextQCNum.text == "" && DatePickerFirst.Value.ToShortDateString() == "1.01.1975" && DatePickerLast.Value.ToShortDateString() == "1.01.1975" && DatePickerRev1.Value.ToShortDateString() == "1.01.1975" && DatePickerRev2.Value.ToShortDateString() == "1.01.1975")
{
var Query = LFAD.LIFSCONTENT.Where(s => s.USERID == Convert.ToInt32(TextUserNo.text)).Select(s => s);
DataGridContent.DataSource = Query;
}
else if (ComboSubject.Text == "" && TextTitle.text == "" && TextUserNo.text == "" && TextQCNum.text != "" && DatePickerFirst.Value.ToShortDateString() == "1.01.1975" && DatePickerLast.Value.ToShortDateString() == "1.01.1975" && DatePickerRev1.Value.ToShortDateString() == "1.01.1975" && DatePickerRev2.Value.ToShortDateString() == "1.01.1975")
{
var Query = LFAD.LIFSCONTENT.Where(s => s.QUALITYCONTROL == Convert.ToInt32(TextQCNum.text)).Select(s => s);
DataGridContent.DataSource = Query;
}
else if (ComboSubject.Text == "" && TextTitle.text == "" && TextUserNo.text != "" && TextQCNum.text != "" && DatePickerFirst.Value.ToShortDateString() == "1.01.1975" && DatePickerLast.Value.ToShortDateString() == "1.01.1975" && DatePickerRev1.Value.ToShortDateString() == "1.01.1975" && DatePickerRev2.Value.ToShortDateString() == "1.01.1975")
{
var Query = LFAD.LIFSCONTENT.Where(s => s.QUALITYCONTROL == Convert.ToInt32(TextQCNum.text) && s.USERID == Convert.ToInt32(TextUserNo.text)).Select(s => s);
DataGridContent.DataSource = Query;
}
else if (ComboSubject.Text != "" && TextTitle.text == "" && TextUserNo.text == "" && TextQCNum.text == "" && DatePickerFirst.Value.ToShortDateString() == "1.01.1975" && DatePickerLast.Value.ToShortDateString() == "1.01.1975" && DatePickerRev1.Value.ToShortDateString() == "1.01.1975" && DatePickerRev2.Value.ToShortDateString() == "1.01.1975")
{
var Query = LFAD.LIFSCONTENT.Where(s => s.SUBJECT == ComboSubject.Text).Select(s => s);
DataGridContent.DataSource = Query;
}
}
public void OnlineControl()
{
_00_Databases._01_LIFSAcademyDataContext LIFS = new _00_Databases._01_LIFSAcademyDataContext();
var datauser = from x in LIFS.LIFSLOGIN
select x;
i = 0;
j = tableLayoutPanel1.RowCount - 1;
foreach (var item in datauser)
{
tableLayoutPanel1.Controls[j - i].BackgroundImage = Image.FromFile(item.PROFIL);
tableLayoutPanel2.Controls[j - i].Text = item.NAME + " " + item.LASTNAME;
if (item.ONLINESTATUS == 0)
{
tableLayoutPanel3.Controls[j - i].BackColor = Color.Red;
}
else
{
tableLayoutPanel3.Controls[j - i].BackColor = Color.RoyalBlue;
}
i++;
}
LIFS.Dispose();
}
private void AddBtn_Click(object sender, EventArgs e)
{
try
{
_00_Databases._01_LIFSAcademyDataContext LIFS = new _00_Databases._01_LIFSAcademyDataContext();
_00_Databases.LIFSCONTENT Content = new _00_Databases.LIFSCONTENT();
Content.SUBJECT = ComboSubject.Text;
Content.TITLE = TextTitle.Text.ToUpper();
Content.USERID = Convert.ToInt32(_02_LoginForm.UserInfo[0]);
Content.ADDDATE = Convert.ToDateTime(DateTime.Now.ToLongDateString());
Content.CONTETT = RichTextContent.Text;
Content.QUALITYCONTROL = 0;
Content.REV = 0;
Content.REVDATE = null;
LIFS.LIFSCONTENT.InsertOnSubmit(Content);
LIFS.SubmitChanges();
BL.LabelInfo(LblInfo, "Kayıt Başarılı");
BL.InfoColorSuccess(PanelColor);
BL.DataContentSelect(DataGridContent);
ComboSubject.Text = "";
TextTitle.Text = "";
RichTextContent.Text = "";
}
catch (Exception)
{
BL.LabelInfo(LblInfo, "Kayıt Gerçekleşmedi");
BL.InfoColorError(PanelColor);
}
}
private void _05_ContentForm_Load(object sender, EventArgs e)
{
_00_Databases._01_LIFSAcademyDataContext LFAD = new _00_Databases._01_LIFSAcademyDataContext();
var Subject = LFAD.LIFSSUBJECT.Select(s => s);
foreach (var item in Subject)
{
ComboSubject.Items.Add(item.SUBJECTNAME);
}
}
private void PicClose_Click(object sender, EventArgs e)
{
_00_Databases._01_LIFSAcademyDataContext LFAD = new _00_Databases._01_LIFSAcademyDataContext();
_00_Databases.LIFSLOGIN User2 = LFAD.LIFSLOGIN.First(s => s.USERDID == Convert.ToInt32(_02_Forms._02_LoginForm.UserInfo[0]));
User2.ONLINESTATUS = 0;
LFAD.SubmitChanges();
Application.Exit();
}
private void _08_AddTermCardForm_Load(object sender, EventArgs e)
{
_00_Databases._01_LIFSAcademyDataContext LIFS = new _00_Databases._01_LIFSAcademyDataContext();
BL.DataContentSelect(DataGridContent);
var Subject = LIFS.LIFSSUBJECT.Select(s => s);
foreach (var item in Subject)
{
ComboSubject.Items.Add(item.SUBJECTNAME);
}
}
private void _12_DeleteTermCardForm_Load(object sender, EventArgs e)
{
_00_Databases._01_LIFSAcademyDataContext LFAD = new _00_Databases._01_LIFSAcademyDataContext();
DataGridContent.DataSource = from x in LIFS.LIFSCONTENT
select x;
var Subject = LFAD.LIFSSUBJECT.Select(s => s);
foreach (var item in Subject)
{
ComboSubject.Items.Add(item.SUBJECTNAME);
}
}
private void SignInBtn_Click_1(object sender, EventArgs e)
{
UserName = TextUserName.text;
Password = TextPassword.text;
_00_Databases._01_LIFSAcademyDataContext LFAD = new _00_Databases._01_LIFSAcademyDataContext();
var User = LFAD.LIFSLOGIN.Where((w => w.USERNAME == UserName && w.PASSWORD == Password)).FirstOrDefault();
if (User == null)
{
MessageBox.Show("Olmadı");
}
else if (UserName == User.USERNAME && Password == User.PASSWORD)
{
_03_MainForm MF = new _03_MainForm();
UserInfo[0] = User.USERDID.ToString();
UserInfo[1] = User.USERNAME.ToString();
UserInfo[2] = User.PASSWORD.ToString();
UserInfo[3] = User.AUTHORITY.ToString();
UserInfo[4] = User.PROFIL.ToString();
UserInfo[5] = User.NAME.ToString();
UserInfo[6] = User.LASTNAME.ToString();
_00_Databases.LIFSLOGIN User2 = LFAD.LIFSLOGIN.First(s => s.USERDID == Convert.ToInt32(UserInfo[0]));
User2.ONLINESTATUS = 1;
LFAD.SubmitChanges();
UserInfo[7] = User.ONLINESTATUS.ToString();
UserInfo[8] = User.USERAKA;
this.Hide();
MF.Show();
}
}
public void DC()
{
_00_Databases._01_LIFSAcademyDataContext LIFS = new _00_Databases._01_LIFSAcademyDataContext();
}
