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