public DataSet GetAll(clsSubGroupMaster objSubGroup) { dataAccess = new DataAccess(); Object[] parameters = new Object[7] { objSubGroup.SubGroupId, objSubGroup.SOBId, objSubGroup.SCodeId, objSubGroup.SSCode1Id, objSubGroup.SSCode2Id, objSubGroup.SCId, objSubGroup.GroupId }; //Object[] parameters = new Object[3] { objSOB.SOBId, objSOB.SOBName, objSOB.Status }; return(dataAccess.LoadDataSet(parameters, "P_SubGroupMaster_Select", "SubGroupMasterList")); }
public DataSet getSubGroupData(clsSubGroupMaster objSubGroup) { dataAccess = new DataAccess(); Object[] parameters = new Object[1] { objSubGroup.GroupId }; //Object[] parameters = new Object[3] { objSOB.SOBId, objSOB.SOBName, objSOB.Status }; return(dataAccess.LoadDataSet(parameters, "P_GetSubGroupById", "SubGroupById")); //return dataAccess.GetDataReader(parameters, "P_GetSubGroupById"); }
public SqlDataReader getSubGroup(clsSubGroupMaster objSubGroup) { dataAccess = new DataAccess(); Object[] parameters = new Object[1] { objSubGroup.GroupId }; //Object[] parameters = new Object[3] { objSOB.SOBId, objSOB.SOBName, objSOB.Status }; //return dataAccess.LoadDataSet(parameters, "P_GetSourceCodeBySOB", "MasterSourceCodeBySOB"); return(dataAccess.GetDataReader(parameters, "P_GetSubGroupById")); }
public DataSet SaveSubGroup(clsSubGroupMaster objSubGroup) { dataAccess = new DataAccess(); Object[] parameters = new Object[] { objSubGroup.SubGroupId, objSubGroup.SubGroupCode, objSubGroup.SubGroupName, objSubGroup.AnalysisCategory, objSubGroup.BusinessType, objSubGroup.SSCode1Id, objSubGroup.SSCode2Id, objSubGroup.SOBId, objSubGroup.SCodeId, objSubGroup.SCId, objSubGroup.GroupId, objSubGroup.EffFromDate, objSubGroup.EffToDate, //objSOB.Status, objSubGroup.LoginUserId, objSubGroup.PageMethod }; return(dataAccess.LoadDataSet(parameters, "P_SubGroupMaster_InsertUpdate", "SubGroupMaster")); }