Example #1
0
 public override int Delete(long ID)
 {
     SqlParameterCollection prms = new SqlCommand().Parameters;
     prms.AddWithValue("@ID", ID);
     prms.AddWithValue("@controlID", mArchiveControl.ID);
     return squtil.ExecuteNoResultSetSQLQuery(deleteSql, prms);
 }
        static public void AddUserAndRoles(string newStaffUserName)
        {
            var environmentParametersViewModel = new Thinkgate.Domain.Classes.EnvironmentParametersFactory(AppSettings.ConnectionStringName).GetEnvironmentParameters();
            var clientId = environmentParametersViewModel.ClientId;
            var kenticoEnabled = environmentParametersViewModel.IsKenticoEnabledSite;

            if (kenticoEnabled)
            {
                SqlParameterCollection parmsUersInRoles = new SqlCommand().Parameters;
                parmsUersInRoles.AddWithValue("ApplicationName", AppSettings.ApplicationName);
                parmsUersInRoles.AddWithValue("UserName", newStaffUserName);

                var findRolesForUser = ThinkgateDataAccess.FetchDataTable(AppSettings.ConnectionString,
                                                                     Thinkgate.Base.Classes.Data.StoredProcedures.ASPNET_USERS_IN_ROLES_GET_ROLES_FOR_USER,
                                                                     System.Data.CommandType.StoredProcedure,
                                                                     parmsUersInRoles);

                var roleservice = new RoleServiceProxy();
                var nameCalculator = new Thinkgate.Domain.Classes.KenticoNameCalculator();

                for (int i = 0; i < findRolesForUser.Rows.Count; i++)
                {
                    string newStaffRoleName = findRolesForUser.Rows[i]["RoleName"].ToString();
                    var kenticoUserName = nameCalculator.CalculateUserName(clientId, newStaffUserName);
                    var kenticoRoleName = nameCalculator.CalculateSystemGroupName(clientId, AdminUserName, newStaffRoleName);
                    var roleuser = new RoleUser();
                    roleuser.UserName = kenticoUserName;
                    roleservice.AddUsersToRole(kenticoRoleName, EnumerableExtensions.SingleItemAsEnumerable<RoleUser>(roleuser));
                }
            }
        }
Example #3
0
        public override byte[] Read(long ID)
        {
            SqlParameterCollection prms = new SqlCommand().Parameters;

            prms.AddWithValue("@ID", ID);
            prms.AddWithValue("@controlID", mArchiveControl.ID);
            return (byte[])squtil.ExecuteScalarResultSetSQLQuery(selectSql, prms);
        }
Example #4
0
            public int InsertData2()
            {
                var arrayOfParameter = new SqlCommand().Parameters;
                arrayOfParameter.AddWithValue("@rollno", _rollNo);
                arrayOfParameter.AddWithValue("@name", _name);
                arrayOfParameter.AddWithValue("@department", _department);
                arrayOfParameter.AddWithValue("@section", _section);

                return this.ModifyDataStoredProcedure(@"USP_StudentDetailsProc4", arrayOfParameter);
            }
Example #5
0
            public int WithReturn3()
            {
                var arrayOfParameter = new SqlCommand().Parameters;
                arrayOfParameter.AddWithValue("@rico", _rico);

                return this.ModifyDataStoredProcedureWithReturn(@"USP_StudentDetailsProc6", arrayOfParameter);
            }
Example #6
0
 public DataTable getLoginTeams()
 {
     DataTable dt = new DataTable();
         var oParam = new SqlCommand().Parameters;
         oParam.AddWithValue("@workdayid", _workdayid);
         return dt = _dbi.FGetDataTable(@"EmployeeGetTeams", oParam);
 }
Example #7
0
            public DataTable GetAllDetailsByName()
            {
                var arrayOfParameter = new SqlCommand().Parameters;
                arrayOfParameter.AddWithValue("@name", _name);

                return this.GetDataStoredProcedure(@"USP_StudentDetailsProc2", arrayOfParameter );
            }
Example #8
0
 public DataSet getLoginDetails(string lanid)
 {
     DataSet ds = new DataSet();
         lanid = lanid.Remove(0, lanid.IndexOf('\\') + 1);
         var oParam = new SqlCommand().Parameters;
         oParam.AddWithValue("@lanid", lanid);
         return ds = _dbi.FGetDataSet(@"EmployeeDetailsDisplay", oParam);
 }
Example #9
0
        public override Dictionary<string, object> ReadHash(long ID)
        {
            //cant use GT cause GT calls archive to read data and that would create a recursive loop
            SqlParameterCollection prms = new SqlCommand().Parameters;
            prms.AddWithValue("@id", ID);
            DataTable dt = squtil.ExecuteSingleResultSetSQLQuery(String.Format("select * from {0} where {1} = @id", dbTable, mArchiveControl.cfg.IDColumn), prms);
            if (dt.Rows.Count == 0)
                return null;

            GenericTable gt = new GenericTable(squtil, dbTable, mArchiveControl.cfg.IDColumn);
            gt.Load(dt.Rows[0]);
            //this was not archived - it was just put there so we have the ability to archive that data
            if (this.mArchiveControl.ArchiveType == ArchiveControl.ArchiveTypeEnum.Column)
                gt.Data.Remove(mArchiveControl.cfg.AgeDeterminingColumn);
            return gt.Data;
        }
Example #10
0
 public DataTable displayKhronosLogs(int x)
 {
     DataTable dt = new DataTable();
     var oParam = new SqlCommand().Parameters;
     //oParam.AddWithValue("@teamid", _teamid);
     oParam.AddWithValue("@workdayid", _employeeid);
     //oParam.AddWithValue("@month", _month);
     oParam.AddWithValue("@monthyear", _monthYear);
     //oParam.AddWithValue("@year", _year);
     if (x == 1)
     {
         //return dt = this.FGetDataTable(@"KhronosTeamLogsBMDisplay", oParam);
         return dt = this.FGetDataTable(@"GetEmployeeLogs", oParam);
     }
     else
     {
         return dt = this.FGetDataTable(@"KhronosEmployeeTardiness", oParam);
         //return dt = this.FGetDataTable(@"KhronosTeamLogsDLDisplay", oParam);
     }
 }
Example #11
0
 public string cancelShift()
 {
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@shiftempid", _shiftempid);
     this.FExecuteQuery("EmployeeShiftCancel", oParam);
     return "done";
 }
Example #12
0
 public string cancelLeaves()
 {
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@leaveid", _leaveid);
     oParam.AddWithValue("@workdayid", _employeeid);
     this.FExecuteQuery(@"KhronosEmployeeLeaveCancel", oParam);
     return "done";
 }
Example #13
0
        public string InsertForecast()
        {
            string msg;
            var oParam = new SqlCommand().Parameters;
            oParam.AddWithValue("@teamid", _teamid);
            oParam.AddWithValue("@position", _position);
            oParam.AddWithValue("@year", _year);
            oParam.AddWithValue("@month", _month);
            oParam.AddWithValue("@teamname", _teamname);
            //oParam.AddWithValue("@count", _count);
            try
            {
                this.ExecuteInsert(@"HCInsertForecast", oParam);
                msg = "Saved!";
            }
            catch (Exception ex)
            {
                msg = ex.ToString();
            }

            return msg;
        }
Example #14
0
 public string insertLeaves()
 {
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@teamempid", _teamempid);
     oParam.AddWithValue("@leavetype", _leavetype);
     oParam.AddWithValue("@leavedate", _leavedate);
     oParam.AddWithValue("@leavevolume", _leavevolume);
     oParam.AddWithValue("@leavereason", _leavereason);
     oParam.AddWithValue("@workdayid", _employeeid);
     this.ExecuteInsert(@"KhronosEmployeeLeavesInsert", oParam);
     return "done";
 }
Example #15
0
 public DataTable getEmployeeShift()
 {
     DataTable dt = new DataTable();
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@teamempid", _teamempid);
     oParam.AddWithValue("@shiftstartdate", _shiftstartdate);
     oParam.AddWithValue("@shiftenddate", _shiftenddate);
     return dt = this.FGetDataTable(@"EmployeeShiftGet", oParam);
 }
Example #16
0
 public DataTable getEmployeeAIQualify()
 {
     DataTable dt = new DataTable();
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@wdid", _employeeid);
     oParam.AddWithValue("@monthyear1", _monthyear);
     oParam.AddWithValue("@teamid", _teamid);
     return dt = this.FGetDataTable(@"KhronosTeamAIQualification", oParam);
 }
Example #17
0
 public DataTable displayTemp()
 {
     DataTable dt = new DataTable();
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@teamid", _teamid);
     return dt = this.FGetDataTable("TmpQryChippy", oParam);
 }
Example #18
0
 public DataTable displayEmployeeShift()
 {
     DataTable dt = new DataTable();
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@teamempid", _teamempid);
     return dt = this.FGetDataTable("EmployeeShiftGetShift", oParam);
 }
Example #19
0
 public DataSet displayTeamStaff()
 {
     DataSet ds = new DataSet();
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@teamid", _teamid);
     return ds = this.FGetDataSet("TeamStaffDisplay", oParam);
 }
Example #20
0
        public string UpdateQuizbeeStatusI()
        {
            string msg;
            var oParam = new SqlCommand().Parameters;
            oParam.AddWithValue("@questionid", _questionid);
            try
            {
                this.ExecuteInsert(@"TBUpdateQuizbeeStatusI", oParam);
                msg = "Saved!";
            }
            catch (Exception ex)
            {
                msg = ex.ToString();
            }

            return msg;
        }
Example #21
0
 public DataTable getAIExport()
 {
     DataTable dt = new DataTable();
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@monthyear1", _monthyear);
     oParam.AddWithValue("@teamid", _teamid);
     return dt = this.FGetDataTable(@"ExportAIQualify", oParam);
 }
Example #22
0
        public string UpdateUserSBStatus()
        {
            string msg;
            var oParam = new SqlCommand().Parameters;
            oParam.AddWithValue("@eid", _eid);
            try
            {
                this.ExecuteInsert(@"SBCheckUserSBStatus", oParam);
                msg = "Saved!";
            }
            catch (Exception ex)
            {
                msg = ex.ToString();
            }

            return msg;
        }
Example #23
0
 public DataTable getEmployeeLeaves()
 {
     DataTable dt = new DataTable();
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@teamid", _teamid);
     oParam.AddWithValue("@leavedate", _leavedate);
     return dt = this.FGetDataTable(@"KhronosEmployeeLeavesDisplay", oParam);
 }
        /// <summary>
        /// Get Standard Levels By StandardList Data 
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static DataTable GetStandardLevelbyStandardList(Thinkgate.Base.DataAccess.dtGeneric_Int ids,string StandardSet, int WorksheetId)
        {
            SqlParameterCollection parms = new SqlCommand().Parameters;
            SqlParameter idCollections = new SqlParameter("StandardIds", SqlDbType.Structured);
            idCollections.TypeName = "dbo.Generic_Int";
            idCollections.Value = ids;
            parms.Add(idCollections);
            parms.AddWithValue("StandardSet", StandardSet);
            parms.AddWithValue("WorksheetId", WorksheetId);

            DataTable dt = ThinkgateDataAccess.FetchDataTable(AppSettings.ConnectionString, StoredProcedures.E3_GET_STANDARDLEVEL_BY_STANDARDLIST, CommandType.StoredProcedure, parms);
            return dt;
        }
Example #25
0
 public DataTable getEmployeeTardiness()
 {
     DataTable dt = new DataTable();
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@workdayid", _employeeid);
     oParam.AddWithValue("@monthyear", _monthyear);
     return dt = this.FGetDataTable(@"KhronosEmployeeTardiness", oParam);
 }
Example #26
0
        public static E3InterventionDataObject getE3InterventionData(int userpage, bool usercrosscourses, int schoolid, string grade, string subject, int studentid, string type, string tier = "")
        {

            SqlParameterCollection sqlParms = new SqlCommand().Parameters;
            sqlParms.AddWithValue("@UserPage", userpage);
            sqlParms.AddWithValue("@UserCrossCourses", usercrosscourses);
            sqlParms.AddWithValue("@SchoolID", schoolid);
            sqlParms.AddWithValue("@Grade", grade);
            sqlParms.AddWithValue("@Subject", subject);
            sqlParms.AddWithValue("@StudentID", studentid);
            sqlParms.AddWithValue("@Type", type);
            sqlParms.AddWithValue("@Tier", tier);

            DataSet ds = Thinkgate.Base.DataAccess.ThinkgateDataAccess.FetchDataSet(AppSettings.ConnectionString,
                                                                        Thinkgate.Base.Classes.Data.StoredProcedures.E3_INTERVENTIONS_SELECT,
                                                                        CommandType.StoredProcedure,
                                                                        sqlParms);

            //Build MTSS Objects
            E3InterventionDataObject obj = new E3InterventionDataObject();
            obj.InterventionsObject = (List<E3MTSSInterventions>)ds.Tables[0].ToList<E3MTSSInterventions>();
            obj.StudentsObject = (List<E3MTSSInterventionStudents>)ds.Tables[1].ToList<E3MTSSInterventionStudents>();


            return obj;

        }
Example #27
0
 public string insertNewShift()
 {
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@teamempid", _teamempid);
     oParam.AddWithValue("@shiftid", _shiftid);
     oParam.AddWithValue("@dayshiftid", _dayshiftid);
     oParam.AddWithValue("@shiftstartdate", _shiftstartdate);
     oParam.AddWithValue("@shiftenddate", _shiftenddate);
     oParam.AddWithValue("@employeeid", _employeeid);
     oParam.AddWithValue("@customstart", _customstart);
     oParam.AddWithValue("@customend", _customend);
     this.ExecuteInsert(@"EmployeeShiftInsert3", oParam);
     return "done";
 }
Example #28
0
        public static DataTable getE3InterventionStudents(int userpage, bool usercrosscourses, int schoolid, string grade, string subject, string type, string tier = "")
        {
            SqlParameterCollection sqlParms = new SqlCommand().Parameters;
            sqlParms.AddWithValue("@UserPage", userpage);
            sqlParms.AddWithValue("@UserCrossCourses", usercrosscourses);
            sqlParms.AddWithValue("@SchoolID", schoolid);
            sqlParms.AddWithValue("@Grade", grade);
            sqlParms.AddWithValue("@Subject", subject);
            sqlParms.AddWithValue("@Type", type);
            sqlParms.AddWithValue("@Tier", tier);

            DataTable dt = Thinkgate.Base.DataAccess.ThinkgateDataAccess.FetchDataTable(AppSettings.ConnectionString,
                                                                        Thinkgate.Base.Classes.Data.StoredProcedures.E3_STUDENTS_SELECT_IN_RTI,
                                                                        CommandType.StoredProcedure,
                                                                        sqlParms);
            return dt;


        }
Example #29
0
 public DataTable DisplayHeadcount()
 {
     DataTable dt = new DataTable();
     var oParam = new SqlCommand().Parameters;
     oParam.AddWithValue("@teamid", _teamid);
     oParam.AddWithValue("@year", _year);
     return dt = this.FGetDataTable(@"HCDisplayHeadcount", oParam);
 }
Example #30
0
        public static List<E3Student> getE3StudentNames(List<KenticoMTSSFormData> studentList)
        {
            //Convert to DataTable for SP
            DataTable dt = new DataTable();
            DataColumn dc = new DataColumn("StudentID");
            dt.Columns.Add(dc);

            foreach (var stid in studentList)
            {
                dt.Rows.Add(stid.StudentID.ToString());
            }

            //Call SP with DataTable list
            SqlParameterCollection sqlParms = new SqlCommand().Parameters;
            sqlParms.AddWithValue("@StudentIds", dt);

            DataTable rs = Thinkgate.Base.DataAccess.ThinkgateDataAccess.FetchDataTable(AppSettings.ConnectionString,
                                                                        Thinkgate.Base.Classes.Data.StoredProcedures.E3_STUDENTS_BY_STUDENT_ID,
                                                                        CommandType.StoredProcedure,
                                                                        sqlParms);
            //Convert to List using extension method (columns must match property names)
            List<E3Student> ls = (List<E3Student>)rs.ToList<E3Student>();
            return ls;

        }