private void FillArticle(ArticleRQ articleRQ)
{
try
{
_objDal = new DAL_Article();
var result = _objDal.GetArticle(articleRQ);
grdvwArticle.DataSource = result;
}
catch (Exception)
{
throw;
}
}
public Article GetArticleByID(ArticleRQ _objSearch)
{
Article _ArticleMaster = new Article();
try
{
using (LocalEntity _context = new LocalEntity())
{
var search = from x in _context.tblArticles select x;
if (_objSearch.ArtId > 0)
{
search = from x in search where x.ArtId == _objSearch.ArtId select x;
}
if (!string.IsNullOrWhiteSpace(_objSearch.ArtNo))
{
search = from x in search where x.ArtNo == _objSearch.ArtNo select x;
}
_ArticleMaster = (from s in search
select new Article()
{
ArtId = s.ArtId,
Desc = s.Desc,
ArtNo = s.ArtNo,
Rate = s.Rate,
Unit = s.Unit,
WorkOrderDesc = s.WorkOrderDesc,
IsActive = s.IsActive
}).FirstOrDefault();
}
}
catch (Exception)
{
throw;
}
return(_ArticleMaster);
}
public List <ArticleWithDescRS> GetArticleForInvoice(ArticleRQ _objSearch)
{
List <ArticleWithDescRS> _lstArtMaster = new List <ArticleWithDescRS>();
try
{
using (LocalEntity _context = new LocalEntity())
{
_lstArtMaster = (from a in _context.tblArticles
select new ArticleWithDescRS()
{
ArtId = a.ArtId,
ArtNo = a.ArtNo,
ArtNoWithDesc = a.Desc
}
).ToList();
return(_lstArtMaster);
}
}
catch (Exception) { }
return(_lstArtMaster);
}
public List <ArticleRS> GetArticle(ArticleRQ _objSearch)
{
List <ArticleRS> _lstArtMaster = new List <ArticleRS>();
try
{
using (LocalEntity _context = new LocalEntity())
{
var search = _context.tblArticles.AsQueryable();
if (!string.IsNullOrWhiteSpace(_objSearch.Desc))
{
search = (from x in search
where x.Desc.Contains(_objSearch.Desc)
select x);
}
if (!string.IsNullOrWhiteSpace(_objSearch.ArtNo))
{
search = (from x in search
where x.ArtNo == _objSearch.ArtNo
select x);
}
_lstArtMaster = (from s in search
select new ArticleRS()
{
ArtId = s.ArtId,
ArtNo = s.ArtNo,
Desc = s.Desc
}).OrderBy(x => x.Desc).ToList();
}
}
catch (Exception)
{
throw;
}
return(_lstArtMaster);
}
