コード例 #1
0
        public ActionResult AddRejectionEntryDetails()
        {
            RejectionEntryDetails data = new RejectionEntryDetails();

            data.Rejection_Reason_Id    = 2;
            data.Rejection_Type_Id      = 2;
            data.Prod_Entry_Id          = 2;
            ViewData["RejectionReason"] = binddropdown("RejectionReason", 0);
            ViewData["RejectionType"]   = binddropdown("RejectionType", 0);
            ViewData[""] = binddropdown("", 0);
            return(View("AddProductionEntry", data));
        }
コード例 #2
0
        public ActionResult UpadteRejectionEntryDetails(RejectionEntryDetails RED)
        {
            ReydeldbContext _db = new ReydeldbContext();
            var             res = _db.Database.ExecuteSqlCommand(@"exec USPUpdateUpadteRejectionEntryDetails @Rejection_Entry_Id,@Rejection_From,  @Prod_Entry_Id,  @Rejection_Type_Id,  @Rejection_Reason_Id,  @Rejection_Qty,  @lumps",
                                                                 new SqlParameter("@Rejection_Entry_Id", RED.Rejection_Entry_Id),
                                                                 new SqlParameter("@Rejection_From", RED.Rejection_from),
                                                                 new SqlParameter("@Prod_Entry_Id", RED.Prod_Entry_Id),
                                                                 new SqlParameter("@Rejection_Type_Id", RED.Rejection_Type_Id),
                                                                 new SqlParameter("@Rejection_Reason_Id", RED.Rejection_Reason_Id),
                                                                 new SqlParameter("@Rejection_Qty", RED.Rejection_Qty),
                                                                 new SqlParameter("@lumps", RED.Lumps));

            return(Json("data Updated"));
        }
コード例 #3
0
        public ActionResult AddRejectionEntryDetails(RejectionEntryDetails RED)
        {
            ReydeldbContext dbc = new ReydeldbContext();
            var             res = dbc.Database.ExecuteSqlCommand(@"exec USPInsertRejection_Entry_Details  @Rejection_from,@Prod_Entry_Id,@Rejection_Type_Id,@Rejection_Reason_Id,@Rejection_Qty,@Lumps",
                                                                 new SqlParameter("@Rejection_from", RED.Rejection_from),
                                                                 new SqlParameter("@Prod_Entry_Id", RED.Prod_Entry_Id),
                                                                 new SqlParameter("@Rejection_Type_Id", RED.Rejection_Type_Id),
                                                                 new SqlParameter("@Rejection_Reason_Id", RED.Rejection_Reason_Id),
                                                                 new SqlParameter("@Rejection_Qty", RED.Rejection_Qty),
                                                                 new SqlParameter("@Lumps", RED.Lumps));


            return(Json("data inserted"));
        }