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