//Added on 2nd Nov for Search File Name and Description
public DataSet SearchFiles(clsFileUpload objFileUpload)
{
objDataAccess = new DataAccess();
Object[] parameters = new Object[4] {
objFileUpload.Pol_PolicyID, objFileUpload.Pol_PolicyVerID, objFileUpload.Attach_DisplayFileName, objFileUpload.Attach_FileDesc
};
return(objDataAccess.LoadDataSet(parameters, "P_Get_SeacrhFileDescription", "TM_Get_SeacrhFileDescription"));
}
public DataSet GetFileAttachDetails(clsFileUpload objFileUpload)
{
objDataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objFileUpload.Attach_ID, objFileUpload.Attach_For, objFileUpload.Attach_EntityID
};
return(objDataAccess.LoadDataSet(parameters, "P_GetFileAttachDetails", "TM_Attachment_List"));
}
//Added By Rituraj for binding gridin file attachment
public DataSet GetFiles(clsFileUpload objFileUpload)
{
objDataAccess = new DataAccess();
Object[] parameters = new Object[2] {
objFileUpload.Pol_PolicyID, objFileUpload.Pol_PolicyVerID
};
return(objDataAccess.LoadDataSet(parameters, "P_GetFiles", "TM_Attachment_List"));
}
public DataSet InsertUpdateDeleteFileUpload(clsFileUpload objFileUpload)
{
objDataAccess = new DataAccess();
//Object[] parameters = new Object[15] {objFileUpload.Attach_ID, objFileUpload.Attach_Location,objFileUpload.Attach_DisplayFileName,objFileUpload.Attach_FileDesc,objFileUpload.Attach_For,objFileUpload.Attach_EntityID,objFileUpload.Pol_ClientID,objFileUpload.Pol_PolicyID,objFileUpload.Pol_PolicyVerID, objFileUpload.File_Type,objFileUpload.CreatedBy,objFileUpload.CreateDate,objFileUpload.ModifiedBy,objFileUpload.ModifiedDate };
Object[] parameters = new Object[13] {
objFileUpload.Attach_ID, objFileUpload.Attach_Location, objFileUpload.Attach_InternalFileName, objFileUpload.Attach_DisplayFileName, objFileUpload.Attach_FileDesc, objFileUpload.Attach_For, objFileUpload.Attach_EntityID, objFileUpload.Pol_ClientID, objFileUpload.Pol_PolicyID, objFileUpload.Pol_PolicyVerID, objFileUpload.File_Type, objFileUpload.CreatedBy, objFileUpload.Mode
};
return(objDataAccess.LoadDataSet(parameters, "P_FileAttachDetails_InsertUpdateDelete", "TM_Attachment_List"));
}