protected void b1_Click(object sender, EventArgs e)
{
DataClassesDataContext ob = new DataClassesDataContext();
Student_Master SM = new Student_Master();
Login_Master LM = new Login_Master();
Boolean bn = false;
string rolno = "";
string usnm = "";
string DataExist = ValidData(f1.Text);
string DataExist1 = ValidData1(f6.Text);
if (DataExist == "F")
{
Label2.ForeColor = System.Drawing.Color.Red;
Label2.Text = "Roll Number Already Exists";
}
else if (DataExist1 == "F")
{
Label3.ForeColor = System.Drawing.Color.Red;
Label3.Text = "UserName Already Exists";
}
else
{
SM.Roll_No = f1.Text;
SM.Name = f2.Text;
SM.Department = ddl1.SelectedValue.ToString();
SM.DeptCode = ddl2.SelectedValue.ToString();
SM.Year = f5.Text;
SM.UserName = f6.Text;
SM.Email = f8.Text;
SM.Mobile = f9.Text;
SM.ValidUpto = Convert.ToDateTime(fi1.Text);
SM.Status = true;
ob.Student_Masters.InsertOnSubmit(SM);
ob.SubmitChanges();
LM.UserName = f6.Text;
LM.Password = f7.Text;
LM.Status = true;
Label1.ForeColor = System.Drawing.Color.Lime;
Label1.Text = "User Created Successfully..";
ob.Login_Masters.InsertOnSubmit(LM);
ob.SubmitChanges();
}
}
private string ValidData1(string usnm)
{
DataClassesDataContext ob = new DataClassesDataContext();
Student_Master SM = new Student_Master();
Login_Master LM = new Login_Master();
Issued_Master IM = new Issued_Master();
string bn = "S";
var data1 = from a in ob.Login_Masters
where a.UserName == usnm
select new
{
usnm = a.UserName
};
foreach (var d in data1)
{
bn = "F";
usnm = d.usnm;
}
return(bn);
}
private string ValidData(string rolno)
{
DataClassesDataContext ob = new DataClassesDataContext();
Student_Master SM = new Student_Master();
Login_Master LM = new Login_Master();
Issued_Master IM = new Issued_Master();
string bn = "S";
var data = from a in ob.Student_Masters
where a.Roll_No == rolno
select new
{
rolno = a.Roll_No
};
foreach (var d in data)
{
bn = "F";
rolno = d.rolno;
}
return(bn);
}
