public DataSet MyTempletes(UserMyDocument objUserMyDocument)
{
SqlParameter[] param =
{
new SqlParameter("@SearchType", objUserMyDocument.SearchType)
, new SqlParameter("@FolderID", objUserMyDocument.FolderId)
, new SqlParameter("@UserId", objUserMyDocument.UserId)
, new SqlParameter("@DocumentText", objUserMyDocument.FilterDocumentTitle)
, new SqlParameter("CurrentPage", objUserMyDocument.CurrentPage)
, new SqlParameter("PageSize", objUserMyDocument.PageSize)
, new SqlParameter("SortBy", objUserMyDocument.SortBy)
, new SqlParameter("SortOrder", objUserMyDocument.SortOrder)
};
//Call SPGETCATEGORYBYID stored procedure which will return dataset
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.User_SharedMyDocument, param);
//if dataset is not null and tables count is greater than 0 than return dataset else return null
if (ds != null && ds.Tables.Count > 0)
{
return(ds);
}
return(null);
}
public UserMyDocument MyDocument(UserMyDocument objUserMyDocument)
{
return(objBusUserLogin.MyDocument(objUserMyDocument));
}
public UserMyDocument MyTempletes(UserMyDocument objUserMyDocument)
{
return(objBusUserLogin.MyTempletes(objUserMyDocument));
}
public UserMyDocument MyTempletes(UserMyDocument objUserSummaryModel)
{
//UserMyDocument objUserSummaryModel = new UserMyDocument();
int PageSize = objUserSummaryModel.PageSize;
int CurrentPage = objUserSummaryModel.CurrentPage;
string SortBy = objUserSummaryModel.SortBy;
int SortOrder = objUserSummaryModel.SortOrder;
DataSet dtSummaryModel = objDLUserLogin.MyTempletes(objUserSummaryModel);
if (dtSummaryModel != null && dtSummaryModel.Tables.Count > 0)
{
objUserSummaryModel = GetDataRowToEntity <UserMyDocument>(dtSummaryModel.Tables[0].Rows[0]);
if (dtSummaryModel != null && dtSummaryModel.Tables.Count > 1)
{
objUserSummaryModel.objListFolderModel = new List <FolderModel>();
//fetch each row of datable
foreach (DataRow dr in dtSummaryModel.Tables[1].Rows)
{
objUserSummaryModel.objListFolderModel.Add(GetDataRowToEntity <FolderModel>(dr));
}
}
if (dtSummaryModel != null && dtSummaryModel.Tables.Count > 2)
{
objUserSummaryModel.objListDocumentModel = new List <DocumentModel>();
//fetch each row of datable
foreach (DataRow dr in dtSummaryModel.Tables[2].Rows)
{
objUserSummaryModel.objListDocumentModel.Add(GetDataRowToEntity <DocumentModel>(dr));
}
}
objUserSummaryModel.PageSize = PageSize;
objUserSummaryModel.CurrentPage = CurrentPage;
objUserSummaryModel.SortBy = SortBy;
objUserSummaryModel.SortOrder = SortOrder;
if (objUserSummaryModel != null && objUserSummaryModel.objListDocumentModel != null && objUserSummaryModel.objListDocumentModel.Count > 0)
{
objUserSummaryModel.CurrentPage = objUserSummaryModel.objListDocumentModel[0].CurrentPage;
int totalRecord = objUserSummaryModel.objListDocumentModel[0].TotalCount;
if (decimal.Remainder(totalRecord, objUserSummaryModel.PageSize) > 0)
{
objUserSummaryModel.TotalPages = (totalRecord / objUserSummaryModel.PageSize + 1);
}
else
{
objUserSummaryModel.TotalPages = totalRecord / objUserSummaryModel.PageSize;
}
}
else
{
objUserSummaryModel.TotalPages = 0;
objUserSummaryModel.CurrentPage = 1;
}
}
return(objUserSummaryModel);
}
