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