/// <summary>
/// Get All Document Response User
/// </summary>
/// <param name="ObjViewDocumentUserResponseModel"></param>
/// <returns></returns>
public ViewDocumentUserResponseModel GetAllDocumentResponseUser(ViewDocumentUserResponseModel ObjViewDocumentUserResponseModel)
{
//initialize ViewDocumentUserResponseModel lstDocumentUserResponseModel
ObjViewDocumentUserResponseModel.lstDocumentUserResponseModel = new List <DocumentUserResponseModel>();
//Call DLDocument for Get All Document Response User using filters
DataSet dtDocument = objDLDocument.GetAllDocumentResponseUser(ObjViewDocumentUserResponseModel);
if (dtDocument != null && dtDocument.Tables[0].Rows.Count > 0)
{
ObjViewDocumentUserResponseModel.DocumentName = dtDocument.Tables[0].Rows[0]["DocumentTitle"].ToString();
ObjViewDocumentUserResponseModel.DocumentDescription = dtDocument.Tables[0].Rows[0]["DocumentDescription"].ToString();
}
//Check dtDocument not null and Rows count
if (dtDocument != null && dtDocument.Tables[1].Rows.Count > 0)
{
for (int i = 0; i < dtDocument.Tables[1].Rows.Count; i++)
{
//Convert DataRow to DocumentUserResponseModel Row and adding in lstDocumentUserResponseModel
ObjViewDocumentUserResponseModel.lstDocumentUserResponseModel.Add(GetDataRowToEntity <DocumentUserResponseModel>(dtDocument.Tables[1].Rows[i]));
}
int totalRecord = Convert.ToInt32(dtDocument.Tables[1].Rows[0]["TotalCount"]);
//calculating total paging
ObjViewDocumentUserResponseModel.TotalPages = TotalPage(totalRecord, ObjViewDocumentUserResponseModel.PageSize);
}
else
{
//if Return o rows then set defualt values for TotalPages and CurrentPage
ObjViewDocumentUserResponseModel.TotalPages = 0;
ObjViewDocumentUserResponseModel.CurrentPage = 1;
}
return(ObjViewDocumentUserResponseModel);
}
/// <summary>
/// Get All Document Response User
/// </summary>
/// <param name="objViewDocumentUserResponseModel"></param>
/// <returns></returns>
public DataSet GetAllDocumentResponseUser(ViewDocumentUserResponseModel objViewDocumentUserResponseModel)
{
try
{
//Set Param values by objViewDocumentUserResponseModel
SqlParameter[] Param =
{
new SqlParameter("@DocumentID", objViewDocumentUserResponseModel.DocumentID),
new SqlParameter("@UserName", objViewDocumentUserResponseModel.UserName),
new SqlParameter("@CurrentPage", objViewDocumentUserResponseModel.CurrentPage),
new SqlParameter("@PageSize", objViewDocumentUserResponseModel.PageSize),
new SqlParameter("@SortBy", string.IsNullOrWhiteSpace(objViewDocumentUserResponseModel.SortBy) == true ? "" : objViewDocumentUserResponseModel.SortBy),
new SqlParameter("@SortOrder", objViewDocumentUserResponseModel.SortOrder)
};
//Call spGetDocumentResponseUserList Procedure
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.WEB_GetDocumentResponseUserList, Param);
if (ds != null)
{
return(ds);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult ViewDocumentUser(string prm = "")
{
ViewDocumentUserResponseModel ObjViewDocumentUserResponseModel = new ViewDocumentUserResponseModel();
try
{
//initial set of current page, pageSize , Total pages
ObjViewDocumentUserResponseModel.CurrentPage = 1;
ObjViewDocumentUserResponseModel.PageSize = CommonUtils.PageSize;
ObjViewDocumentUserResponseModel.TotalPages = 0;
ObjViewDocumentUserResponseModel.AppID = AppID;
//if prm(Paramter) is not empty means Document user View according to DocumentId
if (!String.IsNullOrEmpty(prm))
{
int DocumentId;
//prm Decrypt by Utility
int.TryParse(CommonUtils.Decrypt(prm), out DocumentId);
//Get Document User By DocumentId
ObjViewDocumentUserResponseModel.DocumentID = DocumentId;
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Document + "/GetAllDocumentResponseUser", ObjViewDocumentUserResponseModel);
ObjViewDocumentUserResponseModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewDocumentUserResponseModel>().Result : null;
ObjViewDocumentUserResponseModel.AppID = AppID;
}
//Set Success Message if comes from save Document page after click on save button
if (!String.IsNullOrEmpty(Convert.ToString(Session["ResultSucessMessage"])))
{
ObjViewDocumentUserResponseModel.Message = Convert.ToString(Session["ResultSucessMessage"]);
ObjViewDocumentUserResponseModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower();
Session["ResultSucessMessage"] = null;
}
else if (!String.IsNullOrEmpty(Convert.ToString(Session["ResultNoticeMessage"])))
{
ObjViewDocumentUserResponseModel.Message = Convert.ToString(Session["ResultNoticeMessage"]);
ObjViewDocumentUserResponseModel.MessageType = CommonUtils.MessageType.Notice.ToString().ToLower();
Session["ResultNoticeMessage"] = null;
}
}
catch (Exception ex)
{
ErrorLog(ex, "Document", "ViewDocumentUser GET");
}
return(View("ViewDocumentUser", ObjViewDocumentUserResponseModel));
}
public ActionResult ViewDocumentUser(ViewDocumentUserResponseModel ObjViewDocumentUserResponseModel)
{
try
{
ObjViewDocumentUserResponseModel.Message = ObjViewDocumentUserResponseModel.MessageType = String.Empty;
//Get Document User List based on searching , sorting and paging parameter.
ObjViewDocumentUserResponseModel.AppID = AppID;
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Document + "/GetAllDocumentResponseUser", ObjViewDocumentUserResponseModel);
ObjViewDocumentUserResponseModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewDocumentUserResponseModel>().Result : null;
}
catch (Exception ex)
{
ErrorLog(ex, "Document", "ViewDocumentUser POST");
}
return(PartialView("_ViewDocumentUserList", ObjViewDocumentUserResponseModel));
}
public ViewDocumentUserResponseModel GetAllDocumentResponseUser(ViewDocumentUserResponseModel ObjViewDocumentUserResponseModel)
{
return(objBLDocument.GetAllDocumentResponseUser(ObjViewDocumentUserResponseModel));
}
