public List <ServiceContactDetailModel> GetServiceContactDetail(ServiceContactDetailModel model) { List <ServiceContactDetailModel> lstServiceContactDetail = new List <ServiceContactDetailModel>(); SqlParameter[] param = { new SqlParameter("@Type", model.Type), new SqlParameter("@ID", model.Id) }; DataSet dsResult = SqlHelper.ExecuteDataset(System.Data.CommandType.StoredProcedure, "USP_ServicesContactDetail", param); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { lstServiceContactDetail = DataTableMappingtoModel.MappingToEntity <ServiceContactDetailModel>(dsResult.Tables[0]); } return(lstServiceContactDetail); }
public List <DocumentModel> GetDocument(DocumentModel Documentmdl) { List <DocumentModel> lstDocument = new List <DocumentModel>(); SqlParameter[] param = { new SqlParameter("@Type", Documentmdl.Type), new SqlParameter("@ID", Documentmdl.ID), new SqlParameter("@PageIdentification", Documentmdl.PageIdentification) }; DataSet dsResult = SqlHelper.ExecuteDataset(System.Data.CommandType.StoredProcedure, "usp_SaveDocument", param); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { lstDocument = DataTableMappingtoModel.MappingToEntity <DocumentModel>(dsResult.Tables[0]); } return(lstDocument); }