public DataSet GetIdentityRightList()
{
var sqlParam = new MySqlSpParam();
sqlParam.StoreProcedureName = AppConstants.StoreProcedure.spIdentityRight_Get;
sqlParam.StoreProcedureParam = null;
var ds = DataAccessHelper.ExecuteQuery(sqlParam.ToSqlCommand());
return(ds);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}