protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
site = new DBSite();
ddlClass.Items.Add(new ListItem("All", "-1"));
util.FillClass(site, ddlClass);
util.FillYear(ddlYear);
util.FillMonth(ddlMonth);
util.FillDay(ddlDay);
ddlYear.ClearSelection();
ddlYear.SelectedValue = (util.indianTime.Year).ToString();
//Select Current Month and Year to dropdowns
ddlMonth.ClearSelection();
ddlMonth.SelectedValue = (util.indianTime.Month).ToString();
ddlDay.ClearSelection();
// ddlDay.SelectedValue = (DateTime.Now.Day).ToString();
ddlDay.SelectedValue = (util.indianTime.Day).ToString();
//ddlDay.SelectedIndex = 8;
txtSearch.Text = util.indianTime.ToString();
}
}
protected void btnPost_Click(object sender, EventArgs e)
{
AttendanceBll aBll = new AttendanceBll();
site = new DBSite();
List <AttendanceBll.AttendanceEntity> attdList = new List <AttendanceBll.AttendanceEntity>();
AttendanceBll.AttendanceEntity atd;
foreach (GridViewRow gr in gridView1.Rows)
{
atd = new AttendanceBll.AttendanceEntity();
CheckBox cb = (CheckBox)gr.Cells[0].FindControl("ckbPresent");
if (cb.Checked)
{
atd.Status = 1;
}
else
{
atd.Status = 0;
}
atd.AttendanceId = util.CheckNullInt(gr.Cells[2].Text);
attdList.Add(atd);
}
aBll.PostAttendance(site, attdList);
}
protected void gridView1_SelectedIndexChanged(object sender, EventArgs e)
{
ClearAll();
edit_mode = true;
site = new DBSite();
GridViewRow row = gridView1.SelectedRow;
lblExamMasterId.Text = row.Cells[3].Text;
SubjectMasterBLL sBll = new SubjectMasterBLL();
ExamMasterBll exBll = new ExamMasterBll();
ExamMasterBll.ExamMasterEntity exam = exBll.GetExamList(site, Util_BLL.User.UserId, lblExamMasterId.Text)[0];
lblExamMasterId.Text = util.CheckNull(exam.ExamMasterId);
txtExamName.Text = exam.ExamName;
txtExamCode.Text = exam.ExamCode;
///txtExamDate.Text = exam.ExamDate;
txtMaxMarks.Text = util.CheckNull(exam.MaxMarks);
txtPassMarks.Text = util.CheckNull(exam.PassMarks);
ddlClass.SelectedValue = util.CheckNull(exam.ClassMasterID);
ddlSection.SelectedValue = util.CheckNull(exam.SectionMasterID);
ddlTerm.SelectedValue = util.CheckNull(exam.TermId);
}
public string GetMobileNos(DBSite site, List <AttendanceEntity> attdList)
{
string mobileNos = "";
string attdIds = "";
foreach (AttendanceEntity atd in attdList)
{
attdIds += atd.AttendanceId + ", ";
}
attdIds += "-1111";
string qry = "SELECT MobileF "
+ " from tblAttendance a "
+ " INNER JOIN tblStudentMaster s ON s.StudentMasterID = a.StudentMasterID "
+ " WHERE attendanceID IN (" + attdIds + ") ";
DataTable dt = site.ExecuteSelect(qry);
foreach (DataRow dr in dt.Rows)
{
mobileNos += util.CheckNull(dr["MobileF"]) + ", ";
}
return(mobileNos);
}
private void GetMarks()
{
site = new DBSite();
ExamMarksBll eBll = new ExamMarksBll();
try
{
int studentId = -1;
if (txtSearch.Text.Length > 0)
{
studentId = int.Parse(txtSearch.Text);
}
List <ExamMarksBll.ExamMarksEntity> marksList = eBll.GetExamMarks(site, int.Parse(ddlClass.SelectedValue), int.Parse(ddlSection.SelectedValue), int.Parse(ddlExam.SelectedValue), ddlSubject.SelectedValue.ToString(), studentId, isNewExamMarksEntry);
total_records = marksList.Count;
gridView1.DataSource = marksList;
gridView1.DataBind();
}
catch (Exception exception)
{
util.HandleExpception(exception, Response);
}
finally
{
site.Close();
}
}
public bool IsDuplicate(DBSite site, string value)
{
string qry = " SELECT UserInfoId FROM tblUserInfo"
+ " WHERE UserName='******'";
return(site.ExecuteSelect(qry).Rows.Count > 0);
}
public List <SubjectMasterEntity> GetMatchedRecords(DBSite site, string value_to_search)
{
List <SubjectMasterEntity> subjects = new List <SubjectMasterEntity>();
return(subjects);
}
public List <ReportCardCBSEEntity> GetReportCardCBSEOakWod_Remarks(int studentId)
{
DBSite site = new DBSite();
List <ReportCardCBSEEntity> ReportCardList = new List <ReportCardCBSEEntity>();
//DataTable dt = site.ExecuteSelect(GetCBSEQry(studentId, "Discipline"));
DataTable dt = site.ExecuteSelect(GetCBSEQry_OakWood(studentId
, "Remarks"
, "Unit Test 1"
, "Unit Test 2"
, "Note Book 1"
, "Note Book 2"
, "SEA 1"
, "SEA 2"
, "Half Yearly"
, "Annual"
, "Term I"
, "Term II"
));
ReportCardCBSEEntity reportCard;
foreach (DataRow dr in dt.Rows)
{
reportCard = new ReportCardCBSEEntity();
reportCard.StudentMasterId = studentId;
reportCard.StudentName = util.CheckNull(dr["StudentName"]);
reportCard.Subject = util.CheckNull(dr["SubjectName"]);
reportCard.HalfYearly = util.CheckNull(dr["HalfYearly"]);
reportCard.Yearly = util.CheckNull(dr["Yearly"]);
ReportCardList.Add(reportCard);
}
return(ReportCardList);
}
public List <ClassMasterBLL.ClassMasterEntity> GetTeacherClasses(DBSite site, string subuser_id)
{
List <ClassMasterBLL.ClassMasterEntity> class_list = new List <ClassMasterBLL.ClassMasterEntity>();
ClassMasterBLL.ClassMasterEntity clas = null;
string qry = " SELECT "
+ " tc.classId"
+ " FROM tblTeacherClasses tc "
+ " LEFT OUTER JOIN tblClassMaster c ON c.ClassMasterID = tc.ClassID "
+ " WHERE tc.UserId=" + Util_BLL.User.UserId
+ " AND tc.SubuserId=" + subuser_id;
DataTable class_table = site.ExecuteSelect(qry);
foreach (DataRow row in class_table.Rows)
{
clas = new ClassMasterBLL.ClassMasterEntity();
clas.ClassMasterId = util.CheckNullInt(row["ClassID"]);
class_list.Add(clas);
}
return(class_list);
}
public List <AccountParty> GetAccounts()
{
List <AccountParty> accounts = new List <AccountParty>();
AccountParty account = null;
DBSite site = new DBSite();
string qry = " SELECT AccountMasterId, AccountName"
+ " FROM tblAccountMaster "
+ " WHERE AccountName is not NULL AND UserId = " + Util_BLL.User.UserId
+ " ORDER BY AccountName";
DataTable dt = site.ExecuteSelect(qry);
foreach (DataRow row in dt.Rows)
{
account = new AccountParty();
account.AccountId = util.CheckNullInt(row["AccountMasterId"]);
account.AccountName = util.CheckNull(row["AccountName"]);
accounts.Add(account);
}
return(accounts);
}
public Get_OutGetSiteByRelationIP GetSiteByRelationIP(string data)
{
Get_OutGetSiteByRelationIP json = new Get_OutGetSiteByRelationIP();
string realIP;
Site site;
try
{
Get_InGetSiteByRelationIP input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_InGetSiteByRelationIP>(data);
SiteByRelIPOutParam outParam = new SiteByRelIPOutParam();
DBSite db = new DBSite();
site = db.GetSiteByRelationIP(input.strSrcSiteIP, input.nToSiteJob, out realIP);
json.data.siteInfo = site;
json.data.RealIP = realIP;
json.result = "0";
json.resultStr = "返回成功";
}
catch (Exception ex)
{
json.result = "1";
json.resultStr = "提交失败：" + ex.Message;
}
return(json);
}
public bool IsDulicateExam(DBSite site, ExamMasterEntity exam, bool isUpdate)
{
bool isDuplicate = true;
string qry = "";
qry += "SELECT ExamName FROM tblExamMaster ";
qry += Util_BLL.GetUserWhereCondition(Util_BLL.User);
qry += " AND ExamName ='" + exam.ExamName + "'";
//qry += " AND TermId =" + exam.TermId;
//qry += " AND MaxMarks =" + exam.MaxMarks;
DataTable dt = site.ExecuteSelect(qry);
if (isUpdate)
{
isDuplicate = dt.Rows.Count > 1;
}
else
{
isDuplicate = dt.Rows.Count > 0;
}
return(false);
//return isDuplicate;
}
public bool IsMasterBeingUsed(DBSite site, string selectedAccountType, AccountType act, int masterId)
{
string tableName = "";
string colName = AccountType.GetTypeIdName(act, selectedAccountType);
if (colName.ToUpper() == "GROUPID")
{
tableName = "tblAccountMaster";
}
else if (colName.ToUpper() == "CATEGORYID")
{
tableName = "tblProductMaster";
}
else if (colName.ToUpper() == "UOMID")
{
tableName = "tblProductMaster";
colName = "UOM";
}
else if (colName.ToUpper() == "LOCATIONID")
{
tableName = "tblProductLedger";
}
string qry = " SELECT " + colName + " FROM " + tableName + " ";
qry += Util_BLL.GetUserWhereCondition(Util_BLL.User);
qry += " AND " + colName + " = '" + masterId + "'";
DataTable dt = null;
dt = site.ExecuteSelect(qry);
return(dt.Rows.Count > 0);
}
public void SaveAttendance(DBSite site, List <AttendanceEntity> attdList)
{
string qry = "";
foreach (AttendanceEntity atd in attdList)
{
qry = " INSERT INTO tblAttendance ("
+ " YearNo, MonthNo, DayNo, HolydayID, StudentMasterID, InTime, OutTime, Status, IsPosted, IsSMSSent, UserId, SubUserId, FYear )"
+ " VALUES ( "
+ atd.YearNo
+ ", " + atd.MonthNo
+ "," + atd.DayNo
+ "," + atd.StudentId
+ ", '" + atd.InTime + "'"
+ ", '" + atd.OutTime + "'"
+ ", " + atd.Status
+ ", " + atd.IsPosted
+ ", " + atd.IsSMSSent;
qry += ", " + util.GetUserInsertQry(Util_BLL.User);
qry += " ) ";
site.Execute(qry);
}
}
//---------------- Get Query For Sale Detail -------------------------------
//protected string GetQueryForSimpleFields()
//{
// string qry = "SELECT DISTINCT";
// qry += " LedgerId, LDate, AccountName + '|' + CONVERT( VARCHAR, acc.AccountMasterId) as AccountName , ";
// qry+=" Particulars, Debit, BillNumber, ldg.SourceId, ldg.Discount ";
// qry += " FROM ( tblLedger as ldg ";
// qry+="LEFT OUTER JOIN tblAccountMaster as acc ON ldg.AccountMasterId = acc.AccountMasterId )";
// qry += " LEFT OUTER JOIN tblProductLedger as prd ON ldg.LedgerNumber = prd.LedgerNumber ";
// qry += " WHERE ldg.UserId = " + User.userID;
// qry += " AND Credit IS NOT NULL";
// return qry;
//}
//---------------- Get Query For Tax Information [ Whole Taxes ] -------------------------------
//protected string GetQueryForTaxesOnTheWhole()
//{
// string qry = " SELECT ";
// qry += " tm.TaxName + '|' + CONVERT( VARCHAR , tm.TaxId ) as TaxName , tax.TaxAmount ";
// qry += " FROM ( tblLedger as ldg ";
// qry += " LEFT OUTER JOIN tblTax as tax ON ldg.LedgerNumber = tax.LedgerNumber ) ";
// qry += " LEFT OUTER JOIN tblTaxMaster as tm ON tax.TaxMasterId = tm.TaxId ";
// qry+="WHERE tax.ProductLedgerNumber = NULL AND ldg.UserId = " +User.userID;
// return qry;
//}
//---------------- Get Query For [ Associated Product ] -----------------------------------
//protected string GetQueryForAssociatedProducts()
//{
// string qry = " SELECT ";
// qry += " ";
// return qry;
//}
public List <string> GetAccountListWithCashOrBankAsGroup(DBSite site, bool accounts_with_group_bank_only)
{
List <string> account_list = new List <string>();
string qry = " SELECT ";
qry += " AccountName " + " + ' | ' + CONVERT( VARCHAR, AccountMasterId ) as AccountName ";
qry += " FROM tblAccountMaster as acc ";
qry += " LEFT OUTER JOIN ";
qry += " tblGroup as grp ";
qry += " ON acc.GroupId = grp.GroupId ";
qry += " WHERE grp.GroupName = 'bank' ";
if (!accounts_with_group_bank_only)
{
qry += " OR grp.GroupName = 'cash' ";
}
qry += " AND acc.UserId = " + Util_BLL.User.UserId;
DataTable dt = site.ExecuteSelect(qry);
foreach (DataRow row in dt.Rows)
{
account_list.Add(util.CheckNull(row["AccountName"]));
}
return(account_list);
}
public void SaveProductMasterData(DBSite site, ProductMasterEntity pme)
{
string qry = "INSERT INTO tblProductMaster( ProductID, ProductName, OpeningBalance, ProductDate, CostPrice, SellingPrice, UOM, CategoryID";
qry += ", AccountId, LocationId, ReOrderQty ,ProductDescription, UserID, SubuserId , FYear) VALUES(";
qry += "'" + pme.ProductId + "'";
qry += ",'" + pme.ProductName + "'";
qry += ", " + pme.OpeningBalance;
qry += ", '" + pme.productDate + "'";
qry += ", " + pme.CostPrice;
qry += ", " + pme.SellingPrice;
qry += ", " + pme.UOM;
qry += ", " + pme.CategoryID;
qry += ", " + pme.AccountId;
qry += ", " + pme.LocationId;
qry += ", " + pme.ReOrderQty;
qry += ", '" + pme.ProductDescription + "'";
qry += ", " + util.GetUserInsertQry(Util_BLL.User);
//qry += ", " + Util_BLL.User.UserId;
//qry += ", " + Util_BLL.User.fYear;
qry += ")";
site.Execute(qry);
}
public List <Location> GetLocations()
{
List <Location> locations = new List <Location>();
Location location = null;
DBSite site = new DBSite();
string qry = " SELECT locationId, LocationName "
+ " FROM tblLocation "
+ " WHERE locationName is not NULL AND UserId = " + Util_BLL.User.UserId
+ " ORDER BY locationName";
DataTable dt = site.ExecuteSelect(qry);
foreach (DataRow row in dt.Rows)
{
location = new Location();
location.LocationId = util.CheckNullInt(row["LocationId"]);
location.LocationName = util.CheckNull(row["LocationName"]);
locations.Add(location);
}
return(locations);
}
public void SaveStudent(DBSite site, StudenEntity st)
{
string qry = "INSERT INTO tblStudentMaster(StudentName, AdmissionNo, ClassId, SectionID, MobileF, MobileM, DOB, Email";
qry += ", IdCardNo, FatherName, MotherName, UserID, SubuserId , FYear) VALUES(";
qry += "'" + st.StudentName + "'";
qry += ", '" + st.AdmNo + "'";
qry += ", " + st.PresentClass;
qry += ", " + st.SectionId;
qry += ", '" + st.MobileNoF + "'";
qry += ", '" + st.MobileNoM + "'";
qry += ", '" + st.DOB + "'";
qry += ", '" + st.Email + "'";
qry += ", '" + st.IdCardNo + "'";
qry += ", '" + st.FatherName + "'";
qry += ", '" + st.MotherName + "'";
qry += ", " + util.GetUserInsertQry(Util_BLL.User);
qry += ")";
site.Execute(qry);
}
public List <StudenEntity> SearchStudents(DBSite site, string student__class_names = "")
{
string ids = "";
string qry = " SELECT studentMasterID, StudentName FROM tblStudentMaster ";
qry += " WHERE UserID = " + Util_BLL.User.UserId;
qry += " AND ( ";
string[] student_arr = student__class_names.Split(',');
string where_condition = "";
foreach (string str in student_arr)
{
where_condition += " OR StudentName LIKE '" + str.Trim() + "%' ";
}
if (where_condition.Length > 3)
{
where_condition = where_condition.Substring(3, where_condition.Length - 4);
}
qry += where_condition + " )";
DataTable dt = site.ExecuteSelect(qry);
foreach (DataRow dr in dt.Rows)
{
ids += ", " + util.CheckNullInt(dr["StudentMasterId"]);
}
if (ids.Length > 2)
{
ids = ids.Substring(2, ids.Length - 2);
}
return(GetStudentsByClass(site, ids, "ALL"));
}
public void SaveAccountMasterData(DBSite site, AccountMasterEntity ame)
{
string qry = "INSERT INTO tblAccountMaster(AccountName, CreationDate, OpeningBalance, DRCR, ";
qry += " Address, City, Phone, Mobile, Email, Remarks, GroupId, UserID, SubuserId ,FYear) VALUES(";
qry += "'" + ame.AccountName + "'";
qry += ", '" + ame.CreationDate + "'";
qry += ", " + ame.OpeningBalance;
qry += ", " + ame.DRCR;
qry += ", '" + ame.Address + "'";
qry += ", '" + ame.City + "'";
qry += ", '" + ame.Phone + "'";
qry += ", '" + ame.Mobile + "'";
qry += ", '" + ame.Email + "'";
qry += ", '" + ame.Remarks + "'";
qry += ", " + ame.GroupId + ",";
qry += util.GetUserInsertQry(Util_BLL.User);
//qry += ", " + UserBLL.userID;
//qry += ", " + UserBLL.fYear;
qry += " )";
site.Execute(qry);
}
public List <SubjectMasterBLL.SubjectMasterEntity> GetTeacherSubjects(DBSite site, string subuser_id)
{
List <SubjectMasterBLL.SubjectMasterEntity> sub_list = new List <SubjectMasterBLL.SubjectMasterEntity>();
SubjectMasterBLL.SubjectMasterEntity sub = null;
string qry = " SELECT "
+ " ts.SubjectID"
+ " FROM tblTeacherSubjects ts "
+ " LEFT OUTER JOIN tblSubjectMaster s ON s.SubjectMasterID = ts.SubjectID "
+ " WHERE ts.UserId=" + Util_BLL.User.UserId
+ " AND ts.SubuserId=" + subuser_id;
DataTable dt = site.ExecuteSelect(qry);
foreach (DataRow row in dt.Rows)
{
sub = new SubjectMasterBLL.SubjectMasterEntity();
sub.SubjectMasterId = util.CheckNullInt(row["subjectId"]);
sub_list.Add(sub);
}
return(sub_list);
}
public List <SchoolClass> GetClasses()
{
List <SchoolClass> class_list = new List <SchoolClass>();
DBSite site = new DBSite();
string qry = " SELECT "
+ " ClassMasterID"
+ ", ClassName"
+ " FROM tblClassMaster "
+ " WHERE UserId=" + Util_BLL.User.UserId
+ " ORDER By ClassOrder ";
DataTable dt = site.ExecuteSelect(qry);
SchoolClass the_class;
foreach (DataRow row in dt.Rows)
{
the_class = new SchoolClass();
the_class.SchoolClassId = util.CheckNullInt(row["ClassMasterID"]);
the_class.SchoolClassName = util.CheckNull(row["ClassName"]);
class_list.Add(the_class);
}
return(class_list);
}
private void GetStudents()
{
site = new DBSite();
StudentBll stBll = new StudentBll();
string classIDs = ddlPresentClass.SelectedValue;
//try
{
// List<StudentBll.StudenEntity> students = stBll.GetStudents(site);
List <StudentBll.StudenEntity> students = stBll.GetStudentsByClass(site, "", classIDs);
//total_records = students.Count;
gridView1.DataSource = students;
gridView1.DataBind();
}
//catch (Exception exception)
//{
// util.HandleExpception(exception, Response);
//}
//finally
//{
// site.Close();
//}
}
public bool IsInFlow(DBSite site, int trnTypeId, ProductDetail pd)
{
bool IsInFlow = true;
////get Flow from transaction type
//// if Flow is with_in the check From/To
//int the_Flow = -1;
//the_Flow = GetFlow(site, trnTypeId);
//// if Flow is with_in the check From/To
//if (the_Flow == 2)
//{
// IsInFlow = (pd.Flow == 0);
//}
//else if(the_Flow == 0)
//{
// IsInFlow = true;
//}
//else if (the_Flow == 1)
//{
// IsInFlow = false ;
//}
return(IsInFlow);
}
//-------------- Edit Issuse Information --------------------------------
public void EditIssueInformation(DBSite site, SalePurchaseDetail from_product, SalePurchaseDetail to_product, string product_ledger_number)
{
string qry = " ";
qry = " UPDATE tblProductLedger SET "
+ " BillDate = '" + from_product.MovementDate + " '"
+ ", ProductId = " + from_product.productAutoId
+ ", SoldQty = " + from_product.qty
+ ", LocationId = " + from_product.locationId
+ Util_BLL.GetUserWhereCondition(Util_BLL.User);
qry += " AND ProductLedgerNumber = " + product_ledger_number
+ " AND SourceId = " + TransactionType.StockMovement
+ " AND drcr = 'C'";
site.Execute(qry);
qry = " UPDATE tblProductLedger SET "
+ " BillDate = '" + to_product.MovementDate + " '"
+ ", ProductId = " + to_product.productAutoId
+ ", BoughtQty = " + to_product.qty
+ ", LocationId = " + to_product.locationId
+ Util_BLL.GetUserWhereCondition(Util_BLL.User);
qry += " AND ProductLedgerNumber = " + product_ledger_number
+ " AND SourceId = " + TransactionType.StockMovement
+ " AND drcr = 'D'";
site.Execute(qry);
}
public List <AttendanceEntity> GetNonPostedAttendance(DBSite site)
{
List <AttendanceEntity> atdList = new List <AttendanceEntity>();
return(atdList);
}
//999
public List <ReportCardEntity> GetReportCard(int studentId)
{
DBSite site = new DBSite();
int classId = -1;
int sectionId = -1;
List <ReportCardEntity> reportCardList = new List <ReportCardEntity>();
ReportCardEntity reportCard = new ReportCardEntity();
int examId = -1;
// Unit Test 1
examId = 2;
List <ExamMarksEntity> marks_list = GetExamMarks(site, classId, sectionId, examId, "", studentId, 0);
foreach (ExamMarksEntity marks in marks_list)
{
reportCard = new ReportCardEntity();
reportCard.StudentMasterId = marks.StudentMasterId;
reportCard.StudentName = marks.StudentName;
reportCard.ClassName = marks.ClassName;
reportCard.FatherName = marks.FatherName;
reportCard.UnitTest1Subject = marks.SubjectName;
reportCard.UnitTest1MarksObtained = marks.MarksObtained;
reportCard.UnitTest1MaxMarks = marks.MaxMarks;
reportCardList.Add(reportCard);
}
return(reportCardList);
}
public SubuserBLL.SubuserEntity AuthenticateSubuser2(DBSite site, string email_id, string password)
{
SubuserBLL.SubuserEntity sub_user = null;
string qry = "SELECT "
+ " SubuserID "
+ ", SubUserName "
+ ", EmailId "
+ ", Active "
+ ", UserId "
+ " FROM tblSubuser ";
qry += " WHERE EmailId='" + email_id + "'"
+ " AND SubuserPassword='******'";
DataTable dt = site.ExecuteSelect(qry);
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
sub_user = new SubuserBLL.SubuserEntity();
sub_user.SubuserId = util.CheckNullInt(row["SubuserID"]);
sub_user.SubuserName = util.CheckNull(row["SubUserName"]);
sub_user.EmailId = util.CheckNull(row["EmailID"]);
sub_user.UserState = util.CheckNull(row["Active"]);
sub_user.UserId = util.CheckNullInt(row["UserId"]);
}
return(sub_user);
}
//----- get permissions ----------------------------------------------
public List <Permission> GetPermissions(DBSite site, string subuser_id)
{
List <Permission> permission_list = new List <Permission>();
Permission permission = null;
string qry = " SELECT "
+ " p.PermissionId"
+ ", p.Module"
+ ", p.ASPXPageName"
+ " FROM tblUserPermissions as up"
+ " LEFT OUTER JOIN tblPermission as p"
+ " ON up.PermissionId = p.PermissionId"
+ " WHERE up.UserId=" + Util_BLL.User.UserId
+ " AND SubuserId=" + subuser_id;
DataTable permission_table = site.ExecuteSelect(qry);
foreach (DataRow row in permission_table.Rows)
{
permission = new Permission();
permission.PermissionId = util.CheckNullInt(row["PermissionId"]);
permission.ModuleName = util.CheckNull(row["Module"]);
permission.ASPXPageName = util.CheckNull(row["ASPXPageName"]);
permission_list.Add(permission);
}
return(permission_list);
}
public void DeleteRecords(DBSite dbSite, string selectedAccountType, AccountType act, string typeID)
{
string qry = "DELETE FROM " + AccountType.GetTableName(act, selectedAccountType);
qry += " WHERE " + AccountType.GetTypeIdName(act, selectedAccountType) + " IN ( " + typeID + ")";
dbSite.Execute(qry);
}
public Test(int _maxServicesCount, int _operationsCount)
{
operationsCount = _operationsCount;
maxServicesCount = _maxServicesCount;
DBSite dbSite = new DBSite("http://wsstest");
DBWeb dbWeb = dbSite.GetWeb("/dms/requests");
objectList = dbWeb.GetList("AccountingObjects");
dbWeb = dbSite.GetWeb("/");
users = dbWeb.GetList("Users");
}
public WSSList()
{
dbSite = new DBSite("http://wsstest");
DBWeb dbWeb = dbSite.GetWeb("/dms/requests");
dbList = dbWeb.GetList("AccountingObjects");
}
public string GetData(int value)
{
DBSite dbSite = new DBSite("http://wsstest/");
return string.Format("You entered: {0}", value);
}
