public string Get_MaterialByCode(string code)
{
Model_Materials _mat = _materialrepo.GetmaterialByCode(code.ToLower());
string myjsonresult = new JavaScriptSerializer().Serialize(_mat);
return(myjsonresult);
}
public string Check_Materials(string code)
{
string json = string.Empty;
Model_Materials m = _materialrepo.GetmaterialByCode(code.ToLower());
if (m.Id > 0)
{
json = new JavaScriptSerializer().Serialize(m);
}
return(json);
}
//Get:Not In Use
//public IEnumerable<Model_Materials> NOTINUSEGet_MaterialsList()
//{
// IEnumerable<Model_Materials> _Materials = (from mat in db.tblMaterials
// join pack in db.PackingMasters on mat.PackingCodeId equals pack.PackingCode
// join matclassi in db.MaterialClassifications
// on mat.MaterialClassificationCodeId equals matclassi.MaterialClassificationCode
// where mat.IsDeleted == false
// select new Model_Materials
// {
// Id = mat.Id,
// MaterialCode = mat.MaterialCode,
// MaterialDesc = mat.MaterialDesc,
// PackingCode = pack.PackingCode,
// MaterialClassificationCode = matclassi.MaterialClassificationCode
// }).ToList();
// return _Materials;
//}
//Get:Material By Material Code
public Model_Materials GetmaterialByCode(string code)
{
var data = (from t in db.tblMaterials
join p in db.PackingMasters on t.PackingCodeId equals p.PackingCode
join mc in db.MaterialClassifications on t.MaterialClassificationCodeId equals mc.MaterialClassificationCode
where t.MaterialCode == code && t.IsDeleted == false
select new { t.Id, t.MaterialCode, t.MaterialDesc, p.PackingCode, mc.MaterialClassificationCode }).FirstOrDefault();
Model_Materials _mat = new Model_Materials();
if (data != null)
{
_mat.Id = data.Id;
_mat.MaterialCode = data.MaterialCode;
_mat.MaterialDesc = data.MaterialDesc;
_mat.PackingCode = data.PackingCode;
_mat.MaterialClassificationCode = data.MaterialClassificationCode;
}
return(_mat);
}
