public DataSet getGroupList(clsGroupMaster objGroup)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[6] {
objGroup.GroupId, objGroup.SOBId, objGroup.SCodeId, objGroup.SSCode1Id, objGroup.SSCode2Id, objGroup.SCId
};
//Object[] parameters = new Object[3] { objSOB.SOBId, objSOB.SOBName, objSOB.Status };
return(dataAccess.LoadDataSet(parameters, "P_GroupMaster_Select", "GroupMasterList"));
}
public DataSet getGroupData(clsGroupMaster objGroup)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[1] {
objGroup.SCId
};
//Object[] parameters = new Object[3] { objSOB.SOBId, objSOB.SOBName, objSOB.Status };
return(dataAccess.LoadDataSet(parameters, "P_GetGroupById", "GroupById"));
//return dataAccess.GetDataReader(parameters, "P_GetGroupById");
}
public SqlDataReader getGroup(clsGroupMaster objGroup)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[1] {
objGroup.SCId
};
//Object[] parameters = new Object[3] { objSOB.SOBId, objSOB.SOBName, objSOB.Status };
//return dataAccess.LoadDataSet(parameters, "P_GetSourceCodeBySOB", "MasterSourceCodeBySOB");
return(dataAccess.GetDataReader(parameters, "P_GetGroupById"));
}
public DataSet SaveGroup(clsGroupMaster objGroup)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] { objGroup.GroupId,
objGroup.GroupCode,
objGroup.GroupName,
objGroup.AnalysisCategory,
objGroup.BusinessType,
objGroup.SSCode1Id,
objGroup.SSCode2Id,
objGroup.SOBId,
objGroup.SCodeId,
objGroup.SCId,
objGroup.EffFromDate,
objGroup.EffToDate,
//objSOB.Status,
objGroup.LoginUserId,
objGroup.PageMethod };
return(dataAccess.LoadDataSet(parameters, "P_GroupMaster_InsertUpdate", "GroupMaster"));
}
