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