public void SaveClassMaster(DBSite site, SectionMasterEntity sec)
{
string qry = "INSERT INTO tblSectionMaster(SectionName, SectionOrder ";
qry += " , UserID, FYear) VALUES(";
qry += "'" + sec.SectionName + "'";
qry += ", " + sec.SectionOrder;
qry += ", " + util.GetUserInsertQryMaster(Util_BLL.User);
qry += " )";
site.Execute(qry);
}
public void SaveTerm(DBSite site, TermMasterEntity trm)
{
string qry = "INSERT INTO tblTerm(TermName, TermStartDate, TermEndDate,";
qry += " UserID, FYear) VALUES(";
qry += "'" + trm.TermName + "'";
qry += ", '" + trm.TermStartDate + "'";
qry += ", '" + trm.TermEndDate + "'";
qry += ", " + util.GetUserInsertQryMaster(Util_BLL.User);
qry += " )";
site.Execute(qry);
}
public void SaveInfo(DBSite site, StockTransactionType trn)
{
string qry = " INSERT INTO "
+ " tblStockTransactionMaster"
+ "( "
+ "TransactionName"
+ ", Flow"
+ ", UserId, FYear )"
+ " VALUES( '" + trn.StockTransactionName + "'"
+ ", " + trn.StockTransactionFlow
+ ", " + util.GetUserInsertQryMaster(Util_BLL.User) //------ user insert query ----------
+ ")";
site.Execute(qry);
}
public void SaveClassMaster(DBSite site, ClassMasterEntity cls)
{
string qry = "INSERT INTO tblClassMaster(ClassName, ClassOrder ";
qry += " , UserID, FYear) VALUES(";
qry += "'" + cls.ClassName + "'";
qry += ", " + cls.ClassOrder;
qry += ", " + util.GetUserInsertQryMaster(Util_BLL.User);
//qry += ", " + UserBLL.userID;
//qry += ", " + UserBLL.fYear;
qry += " )";
site.Execute(qry);
}
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 void SaveExam(DBSite site, ExamMasterEntity exam)
{
string qry = "INSERT INTO tblExamMaster( ";
qry += " ExamName, ExamCode, ExamDate, MaxMarks, PassMarks ";
qry += " , TermId, ClassMasterID, SectionMasterID, ExamOrder, IsFormula,";
qry += " UserID, FYear) VALUES(";
qry += "'" + exam.ExamName + "'";
qry += ", '" + exam.ExamCode + "'";
qry += ", '" + exam.ExamDate + "'";
qry += ", " + exam.MaxMarks;
qry += ", " + exam.PassMarks;
qry += ", " + exam.TermId;
qry += ", " + exam.ClassMasterID;
qry += ", " + exam.SectionMasterID;
qry += ", " + exam.ExamOrder;
qry += ", " + exam.IsFormula;
qry += ", " + util.GetUserInsertQryMaster(Util_BLL.User);
qry += " )";
site.Execute(qry);
}