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")); }