public void UpdateSubject(DBSite site, SubjectMasterEntity subject) { string qry = "UPDATE tblSubjectMaster SET "; qry += " SubjectName ='" + subject.SubjectName + "'"; qry += ", SubjectCode ='" + subject.SubjectCode + "'"; qry += ", SubjectGroupMasterId=" + subject.SubjectGroupID; qry += ", SubjectClassID =" + subject.SubjectClassID; qry += ", SubjectSectionID =" + subject.SubjectSectionID; qry += ", SubjectOrder=" + subject.SubjectOrder; qry += Util_BLL.GetUserWhereCondition(Util_BLL.User); qry += " AND SubjectMasterID=" + subject.SubjectMasterId; site.Execute(qry); }
public bool IsDulicateSubject(DBSite site, SubjectMasterEntity subject) { bool isDuplicate = true; string qry = ""; qry += "SELECT subject FROM tblExamMaster "; qry += Util_BLL.GetUserWhereCondition(Util_BLL.User); qry += " AND ExamName ='" + subject.SubjectName + "'"; //qry += " AND TermId =" + exam.TermId; //qry += " AND MaxMarks =" + exam.MaxMarks; DataTable dt = site.ExecuteSelect(qry); isDuplicate = dt.Rows.Count > 0; return(isDuplicate); }
public void SaveSubject(DBSite site, SubjectMasterEntity subject) { string qry = "INSERT INTO tblSubjectMaster(SubjectName, SubjectCode, SubjectGroupMasterId, SubjectClassID, "; qry += " SubjectSectionID, SubjectOrder, UserID, FYear) VALUES("; qry += "'" + subject.SubjectName + "'"; qry += ", '" + subject.SubjectCode + "'"; qry += ", " + subject.SubjectGroupID; qry += ", " + subject.SubjectClassID; qry += ", " + subject.SubjectSectionID; qry += ", " + subject.SubjectOrder; qry += ", " + util.GetUserInsertQryMaster(Util_BLL.User); qry += " )"; site.Execute(qry); }
public List <SubjectMasterEntity> GetSubjectsBySubUser(DBSite site, int userId, string id, bool BySubUser) { List <SubjectMasterEntity> subjects = new List <SubjectMasterEntity>(); string qry = ""; qry += "SELECT "; qry += " SubjectMasterId, SubjectName "; qry += " , SubjectOrder, SubjectCode"; qry += ", sub.SubjectGroupMasterId "; qry += ", SubjectGroupName "; qry += ", SubjectGroupType "; qry += ", sub.SubjectClassId "; qry += ", ISNull(ClassName, 'All') ClassName "; qry += ", sub.SubjectSectionId "; qry += ", IsNull(SectionName, 'All') SectionName "; qry += " , sub.UserID, sub.FYear "; qry += " FROM tblSubjectMaster sub "; qry += " LEFT OUTER JOIN tblSubjectGroupMaster sgp ON "; qry += " sub.SubjectGroupMasterId = sgp.SubjectGroupMasterId "; qry += " LEFT OUTER JOIN tblClassMaster cm ON "; qry += " cm.ClassMasterID = sub.SubjectClassId "; qry += " LEFT OUTER JOIN tblSectionMaster sm ON "; qry += " sm.SectionMasterId = sub.SubjectSectionID "; if (BySubUser) { qry += " INNER JOIN tblTeacherSubjects ts ON ts.SubjectId = sub.SubjectMasterID " + "AND ts.UserId=sub.userID AND ts.SubUserId=" + Util_BLL.SubUser.SubuserId; } qry += " Where sub.UserId = " + Util_BLL.User.UserId; if (id != string.Empty) { qry += "AND SubjectMasterId = " + id; } DataTable dt = site.ExecuteSelect(qry); SubjectMasterEntity sub; foreach (DataRow dr in dt.Rows) { sub = new SubjectMasterEntity(); sub.SubjectMasterId = util.CheckNullInt(dr["SubjectMasterId"]); sub.SubjectName = util.CheckNull(dr["SubjectName"]); sub.SubjectGroupID = util.CheckNullInt(dr["SubjectGroupMasterId"]); sub.SubjectGroupName = util.CheckNull(dr["SubjectGroupName"]); sub.SubjectGroupType = util.CheckNull(dr["SubjectGroupType"]); sub.SubjectClassID = util.CheckNullInt(dr["SubjectClassId"]); sub.SubjectClassName = util.CheckNull(dr["ClassName"]); sub.SubjectSectionID = util.CheckNullInt(dr["SubjectSectionID"]); sub.SubjectSectionName = util.CheckNull(dr["SectionName"]); sub.SubjectCode = util.CheckNull(dr["SubjectCode"]); sub.SubjectOrder = util.CheckNullInt(dr["SubjectOrder"]); sub.UserID = util.CheckNullInt(dr["UserID"]); sub.FYear = util.CheckNullInt(dr["FYear"]); subjects.Add(sub); } return(subjects); }