public void gotokdp(BACAClient.Model.Knowledge model) { if (model.TypeId == 3) { new PDF { Id = model.Id, TypeId = model.TypeId }.Show(); } else { this.returnsearch = new ReturnSearch(); if (this.IsReturn) { SystemEnum.ISRETURN yES = SystemEnum.ISRETURN.YES; this.returnsearch.IsReturn = yES.ToString(); } else { this.returnsearch.IsReturn = SystemEnum.ISRETURN.NO.ToString(); } this.returnsearch.TypeId = 0; this.returnsearch.PageIndex = this.pageIndex; this.returnsearch.SourceId = (int)this.SourceID; this.returnsearch.KeyWord = this.keyword.Text; this.returnsearch.Pages = new PageSwitch().RapidRetrieval; CacheHelper.SetReturnSearch(this.returnsearch); CacheHelper.SetCache(this.cache.HistoryIndex, string.Empty); CacheHelper.SetCache(this.cache.Id, model.Id.ToString()); base.ParentWindow.PageSwitch(new PageSwitch().kdp); } }
public async Task <ActionResult> SearchAsync(ReturnSearch search) { var meta = await AppUsers.GetCurrentAsync().ConfigureAwait(true); try { var result = await SalesReturnEntries.GetSearchViewAsync(this.Tenant, meta.OfficeId, search).ConfigureAwait(true); return(this.Ok(result)); } catch (Exception ex) { return(this.Failed(ex.Message, HttpStatusCode.InternalServerError)); } }
public async Task <ActionResult> SearchAsync(ReturnSearch search) { var meta = await AppUsers.GetCurrentAsync().ConfigureAwait(true); search.From = search.From == DateTime.MinValue ? DateTime.Today : search.From; search.To = search.To == DateTime.MinValue ? DateTime.Today : search.To; try { var result = await PurchaseReturns.GetSearchViewAsync(this.Tenant, meta.OfficeId, search).ConfigureAwait(true); return(this.Ok(result)); } catch (Exception ex) { return(this.Failed(ex.Message, HttpStatusCode.InternalServerError)); } }
public static void SetReturnSearch(ReturnSearch model) { try { CacheParameterName name = new CacheParameterName(); SetCache(name.IsReturn, model.IsReturn); SetCache(name.TypeId, model.TypeId.ToString()); SetCache(name.SourceId, model.SourceId.ToString()); SetCache(name.PageIndex, model.PageIndex.ToString()); SetCache(name.Key, model.Key); SetCache(name.keyword, model.KeyWord); SetCache(name.Category, model.Category); SetCache(name.Pages, model.Pages); SetCache(name.Isdell, model.Isdell.ToString()); } catch { } }
public void RadioChecked() { try { this.returnsearch = CacheHelper.GetReturnSearchModel(); if (this.returnsearch != null) { SystemEnum.ISRETURN yES = SystemEnum.ISRETURN.YES; if (this.returnsearch.IsReturn == yES.ToString()) { this.pageIndex = this.returnsearch.PageIndex; } this.keyword.Text = this.returnsearch.KeyWord; switch (this.returnsearch.SourceId) { } } } catch { } }
public static ReturnSearch GetReturnSearchModel() { try { CacheParameterName name = new CacheParameterName(); ReturnSearch search = new ReturnSearch { IsReturn = GetCache(name.IsReturn) }; if (!string.IsNullOrEmpty(GetCache(name.TypeId))) { search.TypeId = int.Parse(GetCache(name.TypeId)); } if (!string.IsNullOrEmpty(GetCache(name.SourceId))) { search.SourceId = int.Parse(GetCache(name.SourceId)); } if (!string.IsNullOrEmpty(GetCache(name.PageIndex))) { search.PageIndex = int.Parse(GetCache(name.PageIndex)); } if (!string.IsNullOrEmpty(GetCache(name.Isdell))) { search.Isdell = int.Parse(GetCache(name.Isdell)); } search.Key = GetCache(name.Key); search.KeyWord = GetCache(name.keyword); search.Category = GetCache(name.Category); search.Pages = GetCache(name.Pages); search.UserId = GetCache(name.LoginUserID); return(search); } catch (Exception) { return(null); } }
public static async Task <IEnumerable <dynamic> > GetSearchViewAsync(string tenant, int officeId, ReturnSearch search) { using (var db = DbProvider.Get(FrapidDbServer.GetConnectionString(tenant), tenant).GetDatabase()) { var sql = new Sql("SELECT * FROM sales.return_search_view"); sql.Where("value_date BETWEEN @0 AND @1", search.From, search.To); sql.And("LOWER(tran_id) LIKE @0", search.TranId.ToSqlLikeExpression().ToLower()); sql.And("LOWER(tran_code) LIKE @0", search.TranCode.ToSqlLikeExpression().ToLower()); sql.And("LOWER(COALESCE(reference_number, '')) LIKE @0", search.ReferenceNumber.ToSqlLikeExpression().ToLower()); sql.And("LOWER(COALESCE(statement_reference, '')) LIKE @0", search.StatementReference.ToSqlLikeExpression().ToLower()); sql.And("LOWER(posted_by) LIKE @0", search.PostedBy.ToSqlLikeExpression().ToLower()); sql.And("LOWER(office) LIKE @0", search.Office.ToSqlLikeExpression().ToLower()); sql.And("LOWER(COALESCE(status, '')) LIKE @0", search.Status.ToSqlLikeExpression().ToLower()); sql.And("LOWER(COALESCE(verified_by, '')) LIKE @0", search.VerifiedBy.ToSqlLikeExpression().ToLower()); sql.And("LOWER(COALESCE(reason, '')) LIKE @0", search.Reason.ToSqlLikeExpression().ToLower()); sql.And("LOWER(COALESCE(customer, '')) LIKE @0", search.Customer.ToSqlLikeExpression().ToLower()); if (search.Amount > 0) { sql.And("total_amount = @0", search.Amount); } sql.And("office_id IN(SELECT * FROM core.get_office_ids(@0))", officeId); return(await db.SelectAsync <dynamic>(sql).ConfigureAwait(false)); } }