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