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