C# (CSharp) SmsContext.SP_GET_DE_OF_RE_2_PR_BY_ST_AND_INV_ID Examples

Example #1

        public ActionResult Export2Provider(int id, int?storeId)
        {
            if (id <= 0)
            {
                ViewBag.Message = "Không tìm thấy phiếu xuất kho tương ứng.";
                return(View("../Home/Error"));;
            }
            var ctx   = new SmsContext();
            var Infor = ctx.TRA_HANG_NCC.Include("NHA_CUNG_CAP").Where(u => u.ACTIVE == "A" && u.ID == id).FirstOrDefault();

            if (Infor == null)
            {
                ViewBag.Message = "Không tìm thấy phiếu xuất kho tương ứng.";
                ctx.Dispose();
                return(View("../Home/Error"));
            }
            var details = ctx.SP_GET_DE_OF_RE_2_PR_BY_ST_AND_INV_ID(Convert.ToInt32(storeId), id).Take(SystemConstant.MAX_ROWS).ToList <SP_GET_DE_OF_RE_2_PR_BY_ST_AND_INV_ID_Result>();
            Export2ProviderModel model = new Export2ProviderModel();

            model.TheList = details;
            model.Infor   = Infor;
            model.StoreId = Convert.ToInt32(storeId);
            ctx.Dispose();
            return(View(model));
        }