//public List<Subject> GetSubjects()
//{
// string sql = "select SubjectId,SubjectName,SubjectDescription,Subjects.CourseId,Courses.CourseName, Subjects.InsertedOn,Subjects.CreatedBy,Subjects.ModifiedBy,Subjects.ModifiedOn,Subjects.ModifiedBy,Subjects.ClassId,Classes.ClassName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName ";
// sql += "from Subjects join Courses on Subjects.CourseId=Courses.CourseId join Classes on Subjects.ClassId = Classes.ClassId join Users on Subjects.CreatedBy=Users.UserId left join Users as Users_1 on Subjects.ModifiedBy=Users_1.UserId";
// List<Subject> modelList = db.Query<Subject>(sql).ToList();
// return modelList;
//}
//public Subject GetSubjects(long id)
//{
// string sql = "select SubjectId,SubjectName,SubjectDescription,Subjects.CourseId,Courses.CourseName, Subjects.InsertedOn,Subjects.CreatedBy,Subjects.ModifiedBy,Subjects.ModifiedOn,Subjects.ModifiedBy,Subjects.ClassId,Classes.ClassName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName ";
// sql += "from Subjects join Courses on Subjects.CourseId=Courses.CourseId join Classes on Subjects.ClassId = Classes.ClassId join Users on Subjects.CreatedBy=Users.UserId left join Users as Users_1 on Subjects.ModifiedBy=Users_1.UserId ";
// sql += "where SubjectId=@0";
// Subject objModel = db.Query<Subject>(sql, id).FirstOrDefault();
// return objModel;
//}
public bool Create(Subject objSubject)
{
int recAffected = 0;
DBConnectionString.Subject Subject = new DBConnectionString.Subject();
Subject.SubjectName = objSubject.SubjectName;
Subject.SubjectDescription = objSubject.SubjectDescription;
Subject.CourseId = objSubject.CourseId;
Subject.ClassId = objSubject.ClassId;
Subject.CreatedBy = objSubject.CreatedBy;
Subject.InsertedOn = DateTime.Now;
recAffected = Convert.ToInt32(Subject.Insert());
if (recAffected > 0)
{
return true;
}
return false;
}
//public List<Subject> GetSubjects()
//{
// string sql = "select SubjectId,SubjectName,SubjectDescription,Subjects.CourseId,Courses.CourseName, Subjects.InsertedOn,Subjects.CreatedBy,Subjects.ModifiedBy,Subjects.ModifiedOn,Subjects.ModifiedBy,Subjects.ClassId,Classes.ClassName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName ";
// sql += "from Subjects join Courses on Subjects.CourseId=Courses.CourseId join Classes on Subjects.ClassId = Classes.ClassId join Users on Subjects.CreatedBy=Users.UserId left join Users as Users_1 on Subjects.ModifiedBy=Users_1.UserId";
// List<Subject> modelList = db.Query<Subject>(sql).ToList();
// return modelList;
//}
//public Subject GetSubjects(long id)
//{
// string sql = "select SubjectId,SubjectName,SubjectDescription,Subjects.CourseId,Courses.CourseName, Subjects.InsertedOn,Subjects.CreatedBy,Subjects.ModifiedBy,Subjects.ModifiedOn,Subjects.ModifiedBy,Subjects.ClassId,Classes.ClassName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName ";
// sql += "from Subjects join Courses on Subjects.CourseId=Courses.CourseId join Classes on Subjects.ClassId = Classes.ClassId join Users on Subjects.CreatedBy=Users.UserId left join Users as Users_1 on Subjects.ModifiedBy=Users_1.UserId ";
// sql += "where SubjectId=@0";
// Subject objModel = db.Query<Subject>(sql, id).FirstOrDefault();
// return objModel;
//}
public bool Create(Subject objSubject)
{
int recAffected = 0;
DBConnectionString.Subject Subject = new DBConnectionString.Subject();
Subject.SubjectName = objSubject.SubjectName;
Subject.SubjectDescription = objSubject.SubjectDescription;
Subject.CourseId = objSubject.CourseId;
Subject.ClassId = objSubject.ClassId;
Subject.CreatedBy = objSubject.CreatedBy;
Subject.InsertedOn = DateTime.Now;
recAffected = Convert.ToInt32(Subject.Insert());
if (recAffected > 0)
{
return(true);
}
return(false);
}
public string Edit(DBConnectionString.Subject subject, string token)
{
try
{
if (ModelState.IsValid)
{
subject.ModifiedBy = _userStatistics.UserId;
subject.ModifiedOn = DateTime.Now;
if (subject.Update() > 0)
{
SaveFiles(token, this.GetType().Name, subject.SubjectId);
return(Convert.ToString(true));
}
return(Convert.ToString(false));
}
return(Convert.ToString(false));
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
