예제 #1
0
        public List <dynamic> AddActivityReceiptData(ActivityReceiptDetails activityReceiptDetails)
        {
            String insertProcedure = "[CRUD_Activity_Receipt_Master]";

            Dictionary <string, string> input_parameters = new Dictionary <string, string>();

            input_parameters.Add("@pkey_ActivityReceipt_id", 1 + "#bigint#" + activityReceiptDetails.pkey_ActivityReceipt_id);
            input_parameters.Add("@receipt_id", 1 + "#bigint#" + activityReceiptDetails.receipt_id);
            input_parameters.Add("@member_id", 1 + "#bigint#" + activityReceiptDetails.member_id);
            input_parameters.Add("@curr_date", 1 + "#datetime#" + activityReceiptDetails.curr_date);
            input_parameters.Add("@from_date", 1 + "#datetime#" + activityReceiptDetails.from_date);
            input_parameters.Add("@to_date", 1 + "#datetime#" + activityReceiptDetails.to_date);
            input_parameters.Add("@member_name", 1 + "#varchar#" + activityReceiptDetails.member_name);
            input_parameters.Add("@activity_id", 1 + "#bigint#" + activityReceiptDetails.activity_id);
            input_parameters.Add("@branch_id", 1 + "#bigint#" + activityReceiptDetails.branch_id);
            input_parameters.Add("@city_id", 1 + "#bigint#" + activityReceiptDetails.city_id);
            input_parameters.Add("@amount", 1 + "#decimal#" + activityReceiptDetails.amount);
            input_parameters.Add("@paid_by", 1 + "#int#" + activityReceiptDetails.paid_by);
            input_parameters.Add("@cheque_no", 1 + "#varchar#" + activityReceiptDetails.cheque_no);
            input_parameters.Add("@cheque_date", 1 + "#datetime#" + activityReceiptDetails.cheque_date);
            input_parameters.Add("@bank_name", 1 + "#varchar#" + activityReceiptDetails.bank_name);
            input_parameters.Add("@description", 1 + "#varchar#" + activityReceiptDetails.description);
            input_parameters.Add("@Is_MemeberRegister", 1 + "#int#" + activityReceiptDetails.Is_MemeberRegister);

            input_parameters.Add("@UserID", 1 + "#bigint#" + activityReceiptDetails.UserID);
            input_parameters.Add("@is_delete ", 1 + "#int#" + activityReceiptDetails.is_delete);
            input_parameters.Add("@Type", 1 + "#int#" + activityReceiptDetails.Type);
            input_parameters.Add("@pkey_ActivityReceipt_idOut", 2 + "#int#" + null);
            input_parameters.Add("@ReturnValue", 2 + "#int#" + null);


            return(obj.SqlCRUD(insertProcedure, input_parameters));
        }
        public JsonResult  AddReceiptData(ActivityReceiptDetails activityReceiptDetails)
        {
            var Data = activityReceiptDetailsData.AddActivityReceiptData(activityReceiptDetails);

            return(new JsonResult {
                Data = Data, JsonRequestBehavior = JsonRequestBehavior.AllowGet
            });
        }