public int CreateStutent(StudentModel studentModel) { try { using (MVCDemoEntities objEntities = new MVCDemoEntities()) { Student std = new Student(); std.Id = studentModel.Id; std.Name = studentModel.Name; std.FatherName = studentModel.FatherName; std.Gender = studentModel.Gender; std.RollNo = studentModel.RollNo; objEntities.Students.Add(std); objEntities.SaveChanges(); return(std.Id); } } catch (Exception ex) { return(0); } }
public List <StudentModel> GetAllStudent() { List <StudentModel> lststudents = new List <StudentModel>(); try { using (MVCDemoEntities objEntities = new MVCDemoEntities()) { var allstudents = objEntities.Students.ToList(); foreach (var std in allstudents) { StudentModel studentModel = new StudentModel(); studentModel.Id = std.Id; studentModel.Name = std.Name; studentModel.FatherName = std.FatherName; studentModel.Gender = std.Gender; studentModel.RollNo = std.RollNo; lststudents.Add(studentModel); } } return(lststudents); } catch (Exception ex) { return(lststudents); } }
public int UpdateStutent(StudentModel studentModel) { try { using (MVCDemoEntities mvcdemoEntity = new MVCDemoEntities()) { var student = mvcdemoEntity.Students.Where(a => a.Id == studentModel.Id).FirstOrDefault(); student.Name = studentModel.Name; student.RollNo = studentModel.RollNo; student.Gender = studentModel.Gender; student.FatherName = studentModel.FatherName; mvcdemoEntity.SaveChanges(); return(student.Id); } } catch (Exception ex) { return(0); } }
/// <summary> /// For Get MEMEBER CODE /// </summary> /// <returns></returns> public static string GetNextEmployeeCode() { try { string Code = ConfigurationManager.AppSettings["EmployeeCode"]; int EmployeeCount = 0; List <string> EmpCodeList = new List <string>(); string NewEmpCode = null; using (MVCDemoEntities mVCDemoEntities = new MVCDemoEntities()) { var resUser = (from objUser in mVCDemoEntities.Users select objUser).ToList(); EmployeeCount = resUser.Count + 1; for (int i = 1; i <= EmployeeCount; i++) { string p1 = Code + i; string i2 = i.ToString(); int h = i2.Length; int u = Code.Length - h; string y = p1.Substring(0, u); p1 = y + i; EmpCodeList.Add(p1); } var GetDetail = (from obj in EmpCodeList orderby obj descending select obj).FirstOrDefault(); if (GetDetail != null) { NewEmpCode = GetDetail; } } return(NewEmpCode); } catch (Exception ex) { throw ex; } }
public StudentModel GetStudent(int Id) { try { using (MVCDemoEntities mvcdemoEntity = new MVCDemoEntities()) { var student = mvcdemoEntity.Students.Where(a => a.Id == Id).FirstOrDefault(); StudentModel studentModel = new StudentModel(); studentModel.Id = student.Id; studentModel.Name = student.Name; studentModel.FatherName = student.FatherName; studentModel.RollNo = student.RollNo; studentModel.Gender = student.Gender; return(studentModel); } } catch (Exception ex) { return(new StudentModel()); } }
public AdminDb() { dc = new MVCDemoEntities(); }
public UserDb() { mVCDemoEntities = new MVCDemoEntities(); }