Exemple #1
0
        public DataSet GetIdentityRightList()
        {
            var sqlParam = new MySqlSpParam();

            sqlParam.StoreProcedureName  = AppConstants.StoreProcedure.spIdentityRight_Get;
            sqlParam.StoreProcedureParam = null;
            var ds = DataAccessHelper.ExecuteQuery(sqlParam.ToSqlCommand());

            return(ds);
        }
Exemple #2
0
        public void UpdateIdentityGroupRight(string XmlString)
        {
            var sqlparam = new MySqlSpParam();

            sqlparam.StoreProcedureName  = AppConstants.StoreProcedure.spIdentityGroupRight_BulkUpdate;
            sqlparam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@xmltext", XmlString)
            };
            DataAccessHelper.ExecuteNonQuery(sqlparam.ToSqlCommand(),
                                             sqlparam.StoreProcedureParam);
        }
Exemple #3
0
        public void MarkGroupInvalid(int GroupId)
        {
            var sqlparam = new MySqlSpParam();

            sqlparam.StoreProcedureName  = AppConstants.StoreProcedure.spIdentityGroup_MarkInvalid;
            sqlparam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@groupId", GroupId)
            };
            DataAccessHelper.ExecuteNonQuery(sqlparam.ToSqlCommand(),
                                             sqlparam.StoreProcedureParam);
        }
Exemple #4
0
        public void MarkMasterSkillInvalid(int masterSkillId)
        {
            var sqlParam = new MySqlSpParam();

            sqlParam.StoreProcedureName  = AppConstants.StoreProcedure.spMasterSkill_MarkInvalid;
            sqlParam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@MasterSkillId", masterSkillId)
            };
            DataAccessHelper.ExecuteNonQuery(sqlParam.ToSqlCommand(),
                                             sqlParam.StoreProcedureParam);
        }
        public DataSet GetEmployeeDetails(string emailId)
        {
            var sqlParam = new MySqlSpParam();

            sqlParam.StoreProcedureName  = AppConstants.StoreProcedure.spEmployee_GetByEmailId;
            sqlParam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@EmailId", emailId)
            };
            var ds = DataAccessHelper.ExecuteQuery(sqlParam.ToSqlCommand(), sqlParam.StoreProcedureParam);

            return(ds);
        }
Exemple #6
0
        public DataSet GetIdentityGroupRights(int groupId)
        {
            var sqlParam = new MySqlSpParam();

            sqlParam.StoreProcedureName  = AppConstants.StoreProcedure.spIdentityGroupRight_Get;
            sqlParam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@GroupId", groupId)
            };
            var ds = DataAccessHelper.ExecuteQuery(sqlParam.ToSqlCommand(), sqlParam.StoreProcedureParam);

            return(ds);
        }
Exemple #7
0
        public DataSet GetMasterSkill(int masterSkillId)
        {
            var sqlParam = new MySqlSpParam();

            sqlParam.StoreProcedureName  = AppConstants.StoreProcedure.spMasterSkill_Get;
            sqlParam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@MasterSkillId", masterSkillId)
            };
            var ds = DataAccessHelper.ExecuteQuery(sqlParam.ToSqlCommand(), sqlParam.StoreProcedureParam);

            return(ds);
        }
Exemple #8
0
        public void InsertMasterSkill(MasterSkill masterSkill)
        {
            var sqlParam = new MySqlSpParam();

            sqlParam.StoreProcedureName  = AppConstants.StoreProcedure.spMasterSkill_Insert;
            sqlParam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@skill", masterSkill.Skill),
                new MySqlParameter("@isValid", masterSkill.IsValid),
                new MySqlParameter("@createdBy", masterSkill.CreatedBy),
                new MySqlParameter("@createdOn", masterSkill.CreatedOn)
            };
            DataAccessHelper.ExecuteNonQuery(sqlParam.ToSqlCommand(),
                                             sqlParam.StoreProcedureParam);
        }
Exemple #9
0
        public void InsertMasterOrganizationRole(MasterOrganizationRole masterOrganizationRole)
        {
            var sqlParam = new MySqlSpParam();

            sqlParam.StoreProcedureName  = AppConstants.StoreProcedure.spMasterOrganizationRole_Insert;
            sqlParam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@role", masterOrganizationRole.Role),
                new MySqlParameter("@isValid", masterOrganizationRole.IsValid),
                new MySqlParameter("@createdBy", masterOrganizationRole.CreatedBy),
                new MySqlParameter("@createdOn", masterOrganizationRole.CreatedOn)
            };
            DataAccessHelper.ExecuteNonQuery(sqlParam.ToSqlCommand(),
                                             sqlParam.StoreProcedureParam);
        }
Exemple #10
0
        public void UpdateMasterSkill(MasterSkill masterSkill)
        {
            var sqlparam = new MySqlSpParam();

            sqlparam.StoreProcedureName  = AppConstants.StoreProcedure.spMasterSkill_Update;
            sqlparam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@masterSkillId", masterSkill.Id),
                new MySqlParameter("@skill", masterSkill.Skill),
                new MySqlParameter("@isValid", masterSkill.IsValid),
                new MySqlParameter("@updatedby", masterSkill.UpdatedBy),
                new MySqlParameter("@updatedon", masterSkill.UpdatedOn)
            };
            DataAccessHelper.ExecuteNonQuery(sqlparam.ToSqlCommand(),
                                             sqlparam.StoreProcedureParam);
        }
        public void InsertMasterDepartment(MasterDepartment masterDepartment)
        {
            var sqlParam = new MySqlSpParam();

            sqlParam.StoreProcedureName  = AppConstants.StoreProcedure.spMasterDepartment_Insert;
            sqlParam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@departmentName", masterDepartment.DepartmentName),
                new MySqlParameter("@departmentHead", masterDepartment.DepartmentHead),
                new MySqlParameter("@isValid", masterDepartment.IsValid),
                new MySqlParameter("@createdBy", masterDepartment.CreatedBy),
                new MySqlParameter("@createdOn", masterDepartment.CreatedOn)
            };
            DataAccessHelper.ExecuteNonQuery(sqlParam.ToSqlCommand(),
                                             sqlParam.StoreProcedureParam);
        }
Exemple #12
0
        public void UpdateIdentityGroup(IdentityGroup ObjIdentityGroup)
        {
            var sqlparam = new MySqlSpParam();

            sqlparam.StoreProcedureName  = AppConstants.StoreProcedure.spIdentityGroup_Update;
            sqlparam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@GroupId", ObjIdentityGroup.Id),
                new MySqlParameter("@grpn", ObjIdentityGroup.GroupName),
                new MySqlParameter("@groupdesc", ObjIdentityGroup.GroupDescription),
                new MySqlParameter("@valid", ObjIdentityGroup.IsValid),
                new MySqlParameter("@updatedby", ObjIdentityGroup.UpdatedBy),
                new MySqlParameter("@updatedon", ObjIdentityGroup.UpdatedOn)
            };
            DataAccessHelper.ExecuteNonQuery(sqlparam.ToSqlCommand(),
                                             sqlparam.StoreProcedureParam);
        }
Exemple #13
0
        public DataSet GetIdentityGroupList(SearchParam searchParam)
        {
            var recordFrom = searchParam.Page * searchParam.Show;
            var show       = searchParam.Show;

            var sqlParam = new MySqlSpParam();

            sqlParam.StoreProcedureName  = AppConstants.StoreProcedure.spIdentityGroup_GetList;
            sqlParam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@FilterText", searchParam.FilterText),
                new MySqlParameter("@RecordFrom", recordFrom),
                new MySqlParameter("@RecordTill", show)
            };
            var ds = DataAccessHelper.ExecuteQuery(sqlParam.ToSqlCommand(), sqlParam.StoreProcedureParam);

            return(ds);
        }
Exemple #14
0
        public DataSet InsertIdentityGroup(IdentityGroup ObjIdentityGroup)
        {
            var sqlparam = new MySqlSpParam();

            sqlparam.StoreProcedureName  = AppConstants.StoreProcedure.spIdentityGroup_Insert;
            sqlparam.StoreProcedureParam = new MySqlParameter[] {
                new MySqlParameter("@groupName", ObjIdentityGroup.GroupName),
                new MySqlParameter("@groupDesc", ObjIdentityGroup.GroupDescription),
                new MySqlParameter("@isValid", ObjIdentityGroup.IsValid),
                new MySqlParameter("@createdBy", ObjIdentityGroup.CreatedBy),
                new MySqlParameter("@createdOn", ObjIdentityGroup.CreatedOn)
            };
            var ds = DataAccessHelper.ExecuteQuery(sqlparam.ToSqlCommand(),
                                                   sqlparam.StoreProcedureParam);

            return(ds);
        }