public int Update(LoginItem model)
{
Mapper.CreateMap <LoginItem, Login_Master>();
Login_Master objBranch = DbContext.Login_Master.SingleOrDefault(m => m.UId == model.UId);
objBranch = Mapper.Map(model, objBranch);
return(DbContext.SaveChanges());
}
public LoginItem GetDetails(string UserName, String Password)
{
Mapper.CreateMap <Login_Master, LoginItem>();
Login_Master Login = dbcontext.Login_Master.FirstOrDefault(m => m.UserName == UserName && m.Password == Password);
LoginItem objLogin = Mapper.Map <LoginItem>(Login);
return(objLogin);
}
public int Insert(LoginItem model)
{
try
{
Mapper.CreateMap <LoginItem, Login_Master>();
Login_Master objLogin = Mapper.Map <Login_Master>(model);
DbContext.Login_Master.Add(objLogin);
return(DbContext.SaveChanges());
}
catch (Exception ex)
{
throw;
}
}
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);
}
public LoginItem GetById(int id)
{
Mapper.CreateMap <Login_Master, LoginItem>();
Login_Master objBranch = DbContext.Login_Master.SingleOrDefault(m => m.UId == id);
LoginItem objBItem = Mapper.Map <LoginItem>(objBranch);
return(objBItem);
//var a = (
// from umt in DbContext.UserFormTrans
// join lm in DbContext.Login_Master on umt.UID equals lm.UId
// where lm.UId==id
// select new LoginItem()
// {
// UMTID=umt.UMTID,
// UId=umt.UID,
// FormId=umt.FormID,
// IsChecked=umt.IsChecked
// }
// ).SingleOrDefault();
//return a;
}
